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