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();
}
