1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
| Private Sub TransfertDetailDataGridView_CellEndEdit_1(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles TransfertDetailDataGridView.CellEndEdit
Dim db As New EasyContextDataContext
If Me.TransfertDetailDataGridView.CurrentCell.ColumnIndex = DataGridViewTextBoxColumn2.Index Then
Me.tsansitbox.Text = TransfertDetailDataGridView(1, CInt(TransfertDetailDataGridView.CurrentRow.Index)).Value
Dim avail = From ava In db.AvailablaStocks Where ava.ProductID = CInt(Me.tsansitbox.Text) And ava.StoreID = Me.ComboBox1.SelectedValue Select ava.AvailStock, ava.ProductID
Dim availa = (From av In db.AvailablaStocks Where av.StoreID Like ComboBox2.SelectedValue And av.ProductID Like CInt(Me.tsansitbox.Text) _
Select av.AvailStock).First
Try
TransfertDetailDataGridView(4, CInt(TransfertDetailDataGridView.CurrentRow.Index)).Value = avail.First.AvailStock
TransfertDetailDataGridView(5, CInt(TransfertDetailDataGridView.CurrentRow.Index)).Value = availa.Value
Catch ex As Exception
MsgBox(ex.Message, , "EasyPharma")
End Try
ElseIf Me.TransfertDetailDataGridView.CurrentCell.ColumnIndex = DataGridViewTextBoxColumn3.Index Then
Try
Me.Validate()
Me.TransfertDetailBindingSource.EndEdit()
Me.StockTransfertBindingSource.EndEdit()
Me.TableAdapterManager.UpdateAll(Me.Productlinkset)
Catch ex As Exception
MsgBox(ex.Message & " " & "Pas enregistré, recommencer et renseigné toutes les rubriques depuis le haut du formulaire", , "EasyPharma")
TransfertDetailDataGridView.Rows.Remove(TransfertDetailDataGridView.CurrentRow)
End Try
End If
End Sub |
Partager