public dynamic GetLogin(MvLogin login)
{
using (var con = _da.GetConnection())
{
var cmd = con.CreateCommand();
//cmd.CommandType = CommandType.StoredProcedure;
// cmd.CommandText = "SpUserSel";
//cmd.Parameters.Add("@Json", SqlDbType.NChar).Value = login;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT (SELECT u.userName,u.password FROM dbo.[User] AS u WHERE u.UserName = '******' AND u.Password='******' FOR JSON PATH, WITHOUT_ARRAY_WRAPPER ) AS Json";
cmd.CommandTimeout = _commandTimeout;
using (SqlDataReader rdr = cmd.ExecuteReader())
{
try
{
if (rdr.HasRows)
{
return _da.GetJson(rdr);
}
else
{
return null;
}
}
catch (Exception ex)
{
throw ex;
}
}
}
}
public dynamic GetLogin(MvLogin login)
{
using (var connection = _dataAccess.GetConnection())
{
var command = connection.CreateCommand();
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "SpUserSel";
command.Parameters.AddWithValue("@Email", login.Email);
command.Parameters.AddWithValue("@Password", login.Password);
command.CommandTimeout = _commandTimeout;
using (SqlDataReader reader = command.ExecuteReader())
{
try
{
if (reader.HasRows)
{
return(_dataAccess.GetJson(reader));
}
else
{
return(null);
}
}
catch (Exception e)
{
throw e;
}
}
}
}
public dynamic GetLogin(MvLogin login)
{
using (var conn = _da.GetConnection())
{
using (var cmd = new SqlCommand("SpUserSel", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@Username", login.UserName));
cmd.Parameters.Add(new SqlParameter("@Password", login.Password));
using (var reader = cmd.ExecuteReader())
{
try
{
if (reader.HasRows)
{
return(_da.GetJson(reader));
}
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
}
}
}
public dynamic GetLogin(MvLogin login)
{
using (var dbConnection = dah.GetConnection())
{
var dbCommand = dbConnection.CreateCommand();
dbCommand.CommandType = CommandType.StoredProcedure;
dbCommand.CommandText = "SpCustomerAuth";
dbCommand.Parameters.Add("@Json", SqlDbType.NVarChar);
dbCommand.Parameters["@Json"].Value = "{\"username\":\"" + login.Username + "\", \"password\":\"" + login.Password + "\"}";
using SqlDataReader reader = dbCommand.ExecuteReader();
try
{
if (reader.HasRows)
{
return(dah.GetJson(reader));
}
else
{
return(null);
}
}
catch (Exception e)
{
throw e;
}
}
}
public async Task <object> Login(MvLogin login)
{
var user = await personService.GetPerson(login.Username, login.Password);
var jwt = await jwtFactory.GenerateJwt(user);
return(jwt);
}
public IActionResult Login([FromBody] MvLogin login)
{
try
{
var jsonString = _accountService.GetLogin(login);
return(Ok(jsonString));
}
catch (Exception)
{
throw;
}
}
public IActionResult EditUser([FromBody] MvLogin login)
{
try
{
dynamic jsonString = accountService.EditUser(login);
return(Ok(jsonString));
}
catch (Exception e)
{
throw e;
}
}
public IActionResult UserLogin([FromBody] MvLogin login)
{
//if (!ModelState.IsValid)
//{
// return BadRequest();
//}
try
{
var dataLogin = _loginService.GetLogin(login);
return(Ok(dataLogin));
}
catch (Exception)
{
throw;
}
}
public dynamic GetLogin(MvLogin login)
{
using (var con = _dah.GetConnection())
{
var cmd = con.CreateCommand();
// cmd.CommandType = CommandType.Text;
// cmd.CommandText = "SELECT (SELECT u.UserName,u.LoginPassword " +
// "FROM [dbo].[Login] AS u WHERE u.UserName = '******' AND u.LoginPassword='******' FOR JSON PATH, WITHOUT_ARRAY_WRAPPER ) AS Json";
// cmd.CommandTimeout = _commandTimeout;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT (SELECT u.UserName,u.LoginPassword FROM [dbo].[Login] AS u WHERE u.UserName = '******' AND u.LoginPassword='******' FOR JSON PATH, WITHOUT_ARRAY_WRAPPER ) AS Json";
cmd.CommandTimeout = _comdTimeout;
using (SqlDataReader rdr = cmd.ExecuteReader())
{
try
{
if (rdr.HasRows)
{
return(_dah.GetJson(rdr));
}
else
{
return(null);
}
}
catch (Exception e)
{
throw e;
}
}
}
}
public async Task <IActionResult> Login([FromBody] MvLogin login)
{
try
{
if (!ModelState.IsValid)
{
return(BadRequest(new MvError("Login Error", "Invalid username or password")));
}
var jwt = await accountService.Login(login);
if (jwt == null)
{
return(BadRequest(new MvError("Login error", "Invalid username or password")));
//return BadRequest(Errors.AddErrorToModelState("login_failure", "Invalid username or password.", ModelState));
}
return(new OkObjectResult(jwt));
}
catch (Exception ex)
{
return(BadRequest(new MvError("Login Error", ex.Message)));
}
}
public async Task <IActionResult> Login([FromBody] MvLogin login)
{
try
{
var res = await _webService.Post <MvPersonResult>($"{ _configuration["ApiUrl"]}account/login", login);
// success cas
if (String.IsNullOrEmpty(res.error))
{
HttpContext.Session.SetString("personResult", JsonConvert.SerializeObject(res));
return(Ok(res));
}
else
{
return(Redirect("~/notfound")); // error
}
}
catch (Exception ex)
{
return(Redirect("~/notfound"));
}
}
public dynamic EditUser(MvLogin login)
{
using (var dbConnection = dah.GetConnection())
{
var dbCommand = dbConnection.CreateCommand();
dbCommand.CommandType = CommandType.StoredProcedure;
dbCommand.CommandText = "SpCustomerUpd";
dbCommand.Parameters.Add("@Json", SqlDbType.NVarChar);
dbCommand.Parameters["@Json"].Value = "{\"firstName\":\"" + login.FirstName + "\"," +
"\"customerId\":" + login.CustomerId + "," +
"\"middleName\":\"" + login.MiddleName + "\"," +
"\"lastName\":\"" + login.LastName + "\"," +
"\"username\":\"" + login.Username + "\"," +
"\"password\":\"" + login.Password + "\"," +
"\"email\":\"" + login.Email + "\"," +
"\"mobile\":\"" + login.Mobile + "\"," +
"\"insertPersonId\": 1337}";
using (SqlDataReader reader = dbCommand.ExecuteReader())
{
try
{
if (reader.HasRows)
{
return(dah.GetJson(reader));
}
else
{
return(null);
}
}
catch (Exception e)
{
throw e;
}
}
}
}
public dynamic GetLogin(MvLogin login)
{
using (var sql = _dah.GetConnection())
{
using (SqlCommand command = new SqlCommand("SpUserLoginCheck", sql))
{
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@UserName", login.Username));
command.Parameters.Add(new SqlParameter("@Password", login.Password));
using (var reader = command.ExecuteReader())
{
if (reader.HasRows)
{
Console.WriteLine("user Exist");
return(_dah.GetJson(reader));
}
return(null);
}
}
}
}
dynamic IAccountService.GetLogin(MvLogin login)
{
throw new NotImplementedException();
}
