public async Task <IActionResult> Login(LoginModel loginModel) { if (loginModel != null) { if (ModelState.IsValid) { var appSettingsJson = AppSettingJSON.GetAppSettings(); var connectionString = appSettingsJson["DefaultConnection"]; using (SqlConnection _conn = new SqlConnection(connectionString)) { string q = "SELECT * FROM Users WHERE username=@usr_name and userpassword=@usr_pwd"; var param = new { usr_name = loginModel.username, usr_pwd = loginModel.userpassword }; var user = _conn.QueryFirstOrDefault <User>(q, param); if (user != null) { await Authenticate(loginModel.username).ConfigureAwait(false); return(RedirectToAction("Index", "Home")); } else { ModelState.AddModelError("", "Некорректные логин или пароль"); } } } } ViewBag.Page = "Home"; return(View(loginModel)); }
public IActionResult Edit([Bind] User objUsr) { if (objUsr == null) { return(NotFound()); } if (ModelState.IsValid) { //if(BioPrepDAL.IsUniqueRecord(objBioPrep)) //BioPrepDAL.Update_BioPrep(objBioPrep); var appSettingsJson = AppSettingJSON.GetAppSettings(); var connectionString = appSettingsJson["DefaultConnection"]; using (var _conn = new SqlConnection(connectionString)) { _conn.Execute("UPDATE Users SET UnitsId=@_UnitsId," + "username=@_username, UserFullname=@_UserFullname," + "userpassword=@_userpassword, Role=@_Role " + "WHERE Id=@_Id", new { _Id = objUsr.Id, _UnitsId = objUsr.UnitsId, _username = objUsr.username, _UserFullname = objUsr.UserFullname, _userpassword = objUsr.userpassword, _Role = objUsr.Role }); return(RedirectToAction("UsersEdit")); } } ViewBag.Page = "Home"; return(View(objUsr)); }
public IActionResult DeleteUser(int Id) { //BioPrepDAL.Delete_BioPrep(id); var appSettingsJson = AppSettingJSON.GetAppSettings(); var connectionString = appSettingsJson["DefaultConnection"]; using (SqlConnection _conn = new SqlConnection(connectionString)) _conn.Execute("DELETE FROM Users WHERE Id=@idd", new { idd = Id }); ViewBag.Page = "Home"; return(RedirectToAction("UsersEdit")); }
public IActionResult UsersEdit() { var appSettingsJson = AppSettingJSON.GetAppSettings(); var connectionString = appSettingsJson["DefaultConnection"]; using (SqlConnection _conn = new SqlConnection(connectionString)) { var tmpList = _conn.Query <User>("SELECT * FROM Users"); _conn.Close(); ViewBag.Page = "Home"; //ViewBag.DtList = spDAL.ReportToToday(); return(View(tmpList)); }; }
public IActionResult Delete(int Id) { var appSettingsJson = AppSettingJSON.GetAppSettings(); var connectionString = appSettingsJson["DefaultConnection"]; using (SqlConnection _conn = new SqlConnection(connectionString)) { var usr = _conn.QueryFirst <User>("SELECT * FROM Users WHERE Id=@idd", new { idd = Id }); if (usr == null) { return(NotFound()); } ViewBag.Page = "Home"; return(View(usr)); } }
public IActionResult ReportDtToAllUsers(DateTime dt) { var appSettingsJson = AppSettingJSON.GetAppSettings(); var connectionString = appSettingsJson["DefaultConnection"]; using (SqlConnection _conn = new SqlConnection(connectionString)) { string q = "UPDATE Users SET ReportDt=@dd WHERE [Role]='Client'"; var param = new { dd = dt }; _conn.Execute(q, param); _conn.Close(); } //ViewBag.Page = "Home"; //ViewBag.DtList = spDAL.ReportToToday(); return(RedirectToAction("UsersEdit")); }
public async Task <IActionResult> Register(RegisterModel registerModel) { if (registerModel != null) { if (ModelState.IsValid) { var appSettingsJson = AppSettingJSON.GetAppSettings(); var connectionString = appSettingsJson["DefaultConnection"]; SqlConnection _conn = new SqlConnection(connectionString); int usr_count = await _conn.QueryFirstOrDefaultAsync <int>("SELECT COUNT(*) FROM Users WHERE username=@usr_name", new{ usr_name = registerModel.username }).ConfigureAwait(false); if (usr_count == 0) { var param = new { UsrFN = registerModel.UserFullname, usrname = registerModel.username, usrpwd = registerModel.userpassword, UnitsId = registerModel.UnitsId, rr = registerModel.Role //@rDt = registerModel.reportDt }; _conn.Execute("INSERT INTO Users (UserFullname,username,userpassword,UnitsId,Role) " + "VALUES (@UsrFN,@usrname,@usrpwd,@UnitsId,@rr)", param); _conn.Close(); return(RedirectToAction("Index", "Home")); } else { ModelState.AddModelError("", "Некорректные логин или пароль"); } _conn.Close(); } } ViewBag.Page = "Home"; return(View(registerModel)); }
static spDAL() { var appSettingsJson = AppSettingJSON.GetAppSettings(); connStr = appSettingsJson["DefaultConnection"]; }
private async Task Authenticate(string username) { var appSettingsJson = AppSettingJSON.GetAppSettings(); var connectionString = appSettingsJson["DefaultConnection"]; using (SqlConnection _conn = new SqlConnection(connectionString)) { User usr = _conn.QueryFirstOrDefault <User>("SELECT * FROM Users WHERE username=@usr_name", new{ usr_name = username }); string usrFullName; string roleP; string UnitsId; int UserId; //DateTime rDt; if (usr.Role != null) { roleP = usr.Role; } else { roleP = "Client"; } if (usr.UnitsId != null) { UnitsId = usr.UnitsId; } else { UnitsId = ""; } //usr.UserId //if(usr.reportDt!=null) rDt = usr.reportDt; //else rDt = new DateTime(DateTime.Today.Year,DateTime.Today.Month-1,1); if (usr.UserFullname != null) { usrFullName = usr.UserFullname; } else { usrFullName = ""; } UserId = usr.Id; //int Y = rDt.Year; //int M = rDt.Month; var claims = new List <Claim> { new Claim(ClaimsIdentity.DefaultNameClaimType, username), new Claim(ClaimsIdentity.DefaultRoleClaimType, roleP), new Claim("UnitsId", UnitsId), new Claim("UserId", UserId.ToString()), new Claim("Role", roleP), //new Claim("reportDtYear", Y.ToString()), //new Claim("reportDtMonth", M.ToString()), new Claim("UserFullName", usrFullName) }; //CultureInfo.CurrentCulture = new CultureInfo("ky-KG"); //CultureInfo.CurrentUICulture = new CultureInfo("ky"); //Response.Cookies.Append( //CookieRequestCultureProvider.DefaultCookieName, //CookieRequestCultureProvider.MakeCookieValue(new RequestCulture("ky")), //new Microsoft.AspNetCore.Http.CookieOptions { Expires = DateTimeOffset.UtcNow.AddYears(1) } //); var id = new ClaimsIdentity(claims, "ApplicationCookie", ClaimsIdentity.DefaultNameClaimType, ClaimsIdentity.DefaultRoleClaimType); await HttpContext.SignInAsync(CookieAuthenticationDefaults.AuthenticationScheme, new ClaimsPrincipal(id)).ConfigureAwait(false); } }
private async Task Authenticate(string username) { var appSettingsJson = AppSettingJSON.GetAppSettings(); var connectionString = appSettingsJson["DefaultConnection"]; using (SqlConnection _conn = new SqlConnection(connectionString)) { User usr = _conn.QueryFirstOrDefault <User>("SELECT * FROM Users WHERE username=@usr_name", new{ usr_name = username }); string usrFullName; string roleP; string KIDro; DateTime rDt; if (usr.Role != null) { roleP = usr.Role; } else { roleP = ""; } if (usr.KIDro != null) { KIDro = usr.KIDro; } else { KIDro = ""; } if (usr.reportDt != null) { rDt = usr.reportDt; } else { rDt = new DateTime(DateTime.Today.Year, DateTime.Today.Month - 1, 1); } if (usr.UserFullname != null) { usrFullName = usr.UserFullname; } else { usrFullName = ""; } int Y = rDt.Year; int M = rDt.Month; string v; if (usr.VetPlan) { v = "true"; } else { v = "false"; } //if(vetPlan is BOOL){vetPlan = false}; var claims = new List <Claim> { new Claim(ClaimsIdentity.DefaultNameClaimType, username), new Claim(ClaimsIdentity.DefaultRoleClaimType, roleP), new Claim("KIDro", KIDro), new Claim("Role", roleP), new Claim("reportDtYear", Y.ToString()), new Claim("reportDtMonth", M.ToString()), new Claim("UserFullName", usrFullName), new Claim("VetPlan", v) }; CultureInfo.CurrentCulture = new CultureInfo("ru-RU"); CultureInfo.CurrentUICulture = new CultureInfo("ru"); Response.Cookies.Append( CookieRequestCultureProvider.DefaultCookieName, CookieRequestCultureProvider.MakeCookieValue(new RequestCulture("ru")), new Microsoft.AspNetCore.Http.CookieOptions { Expires = DateTimeOffset.UtcNow.AddYears(1) } ); var id = new ClaimsIdentity(claims, "ApplicationCookie", ClaimsIdentity.DefaultNameClaimType, ClaimsIdentity.DefaultRoleClaimType); await HttpContext.SignInAsync(CookieAuthenticationDefaults.AuthenticationScheme, new ClaimsPrincipal(id)).ConfigureAwait(false); } }