public bool UpdateUser(tbl_Users row)
{
try
{
using (var db = new SoneriCISEntities())
{
tbl_Users u = new DAL.tbl_Users();
u = db.tbl_Users.Where(a => a.ID == row.ID).FirstOrDefault();
u.IsActive = row.IsActive;
u.RoleTitle = row.RoleTitle;
u.UserLogin = row.UserLogin;
u.UserName = row.UserName;
u.ExpiryDate = row.ExpiryDate;
u.EmpCode = row.EmpCode;
if (row.UserPassword == "")
{
u.UserPassword = u.UserPassword;
}
else
{
u.UserPassword = row.UserPassword;
}
u.IsActive = row.IsActive;
u.AuthorizationStatus = row.AuthorizationStatus;
u.AuthorizationComments = row.AuthorizationComments;
db.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool ChangePassword(int UserID, string UserPassword)
{
try
{
using (var db = new SoneriCISEntities())
{
tbl_Users u = new DAL.tbl_Users();
u = db.tbl_Users.Where(a => a.ID == UserID).FirstOrDefault();
u.IsActive = u.IsActive;
u.RoleTitle = u.RoleTitle;
u.UserLogin = u.UserLogin;
u.UserName = u.UserName;
u.UserPassword = UserPassword;
u.IsActive = u.IsActive;
db.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool CheckPassword(int UserID, string UserPassword)
{
try
{
using (var db = new SoneriCISEntities())
{
tbl_Users u = new DAL.tbl_Users();
u = db.tbl_Users.Where(a => a.ID == UserID && a.UserPassword == UserPassword).FirstOrDefault();
if (u == null)
{
return(false);
}
else
{
return(true);
}
}
}
catch (Exception ex)
{
return(false);
}
}
