private void CDD_EditSaveEntry()
{
DataClasses1DataContext db = new DataClasses1DataContext();
using (var scope = new System.Transactions.TransactionScope())
{
//Edison_DispatchExpHDR objCourse = new Edison_DispatchExpHDR();
//objCourse.DispatchNo = Convert.ToInt32(searchLookUpEdit13.EditValue);
//objCourse.InsertedDatetime = db.ExecuteQuery<DateTime>("SELECT GETDATE()").First();
//db.Edison_DispatchExpHDRs.InsertOnSubmit(objCourse);
//db.SubmitChanges();
var a = from s in db.Edison_DispatchExpDTLs
where s.DispatchNo.Equals(textBox4.Text)
select s;
if (a.Any())
{
foreach (var d in a)
{
db.Edison_DispatchExpDTLs.DeleteOnSubmit(d);
db.SubmitChanges();
}
}
foreach (DataGridViewRow row in dataGridView5.Rows)
{
Edison_DispatchExpDTL AddItems = new Edison_DispatchExpDTL();
AddItems.DispatchNo = Convert.ToInt32(textBox4.Text);
AddItems.ExpenseID = Convert.ToInt32(row.Cells[1].Value.ToString() == "" ? "0" : row.Cells[1].Value.ToString());
AddItems.Amount = Convert.ToDecimal(row.Cells[3].Value.ToString() == "" ? "0" : row.Cells[3].Value.ToString());
db.Edison_DispatchExpDTLs.InsertOnSubmit(AddItems);
db.SubmitChanges();
}
CD_RevertState();
CD_DisableAll();
scope.Complete();
}
form1.RefreshFormExpense();
}
private void CDD_SaveEntry()
{
DataClasses1DataContext db = new DataClasses1DataContext();
using (var scope = new System.Transactions.TransactionScope())
{
Edison_DispatchExpHDR objCourse = new Edison_DispatchExpHDR();
objCourse.DispatchNo = Convert.ToInt32(textBox4.Text);
objCourse.InsertedDatetime = db.ExecuteQuery <DateTime>("SELECT GETDATE()").First();
db.Edison_DispatchExpHDRs.InsertOnSubmit(objCourse);
db.SubmitChanges();
foreach (DataGridViewRow row in dataGridView5.Rows)
{
Edison_DispatchExpDTL AddItems = new Edison_DispatchExpDTL();
AddItems.DispatchNo = objCourse.DispatchNo;
AddItems.ExpenseID = Convert.ToInt32(row.Cells[1].Value.ToString() == "" ? "0" : row.Cells[1].Value.ToString());
AddItems.Amount = Convert.ToDecimal(row.Cells[3].Value.ToString() == "" ? "0" : row.Cells[3].Value.ToString());
db.Edison_DispatchExpDTLs.InsertOnSubmit(AddItems);
db.SubmitChanges();
// AddItems.SRCode = Convert.ToInt32(row.Cells[11].Value.ToString());
}
scope.Complete();
CD_RevertState();
CD_DisableAll();
}
form1.RefreshFormExpense();
}
