private TblContractPaymentByPeriod UpdateOrInsertContractPaymentDetail(
TblContractPaymentByPeriod newRow, int userIserial, int index, out int outindex)
{
outindex = index;
newRow.TblContractHeader1 = null;
using (var context = new WorkFlowManagerDBEntities())
{
var oldRow = (from e in context.TblContractPaymentByPeriods
where e.Iserial == newRow.Iserial
select e).SingleOrDefault();
if (oldRow != null)
{
//context.Entry(oldRow).CurrentValues.SetValues(newRow);
var result = SharedOperation.GenericUpdate(oldRow, newRow, context);
if (result.Count() > 0)
{
oldRow.LastChangeDate = DateTime.Now;
oldRow.LastChangeUser = userIserial;
}
}
else
{
newRow.CreatedBy = userIserial;
newRow.LastChangeUser = userIserial;
newRow.CreationDate = DateTime.Now;
newRow.LastChangeDate = DateTime.Now;
context.TblContractPaymentByPeriods.AddObject(newRow);
}
context.SaveChanges();
return(newRow);
}
}
private TblContractPaymentByPeriod DeleteContractPaymentDetail(TblContractPaymentByPeriod row)
{
using (var context = new WorkFlowManagerDBEntities())
{
var oldRow = (from e in context.TblContractPaymentByPeriods
where e.Iserial == row.Iserial
select e).SingleOrDefault();
if (oldRow != null)
{
context.DeleteObject(oldRow);
}
context.SaveChanges();
}
return(row);
}
