internal static UserModel Mapping(USR_TMMA_USER o)
{
try
{
if (o != null)
{
return(new UserModel()
{
UserID = o.UserID,
RoleID = o.RoleID,
Username = o.Username,
PasswordHash = o.PasswordHash,
Salt = o.Salt,
IsActive = o.IsActive == 1,
CreatedBy = o.CreatedBy,
CreatedDate = o.CreatedDate,
UpdatedBy = o.UpdatedBy,
UpdatedDate = o.UpdatedDate,
Role = MasterRoleDAL.GetMasterRole(o.RoleID)
});
}
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
public static UserModel GetUserByUsername(string username)
{
ACTION = "GetUserByUsername(username)";
try
{
using (UTMMABCDBEntities context = new UTMMABCDBEntities())
{
USR_TMMA_USER obj = context.USR_TMMA_USER.Where(x => string.Compare(x.Username, username, true) == 0).FirstOrDefault();
UserModel m = Mapping(obj);
return(m);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static UserModel GetUserByUsernamePassword(string username, string password)
{
ACTION = "GetUserByUsernamePassword(username, password)";
try
{
using (UTMMABCDBEntities context = new UTMMABCDBEntities())
{
USR_TMMA_USER obj = context.USR_TMMA_USER.Where(o => o.Username == username && o.PasswordHash == password).FirstOrDefault();
UserModel m = Mapping(obj);
return(m);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static UserModel GetUser(int userID)
{
ACTION = "GetUser(userID)";
try
{
using (UTMMABCDBEntities context = new UTMMABCDBEntities())
{
USR_TMMA_USER obj = context.USR_TMMA_USER.Where(o => o.UserID == userID).FirstOrDefault();
UserModel m = Mapping(obj);
return(m);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static ResponseModel AddUser(UserModel user)
{
string action = "AddUser(UserModel)";
try
{
if (user != null)
{
using (UTMMABCDBEntities context = new UTMMABCDBEntities())
{
USR_TMMA_USER _obj = Mapping(user);
context.USR_TMMA_USER.Add(_obj);
if (context.SaveChanges() > 0)
{
return(new ResponseModel()
{
Source = SOURCE,
Action = action,
Status = true,
Message = "Success"
});
}
return(new ResponseModel()
{
Source = SOURCE,
Action = action,
Status = false,
Message = "Fail"
});
}
}
return(new ResponseModel()
{
Source = SOURCE,
Action = action,
Status = false,
Message = "Null"
});
}
catch (DbEntityValidationException ex)
{
return(new ResponseModel()
{
Source = SOURCE,
Action = action,
Status = false,
Message = ex.Message,
StackTrace = ex.StackTrace
});
}
catch (Exception ex)
{
return(new ResponseModel()
{
Source = SOURCE,
Action = action,
Status = false,
Message = ex.Message,
StackTrace = ex.StackTrace
});
}
}