public static void Configure(MvcApplication app) { var Dicts = app.Dicts = new Dictionary <string, DictsDTO>(); Dicts[HRDictName] = new DictsDTO() { DictsRetrievalFunction = (MVCControllerDbContexts contexts) => { var IMSDB = contexts.IMS; var dicts = new Dictionary <string, object> { { "Positions", IMSDB.EmployeesPositions.Select(p => new DictItemDTO() { ID = p.Code.ToString(), Name = p.Name + " (" + p.DescrLoc + ")" }).OrderBy(x => x.Name) }, { "Departments", IMSDB.Departments.Select(d => new DictItemDTO() { ID = d.Code, Name = d.Descr }).OrderBy(x => x.Name) }, { "Projects", IMSDB.Projects.Select(d => new DictItemDTO() { ID = d.Code, Name = d.Code + " (" + d.Descr + ")" }).OrderBy(x => x.Name) }, { "Sections", IMSDB.Employees.Select(e => e.Section).Distinct().Where(x => x != null).OrderBy(x => x) }, { "EmployeeGroups", IMSDB.EmployeeGroups.Select(g => new DictItemDTO() { ID = g.Code, Name = g.Descr }).OrderBy(x => x.Name) }, { "Cities", IMSDB.Employees.Select(e => e.City).Distinct().Where(x => x != null).OrderBy(x => x) }, { "Countries", IMSDB.Countries.Select(c => new CountryDTO() { ID = c.Code, Name = c.Descr, CSSIconClass = c.SIDAC.Trim().ToLower(), NationalityName = c.NationalityName }).OrderBy(x => x.Name) }, { "Religions", IMSDB.Employees.Select(e => e.Religion).Distinct().Where(x => x != null).OrderBy(x => x) }, { "PassportIssuedBy", IMSDB.Employees.Select(e => e.PassportIssuedBy).Distinct().Where(x => x != null).OrderBy(x => x) }, { "PassportStatuses", IMSDB.Employees.Select(e => e.PassportStatus).Distinct().Where(x => x != null).OrderBy(x => x) }, { "VisaTypes", IMSDB.VisaTypes.Select(vt => new DictItemDTO() { ID = vt.Code.ToString(), Name = vt.Descr }).OrderBy(x => x.Name) }, { "WorkPermitPositions", IMSDB.Employees.Select(e => e.WorkPermitPosition).Distinct().Where(x => x != null).OrderBy(x => x) }, { "WorkPermitLocations", IMSDB.WorkPermitLocations.Select(loc => new DictItemDTO() { ID = loc.Code.ToString(), Name = loc.Descr }).OrderBy(x => x.Name) }, { "WorkPermitCategories", IMSDB.WorkPermitCategories.Select(cat => new DictItemDTO() { ID = cat.Code.ToString(), Name = cat.Descr }).OrderBy(x => x.Name) }, { "BusinessUnits", IMSDB.BusinessUnits.Select(bu => new DictItemDTO() { ID = bu.Code, Name = bu.Descr }).OrderBy(x => x.Name) }, { "Employees", IMSDB.Employees .Select(emp => new DictItemDTO() { ID = emp.BadgeNumber, Name = emp.FirstName + " " + emp.MiddleName + " " + emp.LastName, IsNotActive = (emp.StatusID == null || emp.StatusID.Value == 8) }) .OrderBy(emp => emp.Name) }, { "EmployeeStatuses", IMSDB.EmployeeStatuses.Select(es => new DictItemDTO() { ID = es.Code.ToString(), Name = es.Descr.Trim() }).OrderBy(x => x.Name) }, { "MaritalStatuses", IMSDB.MaritalStatuses.Select(ms => new DictItemDTO() { ID = ms.Code, Name = ms.Descr }).OrderBy(x => x.Name) }, { "PensionGroups", IMSDB.PensionGroups.Select(ms => new DictItemDTO() { ID = ms.Code.ToString(), Name = ms.Descr }).OrderBy(x => x.Name) }, { "RotationTypes", IMSDB.RotationTypes.Select(rt => new DictItemDTO() { ID = rt.Code.ToString(), Name = rt.DayOn.ToString() + "/" + rt.DayOff.ToString() + " (" + rt.Descr + ")" }).OrderBy(x => x.Name) }, { "ContractTypes", IMSDB.ContractTypes.Select(ct => new DictItemDTO() { ID = ct.Code.ToString(), Name = ct.Descr }).OrderBy(x => x.Name) }, { "Currencies", IMSDB.Currencies.Select(c => new DictItemDTO() { ID = c.Code, Name = c.Code + " (" + c.Descr + ")" }).OrderBy(x => x.Name) }, { "EducationLevels", IMSDB.EducationLevels.Select(l => new DictItemDTO() { ID = l.Code.ToString(), Name = l.Descr }).OrderBy(x => x.Name) }, { "EducationDirections", IMSDB.Employees.Select(e => e.EducationDirection).Distinct().Where(x => x != null).OrderBy(x => x) }, { "EducationMajors", IMSDB.Employees.Select(e => e.EducationMajor).Distinct().Where(x => x != null).OrderBy(x => x) }, { "PaymentTypes", IMSDB.PaymentTypes.Select(pt => new DictItemDTO() { ID = pt.Code.ToString(), Name = pt.Descr }).OrderBy(x => x.Name) }, { "Banks", IMSDB.Banks.Select(b => new DictItemDTO() { ID = b.Code.ToString(), Name = b.Name + (b.BankCode != null ? (", " + b.BankCode) : "") + (b.BranchCode != null ? (", " + b.BranchCode) : "") }).OrderBy(x => x.Name) }, { "RelationshipTypes", IMSDB.RelationshipTypes.Select(rt => new DictItemDTO() { ID = rt.Code.ToString(), Name = rt.Descr }).OrderBy(x => x.Name) }, { "Genders", new[] { new DictItemDTO() { ID = "M", Name = "Male" }, new DictItemDTO() { ID = "F", Name = "Female" } } }, { "ProfessionalRoles", IMSDB.ProfessionalRoles.Select(pr => new DictItemDTO() { ID = pr.Code, Name = pr.Code + ", " + (pr.Descr + " (" + pr.Family.Descr + ")").Replace(" ()", string.Empty) }).OrderBy(x => x.Name) }, { "HOBUnits", IMSDB.HOBUnits.Select(u => new DictItemDTO() { ID = u.Code, Name = u.Descr }).OrderBy(x => x.Name) }, { "BOCUnits", IMSDB.BOCUnits.Select(u => new DictItemDTO() { ID = u.Code, Name = u.Descr }).OrderBy(x => x.Name) }, { "EmployeeStatusReasons", IMSDB.EmployeeStatusReasons.Select(u => new DictItemDTO() { ID = u.Code.ToString(), Name = u.Descr }).OrderBy(x => x.Name) }, { "CostCenters", IMSDB.CostCenters.Select(cc => new DictItemDTO() { ID = cc.Code, Name = cc.Code + " (" + cc.Descr + ")" }).OrderBy(x => x.Name) }, { "CREAValues", IMSDB.CREAValues.Select(c => new DictItemDTO() { ID = c.Code, Name = c.Descr }).OrderBy(x => x.Name) }, { "EmployeeLevels", IMSDB.EmployeeLevels.Select(l => new DictItemDTO() { ID = l.Code.ToString(), Name = l.Level + " (" + l.Descr + ")" }).OrderBy(x => x.Name) }, { "Qualifications", IMSDB.EmployeeQualifications.Select(q => new DictItemDTO() { ID = q.Code.ToString(), Name = q.Descr }).OrderBy(x => x.Name) }, { "WorkLocations", IMSDB.WorkLocations.Select(wl => new DictItemDTO() { ID = wl.Code.ToString(), Name = wl.Descr }).OrderBy(x => x.Name) }, { "EmployeeClasses", IMSDB.EmployeeClasses.Select(c => new DictItemDTO() { ID = c.Code, Name = c.Descr }).OrderBy(x => x.Name) }, { "KeyResources", IMSDB.KeyResources.Select(res => new DictItemDTO() { ID = res.Code.ToString(), Name = res.Descr }).OrderBy(x => x.Name) }, { "Nationalizations", IMSDB.Nationalizations.Select(n => new DictItemDTO() { ID = n.Code.ToString(), Name = n.Descr }).OrderBy(x => x.Name) }, { "SiteAllowanceTypes", new[] { new DictItemDTO() { ID = "0", Name = "Daily" }, new DictItemDTO() { ID = "1", Name = "Monthly" } } }, { "LivingAllowanceTypes", new[] { new DictItemDTO() { ID = "0", Name = "Daily KZT" }, new DictItemDTO() { ID = "1", Name = "Monthly KZT" } } }, { "UnionGroups", IMSDB.UnionGroups.Select(g => new DictItemDTO() { ID = g.Code, Name = g.Descr }).OrderBy(x => x.Name) }, { "AirlineTicketTypes", IMSDB.TicketTypes.Select(t => new DictItemDTO() { ID = t.Code.ToString(), Name = t.Descr }).OrderBy(x => x.Name) }, { "DeathInsuranceTypes", IMSDB.DeathInsuranceTypes.Select(t => new DictItemDTO() { ID = t.Code.ToString(), Name = System.Data.Entity.SqlServer.SqlFunctions.StringConvert(t.Amount) }).OrderBy(x => x.Name) }, { "MedInsuranceTypes", IMSDB.MedInsuranceTypes.Select(t => new DictItemDTO() { ID = t.Code.ToString(), Name = t.Descr }).OrderBy(x => x.Name) }, { "LifeInsuranceTypes", IMSDB.LifeInsuranceTypes.Select(t => new DictItemDTO() { ID = t.Code.ToString(), Name = System.Data.Entity.SqlServer.SqlFunctions.StringConvert(t.Amount) }).OrderBy(x => x.Name) }, { "IncomeProtectionTypes", IMSDB.IncomeProtectionTypes.Select(t => new DictItemDTO() { ID = t.Code.ToString(), Name = t.Descr }).OrderBy(x => x.Name) }, { "EmployeeCategories", new[] { new DictItemDTO() { ID = "E", Name = "Expat" }, new DictItemDTO() { ID = "L", Name = "Local" } } }, { "BirthPlaces", IMSDB.Employees.Select(e => e.BirthPlace).Distinct().Where(x => x != null).OrderBy(x => x) }, { "Towns", IMSDB.Employees.Select(e => e.Town).Distinct().Where(x => x != null).OrderBy(x => x) }, { "AccomodationLocations", IMSDB.Employees.Select(e => e.AccomodationLocation).Distinct().Where(x => x != null).OrderBy(x => x) }, { "BankSWIFTValues", IMSDB.Employees.Select(e => e.BankSWIFT).Distinct().Where(x => x != null).OrderBy(x => x) } }; return(JsonConvert.SerializeObject(dicts)); } }; Dicts[UMDictName] = new DictsDTO() { DictsRetrievalFunction = (MVCControllerDbContexts contexts) => { var dicts = new Dictionary <string, object> { { "Roles", contexts.ERSAI.Roles.Select(x => new DictItemDTO() { ID = x.Id, Name = x.Description ?? x.Name }).OrderBy(x => x.Name) }, { "EmployeeClassSections", Enum.GetValues(typeof(DataModels.Models.IMS.Employee.ComplexInfoSection)) .Cast <DataModels.Models.IMS.Employee.ComplexInfoSection>() .Select(x => new DictItemDTO <DataModels.Models.IMS.Employee.ComplexInfoSection>() { ID = x, Name = x.ToString() }) }, { "BusinessUnits", contexts.IMS.BusinessUnits.Select(bu => new DictItemDTO() { ID = bu.Code, Name = bu.Descr }).OrderBy(x => x.Name) } }; return(JsonConvert.SerializeObject(dicts)); } }; }
public static void Configure(MvcApplication app) { app.SMTPClient = new IntegrationClients.SMTPClient("10.156.21.11", null, "*****@*****.**"); }
public static void Configure(MvcApplication app) { app.SMSClient = new IntegrationClients.InfobipClient(new Infobip.Api.Config.BasicAuthConfiguration("ERSAI", "Admin2017"), "ERSAI"); }