private void SaveCollection() { DataClasses1DataContext db = new DataClasses1DataContext(); using (var scope = new System.Transactions.TransactionScope()) { foreach (DataGridViewRow row in dataGridView3.Rows) { Edison_DispatchPayment AddItems1 = new Edison_DispatchPayment(); AddItems1.Date = dateTimePicker1.Value; AddItems1.CustID = Convert.ToInt32(row.Cells[1].Value.ToString() == "" ? "0" : row.Cells[1].Value.ToString()); AddItems1.Amount = Convert.ToDecimal(row.Cells[5].Value.ToString() == "" ? "0" : row.Cells[5].Value.ToString()); AddItems1.DispatchNo = Convert.ToInt32(textBox4.Text); db.Edison_DispatchPayments.InsertOnSubmit(AddItems1); db.SubmitChanges(); } scope.Complete(); } INV_RevertState(); Inv_DisableAll(); db.Dispose(); form1.RefreshForm(); }
private void INV_btnEditSave_Click(object sender, EventArgs e) { DataClasses1DataContext db = new DataClasses1DataContext(); using (var scope = new System.Transactions.TransactionScope()) { var ba = from s in db.Edison_DispatchPayments where s.DispatchNo.Equals(textBox4.Text) select s; if (ba.Any()) { foreach (var d in ba) { db.Edison_DispatchPayments.DeleteOnSubmit(d); db.SubmitChanges(); } } foreach (DataGridViewRow row in dataGridView3.Rows) { Edison_DispatchPayment AddItems1 = new Edison_DispatchPayment(); AddItems1.Date = dateTimePicker1.Value; AddItems1.CustID = Convert.ToInt32(row.Cells[1].Value.ToString() == "" ? "0" : row.Cells[1].Value.ToString()); AddItems1.Amount = Convert.ToDecimal(row.Cells[5].Value.ToString() == "" ? "0" : row.Cells[5].Value.ToString()); AddItems1.VanNo = Convert.ToInt32(InvVanNo.EditValue); AddItems1.EmpCode = Convert.ToInt32(InvSalesAgent.EditValue); AddItems1.DispatchNo = Convert.ToInt32(textBox4.Text); db.Edison_DispatchPayments.InsertOnSubmit(AddItems1); db.SubmitChanges(); } INV_RevertState(); Inv_DisableAll(); scope.Complete(); } form1.RefreshForm(); }