public JsonResult BrokerPerformance(string time) { var intTimePeriod = 0; int.TryParse(time, out intTimePeriod); return(Json(_context.Set <usp_ReturnBrokerPerformance_Result>().FromSql(@"EXEC usp_ReturnBrokerPerformance @user_name={0}, @TimePeriod={1}", User.Identity.Name, intTimePeriod)?.ToList())); }
public JsonResult GetMenu() { //var schema = this.Context.Request.Scheme; var menu = _context.Set <usp_returnTDMSMenu_Result>().FromSql("EXEC usp_returnTDMSMenu @p0", User.Identity.Name); var menuTemp = menu; var menuList = new List <TdmsMenu>(); var menuHome = new TdmsMenu { text = "Home", url = Url.Action("TdmsPortal", "Home") }; menuList.Add(menuHome); foreach (var item in menu.ToList()) { if (item.item_parent != null) { continue; } var menuR = new TdmsMenu { text = item.item_desc }; if (item.item_type_desc.ToLower().Contains("view")) { if (item.item_name != null) { menuR.url = Url.Action(item.item_name, item.item_name); } } if (item.item_bitmap != null) { menuR.ImageUrl = Url.Content("~/Images/" + item.item_bitmap); } menuR.ItemSortCode = item.item_sortcode; menuR.ItemParent = item.item_window; IEnumerable <usp_returnTDMSMenu_Result> uspReturnTdmsMenuResults = menuTemp.ToArray(); var menuListTemp = AddChild(uspReturnTdmsMenuResults.ToList(), item.item_sortcode); if (menuListTemp.ToList().Count > 0) { menuR.items = menuListTemp; } menuList.Add(menuR); } return(Json(menuList.ToList())); }
/// <summary> /// Checks if user with given password exists in the database /// </summary> /// <param name="username">User name</param> /// <param name="password">User password</param> /// <returns>True if user exist and password is correct</returns> public bool IsValid(string username, string password, TdmsDbContext _context) { var userLogin = _context.Set <usp_returnUserbyUserName_Result>().FromSql("EXEC usp_returnUserbyUserName @p0", username).FirstOrDefault(a => a.psw == GetSwcMd5(password) && a.user_status == 0); if (userLogin != null) { LogLoginAttempt(username, true, _context); return(true); } LogLoginAttempt(username, false, _context); return(false); }
public IActionResult Login() { ViewBag.Version = _context.Set <UspReturnVersion>().FromSql(@"EXEC Usp_ReturnVersion")?.FirstOrDefault()?.project_name ?? "No Version!"; return(View()); }