public List<ManagementEntityLevelsViewModel> ManagementEntityLevelByCompanyVM(int CompanyID)
{
List<ManagementEntityLevelsViewModel> l = new List<ManagementEntityLevelsViewModel>();
var query = from p in context.ManagementEntityLevels
where p.IsDeleted == false && p.CompanyID == CompanyID
orderby p.Description
select p;
foreach (var item in query)
{
ManagementEntityLevelsViewModel m = new ManagementEntityLevelsViewModel();
m.ManagementEntityLevelID = item.ManagementEntityLevelID;
m.Description = item.Description;
m.CompanyID = item.CompanyID;
m.LevelNumber = item.LevelNumber;
l.Add(m);
}
return l;
}
public void SaveManagementEntityLevel(ManagementEntityLevelsViewModel managementEntityLevelVM)
{
if (managementEntityLevelVM.ManagementEntityLevelID == 0)
{
ManagementEntityLevel o = new ManagementEntityLevel();
o.LastModified = DateTime.UtcNow;
o.LastModifiedBy = "System";
o.RecordAdded = DateTime.UtcNow;
o.RecordAddedBy = "System";
o.IsDeleted = false;
o.CompanyID = managementEntityLevelVM.CompanyID;
o.Description = managementEntityLevelVM.Description;
o.LevelNumber = managementEntityLevelVM.LevelNumber;
context.ManagementEntityLevels.Add(o);
}
else
{
ManagementEntityLevel dbEntry = context.ManagementEntityLevels.Find(managementEntityLevelVM.ManagementEntityLevelID);
if (dbEntry != null)
{
dbEntry.LastModified = DateTime.UtcNow;
dbEntry.LastModifiedBy = "System";
dbEntry.Description = managementEntityLevelVM.Description;
dbEntry.CompanyID = managementEntityLevelVM.CompanyID;
dbEntry.LevelNumber = managementEntityLevelVM.LevelNumber;
}
}
context.SaveChanges();
}
