public NiemYetGiaInNhanhBDO DocTheoId(int iD) { NiemYetGiaInNhanhBDO output = null; using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GlobalConfig.CnnString(tenDB))) { var p = new DynamicParameters(); p.Add("@id", iD); output = connection.QueryFirstOrDefault <NiemYetGiaInNhanhBDO>("dbo.spNiemYetGiaInNhanh_DocTheoId", p, commandType: CommandType.StoredProcedure);//Thử return(output); } }
public async Task <IActionResult> Login(LoginModel loginModel) { if (loginModel != null) { if (ModelState.IsValid) { var appSettingsJson = AppSettingJSON.GetAppSettings(); var connectionString = appSettingsJson["DefaultConnection"]; try{ using (System.Data.SqlClient.SqlConnection _conn = new System.Data.SqlClient.SqlConnection(connectionString)) { if (_conn.State == System.Data.ConnectionState.Open) { _conn.Close(); } string q = "SELECT * FROM Users WHERE username=@usr_name and userpassword=@usr_pwd"; var param = new { usr_name = loginModel.username, usr_pwd = loginModel.userpassword }; //_conn.Open(); var user = _conn.QueryFirstOrDefault <User>(q, param); if (user != null) { await Authenticate(loginModel.username).ConfigureAwait(false); return(RedirectToAction("Index", "Home")); } else { ModelState.AddModelError("", "Некорректные логин или пароль"); } } } catch (Exception e) { ViewBag.ErrorMessage = e.Message; } } } ViewBag.Page = "Home"; return(View(loginModel)); }