protected override void Initialize(RequestContext requestContext) { if (db == null) { db = new ESKAPEDEContext(); } if (WebSecurityService == null) { WebSecurityService = new WebSecurityService(); } if (MessengerService == null) { MessengerService = new MessengerService(); } base.Initialize(requestContext); }
public JsonResult ListCabang() { using (var db = Database.Open("DBNASContext")) { IEnumerable<dynamic> ListKC = null; string kdkc = string.Empty; using (ESKAPEDEContext db2 = new ESKAPEDEContext()) { var UserBranch = db2.vwUserProfiles.Where(a => a.Username == User.Identity.Name).Select(a => a.CountryID).SingleOrDefault(); switch (UserBranch) { case 1: kdkc = "x"; break; case 2: kdkc = "0201"; break; case 3: kdkc = "0401"; break; case 4: kdkc = "0601"; break; case 5: kdkc = "0901"; break; case 6: kdkc = "0902"; break; case 7: kdkc = "1001"; break; case 8: kdkc = "1101"; break; case 9: kdkc = "1301"; break; case 10: kdkc = "1602"; break; case 11: kdkc = "1801"; break; case 12: kdkc = "2101"; break; case 13: kdkc = "2201"; break; } } if (kdkc != "x") { ListKC = db.Query(string.Format("SELECT KDKC,NMKC FROM REFKC WHERE KDKC={0}",kdkc)); } else { ListKC = db.Query("SELECT KDKC,NMKC FROM REFKC"); } var ListCabang = (from xcabang in ListKC select new { KDKC = xcabang.KDKC, NMKC = xcabang.NMKC }); return Json(ListCabang, JsonRequestBehavior.AllowGet); } }