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