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