public static List <ClearanceReportPurposes> GetReportPurposes() { List <ClearanceReportPurposes> list = new List <ClearanceReportPurposes>(); //for (int i = 0; i < purposeTypes.Count(); i++) { // var hasEntry = maintenanceTables.Where(x => x.MaintenanceEntryName == purposeTypes[i].) //} using (var db = new BrgyMgmtEntities()) { var clearances = db.Clearances.Include("MaintenanceTables").ToList(); var purposeTypes = db.MaintenanceTables.Where(x => x.MaintenanceTableType == "Clearance"); foreach (var clearance in clearances) { foreach (var purpose in purposeTypes) { list.Add(new ClearanceReportPurposes { ClearanceId = clearance.ClearanceId, isUsed = clearance.MaintenanceTables.Where(x => x.MaintenanceEntryName == purpose.MaintenanceEntryName).Count() > 0, ReportPurpose = purpose.MaintenanceEntryName }); //list.Add(new ClearanceReportPurposes { isUsed = clearances.Where(x => x.MaintenanceTables == purpose.MaintenanceEntryName).Count() > 0, ReportPurpose = purpose.MaintenanceEntryName }); //var clearanceReportPurpose = new ClearanceReportPurposes { isUsed = maintenanceTables.Where(x => x.MaintenanceEntryName == purpose.MaintenanceEntryName).Count() > 0, ReportPurpose = purpose.MaintenanceEntryName }; } } } return(list); }
public static void Update(BarangayProfileData data) { using (var db = new BrgyMgmtEntities()) { foreach (PropertyInfo prop in data.GetType().GetProperties()) { ConfigData item = db.ConfigData.Where(x => x.ConfigName == prop.Name).SingleOrDefault(); item.ConfigValue = prop.GetValue(data, null).ToString() ?? item.ConfigValue; } db.SaveChanges(); } }
public static BarangayProfileData Get() { BarangayProfileData profile = new BarangayProfileData(); using (var db = new BrgyMgmtEntities()) { profile.BarangayName = (db.ConfigData.Where(x => x.ConfigName == "BarangayName").SingleOrDefault()).ConfigValue; profile.Municipality = (db.ConfigData.Where(x => x.ConfigName == "Municipality").SingleOrDefault()).ConfigValue; profile.Province = (db.ConfigData.Where(x => x.ConfigName == "Province").SingleOrDefault()).ConfigValue; profile.ZIP = (db.ConfigData.Where(x => x.ConfigName == "ZIP").SingleOrDefault()).ConfigValue; profile.Slogan1 = (db.ConfigData.Where(x => x.ConfigName == "Slogan1").SingleOrDefault()).ConfigValue; profile.Slogan2 = (db.ConfigData.Where(x => x.ConfigName == "Slogan2").SingleOrDefault()).ConfigValue; profile.History = (db.ConfigData.Where(x => x.ConfigName == "History").SingleOrDefault()).ConfigValue; profile.Demographics = (db.ConfigData.Where(x => x.ConfigName == "Demographics").SingleOrDefault()).ConfigValue; //profile.Logo = (db.ConfigData.Where(x => x.ConfigName == "Logo").SingleOrDefault()).ConfigValue; //var properties = TypeDescriptor.GetProperties(typeof(Models.BarangayProfile)); //foreach (PropertyDescriptor property in properties) { // var val = db.UnitDetails.Where(x => x.UnitName == property.Name); } return(profile); }
public UserStore(BrgyMgmtEntities db) { this.db = db ?? throw new ArgumentNullException("db"); }
public RoleStore(BrgyMgmtEntities db) { this.db = db; }