//[HttpPost]
public IActionResult OnPostEMP_Search()
{
var conn = new DapperConnection.ConnectionOptions();
Configuration.GetSection(DapperConnection.ConnectionOptions.Position).Bind(conn);
string sqlStr = " select * from EMP_Profile ";
if (!string.IsNullOrEmpty(EMP_SearchString))
{
sqlStr += string.Format(" where EMP_Account like '%{0}%' ", EMP_SearchString);
}
using (var con = new Microsoft.Data.SqlClient.SqlConnection(conn.EmpServerContext))
{
List_EmpProfile = con.Query <EmpProfile>(sqlStr).ToList();
//List_EmpProfile = con.Query<EmpProfile>(sqlStr, new { OrderDetailID = 1 }).ToList();
}
return(new JsonResult(List_EmpProfile));
}
public async Task <IActionResult> OnPostAsync(string returnUrl = null)
{
ReturnUrl = returnUrl;
await Task.Delay(200);
if (ModelState.IsValid)
{
//var user = AuthenticateUser(Input.ID, Input.Password);
if (!LDAPUtil.Validate(Input.ID, Input.Password)) //驗證失敗
{
ModelState.AddModelError(string.Empty, "Invalid login attempt.");
return(Page());
}
// conn 取的登入者資料
var conn = new DapperConnection.ConnectionOptions();
Configuration.GetSection(DapperConnection.ConnectionOptions.Position).Bind(conn);
string sqlStr = string.Format(@" SELECT TOP 1
'{0}' as ID,
FST_Name + ' ' + LST_Name as FullName ,
case ISNULL(FST_Name, '')
when '' then ISNULL(LST_Name, '')
else FST_Name end FST_Name
from EMP_Profile where EMP_Account like '%{0}%'", Input.ID);
using (var con = new Microsoft.Data.SqlClient.SqlConnection(conn.EmpServerContext))
{
Input_conn = con.Query <InputModel>(sqlStr).ToList();
//List_EmpProfile = con.Query<EmpProfile>(sqlStr, new { OrderDetailID = 1 }).ToList();
}
// 之後建立員工資料表 再加上 EMP info
var claims = new List <Claim>
{
new Claim(ClaimTypes.Name, Input.ID),
new Claim(ClaimTypes.Role, "Administrator"),
new Claim("FstName", Input_conn[0].FST_Name),
new Claim(ClaimTypes.Surname, Input_conn[0].FullName),
};
var claimsIdentity = new ClaimsIdentity(claims, CookieAuthenticationDefaults.AuthenticationScheme);
var authProperties = new AuthenticationProperties
{
};
await HttpContext.SignInAsync(
CookieAuthenticationDefaults.AuthenticationScheme,
new ClaimsPrincipal(claimsIdentity),
authProperties);
_logger.LogInformation("User {Email} logged in at {Time}.",
Input.ID, DateTime.UtcNow);
return(LocalRedirect(Url.GetLocalUrl(returnUrl)));
}
// Something failed. Redisplay the form.
return(Page());
}