public void SaveOldDetailRow(TblGlRuleMainDetailViewModel oldRow)
{
if (oldRow != null)
{
var valiationCollection = new List <ValidationResult>();
var isvalid = Validator.TryValidateObject(oldRow,
new ValidationContext(oldRow, null, null), valiationCollection, true);
if (isvalid)
{
var save = oldRow.Iserial == 0;
if (AllowUpdate != true && !save)
{
MessageBox.Show(strings.AllowUpdateMsg);
return;
}
var saveRow = new TblGlRuleMainDetail();
saveRow.InjectFrom(oldRow);
if (SelectedMainRow != null && SelectedMainRow.DetailsList != null)
{
Glclient.UpdateOrInsertTblGlRuleMainDetailsAsync(saveRow, save, SelectedMainRow.DetailsList.IndexOf(oldRow),
LoggedUserInfo.DatabasEname);
}
}
}
}
public void SaveDetailRow()
{
if (SelectedDetailRow != null)
{
var valiationCollection = new List <ValidationResult>();
var isvalid = Validator.TryValidateObject(SelectedDetailRow,
new ValidationContext(SelectedDetailRow, null, null), valiationCollection, true);
if (isvalid)
{
var save = SelectedDetailRow.Iserial == 0;
if (SelectedDetailRow.TblGlRuleHeader == 0)
{
SelectedDetailRow.TblGlRuleHeader = SelectedMainRow.Iserial;
}
if (AllowUpdate != true && !save)
{
MessageBox.Show(strings.AllowUpdateMsg);
return;
}
var rowToSave = new TblGlRuleMainDetail();
rowToSave.InjectFrom(SelectedDetailRow);
Glclient.UpdateOrInsertTblGlRuleMainDetailsAsync(rowToSave, save,
SelectedMainRow.DetailsList.IndexOf(SelectedDetailRow), LoggedUserInfo.DatabasEname);
}
}
}
private int DeleteTblGlRuleMainDetail(TblGlRuleMainDetail row, int index, string company)
{
using (var entity = new ccnewEntities(GetSqlConnectionString(company)))
{
var query = (from e in entity.TblGlRuleMainDetails
where e.Iserial == row.Iserial
select e).SingleOrDefault();
if (query != null)
{
entity.DeleteObject(query);
}
entity.SaveChanges();
}
return(row.Iserial);
}
private TblGlRuleMainDetail UpdateOrInsertTblGlRuleMainDetails(TblGlRuleMainDetail newRow, bool save, int index, out int outindex, string company)
{
outindex = index;
using (var entity = new ccnewEntities(GetSqlConnectionString(company)))
{
if (save)
{
entity.TblGlRuleMainDetails.AddObject(newRow);
}
else
{
var oldRow = (from e in entity.TblGlRuleMainDetails
where e.Iserial == newRow.Iserial
select e).SingleOrDefault();
if (oldRow != null)
{
GenericUpdate(oldRow, newRow, entity);
}
}
entity.SaveChanges();
return(newRow);
}
}