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(); }