private TblPromoHeader UpdateOrInsertTblPromoHeader(TblPromoHeader newRow, string company)
{
using (var context = new ccnewEntities(GetSqlConnectionString(company)))
{
var oldRow = (from e in context.TblPromoHeaders
where e.GlSerial == newRow.GlSerial
select e).SingleOrDefault();
if (oldRow != null)
{
GenericUpdate(oldRow, newRow, context);
foreach (var item in newRow.TblPromoCriterias)
{
UpdateOrInsertTblPromoCriteria(item, context);
}
}
else
{
newRow.CreateDate = DateTime.Now;
context.TblPromoHeaders.AddObject(newRow);
}
context.SaveChanges();
return(newRow);
}
}
private int DeleteTblPromoHeader(TblPromoHeader row, string company)
{
using (var context = new ccnewEntities(GetSqlConnectionString(company)))
{
var oldRow = (from e in context.TblPromoHeaders
where e.GlSerial == row.GlSerial
select e).SingleOrDefault();
if (oldRow != null)
{
context.DeleteObject(oldRow);
context.SaveChanges();
}
return(row.GlSerial);
}
}
public void Delete()
{
var data = new TblPromoHeader();
data.InjectFrom(TransactionHeader);
if (AllowDelete)
{
Loading = true;
Client.DeleteTblPromoHeaderAsync(data, LoggedUserInfo.DatabasEname);
}
else
{
MessageBox.Show("You are Not Allowed to Delete");
}
}
public void UpdateAndInsert()
{
var valiationCollection = new List <ValidationResult>();
bool isvalid = Validator.TryValidateObject(TransactionHeader, new ValidationContext(TransactionHeader, null, null), valiationCollection, true);
if (isvalid)
{
var data = new TblPromoHeader();
data.InjectFrom(TransactionHeader);
bool save = TransactionHeader.GlSerial == 0;
if (save)
{
if (AllowAdd)
{
Loading = true;
Client.UpdateOrInsertTblPromoHeaderAsync(data, LoggedUserInfo.DatabasEname);
}
else
{
MessageBox.Show("You are Not Allowed to Add");
}
}
else
{
if (AllowUpdate)
{
Loading = true;
Client.UpdateOrInsertTblPromoHeaderAsync(data, LoggedUserInfo.DatabasEname);
}
else
{
MessageBox.Show("You are Not Allowed to Update");
}
}
}
}
