public List <TblUser> Login(TblLogin objLogin)
{
try
{
db.AddParameter("@EmailId", SqlDbType.Text, objLogin.EmailId);
db.AddParameter("@Password", SqlDbType.Text, objLogin.Password);
DataSet ds = db.FillData("sp_Login");
List <TblUser> loginDetails = ds.Tables[0].AsEnumerable().Select(dr => new TblUser
{
UserId = Convert.ToInt32(dr["userId"]),
FirstName = Convert.ToString(dr["firstName"]),
LastName = Convert.ToString(dr["lastName"]),
EmailId = Convert.ToString(dr["emailId"]),
Password = Convert.ToString(dr["password"]),
DOB = Convert.ToDateTime(dr["DOB"]),
ContactNo = Convert.ToString(dr["contactNo"]),
TenantId = Convert.ToInt32(dr["tenantId"]),
TenantName = Convert.ToString(dr["tenantName"]),
RoleId = Convert.ToInt32(dr["roleId"]),
RoleName = Convert.ToString(dr["roleName"]),
IsActive = Convert.ToBoolean(dr["isActive"]),
CreatedBy = Convert.ToInt32(dr["createdBy"]),
CreatedOn = Convert.ToDateTime(dr["createdOn"]),
}).ToList();
return(loginDetails);
}
catch (Exception)
{
throw;
}
}
public object PostTblLogin([FromBody] TblLogin tblLogin)
{
if (!ModelState.IsValid)
{
return(new { Status = 300, msg = "Error in db" });
}
tblLogin.FldPassword = Encryption(tblLogin.FldPassword, 4);
foreach (var login in _context.TblLogin)
{
if (login.FldUsername == tblLogin.FldUsername)
{
if (login.FldPassword == tblLogin.FldPassword)
{
return(new { Status = 100, Rank = login.FldRank });
}
else
{
return(new { Status = 200, msg = "Password incorrect" });
}
}
}
return(new { Status = 200, msg = "User doesn't exist" });
}
public async Task <IActionResult> PostTblLogin([FromBody] TblLogin tblLogin)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
tblLogin.FldPassword = Encryption(tblLogin.FldPassword, 4);
Console.WriteLine(tblLogin.FldPassword);
_context.TblLogin.Add(tblLogin);
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateException)
{
if (TblLoginExists(tblLogin.FldUsername))
{
return(new StatusCodeResult(StatusCodes.Status409Conflict));
}
else
{
throw;
}
}
return(CreatedAtAction("GetTblLogin", new { id = tblLogin.FldUsername }, tblLogin));
}
public async Task <IActionResult> PutTblLogin([FromRoute] string id, [FromBody] TblLogin tblLogin)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != tblLogin.FldUsername)
{
return(BadRequest());
}
_context.Entry(tblLogin).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TblLoginExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public IActionResult LoginUser([FromBody] TblLogin userLogin)
{
var userLogged = entity.TblLogin.Where(ad => ad.Name == userLogin.Name && ad.Passcode == userLogin.Passcode).FirstOrDefault();
if (userLogged != null)
{
return(Ok(new { Message = "Logged In Successfully", User = userLogged }));
}
else
{
return(Ok(new
{
Message = "Invalid Credentials"
}));
}
}
public IActionResult Post([FromBody] TblLogin tblLogin)
{
var result = _iLogin.Authenticate(tblLogin.UserName, tblLogin.Password);
if (result != null)
{
string token = GenerateToken(tblLogin.EmployeeId.ToString(), result.Role.RoleName);
JsonObject obj = new JsonObject();
obj.Add("token", token);
obj.Add("userid", result.EmployeeId);
obj.Add("role", result.Role.RoleName);
obj.Add("username", result.EmployeeName);
return(Ok(obj));
}
return(Ok(false));
}
