public SavingResult SaveLayout(eGridControlIDs GridID, string Layout, string PrintOptions, string PageSettings, long CompanyID, long FinPerID)
{
SavingResult res = new SavingResult();
//--
using (dbVisionEntities db = new dbVisionEntities())
{
int intGrid = (int)GridID;
tblGridLayout SaveModel = db.tblGridLayouts.FirstOrDefault(r => r.GridID == intGrid && r.CompanyID == CompanyID && r.FinPerID == FinPerID);
if (SaveModel == null) // New Entry
{
SaveModel = new tblGridLayout();
SaveModel.rcuid = Model.CommonProperties.LoginInfo.LoggedinUser.UserID;
SaveModel.rcdt = DateTime.Now;
db.tblGridLayouts.Add(SaveModel);
}
else
{
SaveModel.reuid = Model.CommonProperties.LoginInfo.LoggedinUser.UserID;
SaveModel.redt = DateTime.Now;
db.tblGridLayouts.Attach(SaveModel);
db.Entry(SaveModel).State = System.Data.Entity.EntityState.Modified;
}
SaveModel.GridID = (int)GridID;
SaveModel.Descr = GridID.ToString();
SaveModel.Layout = Layout;
SaveModel.PrintOptions = PrintOptions;
SaveModel.PageSettings = PageSettings;
SaveModel.CompanyID = Model.CommonProperties.LoginInfo.LoggedInCompany.CompanyID;
SaveModel.FinPerID = Model.CommonProperties.LoginInfo.LoggedInFinPeriod.FinPeriodID;
try
{
db.SaveChanges();
res.PrimeKeyValue = SaveModel.GridLayoutID;
res.ExecutionResult = eExecutionResult.CommitedSucessfuly;
}
catch (Exception ex)
{
CommonFunctions.GetFinalError(res, ex);
}
}
return(res);
}
public string GetLayout(eGridControlIDs GridID, long CompanyID, long FinPerID)
{
using (dbVisionEntities db = new dbVisionEntities())
{
tblGridLayout SaveModel = db.tblGridLayouts.FirstOrDefault(r => r.GridID == (int)GridID && r.CompanyID == CompanyID && r.FinPerID == FinPerID);
if (SaveModel == null)
{
SaveModel = db.tblGridLayouts.Where(r => r.GridID == (int)GridID && r.CompanyID == CompanyID).OrderByDescending(r => r.FinPerID).FirstOrDefault();
}
if (SaveModel != null)
{
return(SaveModel.Layout);
}
else
{
return(null);
}
}
}
