private async Task Create(LocalSubSubsidiaries coaLocal) { var response = _client.PostAsJsonAsync("api/coa", new CoaControlPostRequestBody { desc = coaLocal.Name, name = coaLocal.Name, parent = coaLocal.SubsidiaryRefNo }).Result; response.EnsureSuccessStatusCode(); var contents = await response.Content.ReadAsAsync <CoaControlPostResponse>(); coaLocal.RefNo = contents._id; using (var context = new TMSEntities()) { var SubSubsidiaries = context.COASubSubsidiaries.FirstOrDefault(w => w.ControlCode == coaLocal.ControlCode && w.SubSubsidiaryCode == coaLocal.SubSubsidiaryCode && w.GeneralCode == coaLocal.GeneralCode && w.SubsidiaryCode == coaLocal.SubsidiaryCode); if (SubSubsidiaries != null) { SubSubsidiaries.RefNo = contents._id; SubSubsidiaries.UpdatedOn = DateTime.Now; } context.SaveChanges(); } }
private static List <LocalGeneral> GetCoaGeneral(TMSEntities context) { return((from control in context.COAControls join coaGeneral in context.COAGenerals on control.ControlCode equals coaGeneral.ControlCode select new LocalGeneral { GeneralCode = coaGeneral.GeneralCode, RefNo = coaGeneral.RefNo, Name = coaGeneral.GeneralDescription, ControlRefNo = control.RefNo, ControlCode = control.ControlCode } ).ToList()); }
static void Main(string[] args) { entities = new TMSEntities(); //var menus = (from m in entities.Menus // join r in entities.RoleMenus on m.MenuId equals r.MenuId // where r.RoleId == 1 && r.Enabled == true && m.ParentMenuId == null // select m).Include(i => i.Children).ToList(); entities.Database.Log = s => System.Diagnostics.Debug.WriteLine(s); var result = entities.Menus.Join(entities.RoleMenus, m => m.MenuId, r => r.MenuId, (menu, role) => new { menuList = menu }).SelectMany(i => i.menuList.MenuItems).Where(i => i.ParentMenuId == null).Include(j => j.Children).ToList(); var pagedResult = GetMany(1, 10); pagedResult = GetMany(2, 10); pagedResult = GetMany(3, 10); pagedResult = GetMany(m => m.MenuItemId > 20,1, 10); pagedResult = GetMany(m => m.MenuItemId > 30, 1, 10); pagedResult = GetMany(m => m.MenuItemId > 10, 1, 10); System.Console.ReadLine(); }
private static List <LocalSubsidiaries> GetCoaSubsidiaries(TMSEntities context) { return((from coaGeneral in context.COAGenerals join coaSubsidiaries in context.COASubsidiaries on new { coaGeneral.ControlCode, coaGeneral.GeneralCode } equals new { coaSubsidiaries.ControlCode, coaSubsidiaries.GeneralCode } select new LocalSubsidiaries { SubsidiaryCode = coaSubsidiaries.SubsidiaryCode, RefNo = coaSubsidiaries.RefNo, GeneralCode = coaSubsidiaries.GeneralCode, Name = coaSubsidiaries.SubsidiaryDescription, GeneralRefNo = coaGeneral.RefNo, ControlCode = coaGeneral.ControlCode } ).ToList()); }
static void Main(string[] args) { entities = new TMSEntities(); //var menus = (from m in entities.Menus // join r in entities.RoleMenus on m.MenuId equals r.MenuId // where r.RoleId == 1 && r.Enabled == true && m.ParentMenuId == null // select m).Include(i => i.Children).ToList(); entities.Database.Log = s => System.Diagnostics.Debug.WriteLine(s); var result = entities.Menus.Join(entities.RoleMenus, m => m.MenuId, r => r.MenuId, (menu, role) => new { menuList = menu }).SelectMany(i => i.menuList.MenuItems).Where(i => i.ParentMenuId == null).Include(j => j.Children).ToList(); var pagedResult = GetMany(1, 10); pagedResult = GetMany(2, 10); pagedResult = GetMany(3, 10); pagedResult = GetMany(m => m.MenuItemId > 20, 1, 10); pagedResult = GetMany(m => m.MenuItemId > 30, 1, 10); pagedResult = GetMany(m => m.MenuItemId > 10, 1, 10); System.Console.ReadLine(); }
public TMSEntities Init() { return dbContext ?? (dbContext = new TMSEntities()); }
public ActionResult Login(LoginViewModel model, string returnUrl) { if (ModelState.IsValid) { try { User user = _userService.ValidateUser(model.Username, model.Password); if (user == null) { ModelState.AddModelError("", "Username is not available"); return View(model); } int userRoleId = 1; string redirectToController = "Home"; if (user is Admin) { userRoleId = 1; redirectToController = "Admin"; } else if (user is Distributor) { userRoleId = 2; redirectToController = "Distributor"; } else if (user is Dealer) { userRoleId = 3; redirectToController = "Dealer"; } else if (user is Customer) { userRoleId = 4; redirectToController = "Customer"; } CustomPrincipalSerializeModel serializeModel = new CustomPrincipalSerializeModel() { UserId = user.UserId, Username = user.Username, FirstName = user.FirstName, LastName = user.LastName, Role = user.GetType().Name, UserType = user.GetType() }; string userData = JsonConvert.SerializeObject(serializeModel); FormsAuthenticationTicket authTicket = new FormsAuthenticationTicket(1, user.Username, DateTime.Now, DateTime.Now.AddMinutes(30), false, userData); string encTicket = FormsAuthentication.Encrypt(authTicket); HttpCookie faCookie = new HttpCookie(FormsAuthentication.FormsCookieName, encTicket) { Expires = authTicket.Expiration, Path = FormsAuthentication.FormsCookiePath }; Response.Cookies.Add(faCookie); TMSEntities entities = new TMSEntities(); var menusList = entities.Menus.Join(entities.RoleMenus.Where(rm => rm.RoleId == userRoleId), m => m.MenuId, r => r.MenuId, (menu, role) => new { menuList = menu }) .SelectMany(i => i.menuList.MenuItems) .Where(i => i.ParentMenuId == null) .Include(j => j.Children) .ToList(); Session["Menus"] = menusList; Session["UserData"] = user; if (!string.IsNullOrWhiteSpace(returnUrl)) { return Redirect(returnUrl); } return RedirectToAction("Index", redirectToController); } catch (Exception ex) { Logger.ErrorFormat("Controller : {0} - Action : {1}, Message : {2}", this.ControllerContext.RouteData.Values["controller"].ToString(), this.ControllerContext.RouteData.Values["action"].ToString(), ex.Message); } } return View(model); }
public ActionResult Login(LoginViewModel model, string returnUrl) { if (ModelState.IsValid) { try { User user = _userService.ValidateUser(model.Username, model.Password); if (user == null) { ModelState.AddModelError("", "Username is not available"); return(View(model)); } int userRoleId = 1; string redirectToController = "Home"; if (user is Admin) { userRoleId = 1; redirectToController = "Admin"; } else if (user is Distributor) { userRoleId = 2; redirectToController = "Distributor"; } else if (user is Dealer) { userRoleId = 3; redirectToController = "Dealer"; } else if (user is Customer) { userRoleId = 4; redirectToController = "Customer"; } CustomPrincipalSerializeModel serializeModel = new CustomPrincipalSerializeModel() { UserId = user.UserId, Username = user.Username, FirstName = user.FirstName, LastName = user.LastName, Role = user.GetType().Name, UserType = user.GetType() }; string userData = JsonConvert.SerializeObject(serializeModel); FormsAuthenticationTicket authTicket = new FormsAuthenticationTicket(1, user.Username, DateTime.Now, DateTime.Now.AddMinutes(30), false, userData); string encTicket = FormsAuthentication.Encrypt(authTicket); HttpCookie faCookie = new HttpCookie(FormsAuthentication.FormsCookieName, encTicket) { Expires = authTicket.Expiration, Path = FormsAuthentication.FormsCookiePath }; Response.Cookies.Add(faCookie); TMSEntities entities = new TMSEntities(); var menusList = entities.Menus.Join(entities.RoleMenus.Where(rm => rm.RoleId == userRoleId), m => m.MenuId, r => r.MenuId, (menu, role) => new { menuList = menu }) .SelectMany(i => i.menuList.MenuItems) .Where(i => i.ParentMenuId == null) .Include(j => j.Children) .ToList(); Session["Menus"] = menusList; Session["UserData"] = user; if (!string.IsNullOrWhiteSpace(returnUrl)) { return(Redirect(returnUrl)); } return(RedirectToAction("Index", redirectToController)); } catch (Exception ex) { Logger.ErrorFormat("Controller : {0} - Action : {1}, Message : {2}", this.ControllerContext.RouteData.Values["controller"].ToString(), this.ControllerContext.RouteData.Values["action"].ToString(), ex.Message); } } return(View(model)); }
public TMSEntities Init() { return(dbContext ?? (dbContext = new TMSEntities())); }