public SPRW_USER GetUser(string userEmail)
{
var user = new SPRW_USER();
try
{
using (var context = new sparrow_dbEntities())
{
var selectedUser = context.SPRW_USER.FirstOrDefault(i => i.EMAIL.ToLower().Equals(userEmail.ToLower()));
if (selectedUser != null)
{
user.ACT_IND = selectedUser.ACT_IND;
user.CC = selectedUser.CC;
user.EMAIL = selectedUser.EMAIL;
user.FIRST_NAME = selectedUser.FIRST_NAME;
user.LAST_MAINT_TIME = selectedUser.LAST_MAINT_TIME;
user.LAST_MAINT_USER_ID = selectedUser.LAST_MAINT_USER_ID;
user.LAST_NAME = selectedUser.LAST_NAME;
user.PASSWORD = selectedUser.PASSWORD;
user.SALT = selectedUser.SALT;
}
}
}
catch (Exception e)
{
throw e;
}
return(user);
}
public int CreateUser(CreateUserModel model, int salt)
{
try
{
int id = -1;
using (var context = new sparrow_dbEntities())
{
var user = new SPRW_USER
{
FIRST_NAME = model.FirstName,
LAST_NAME = model.LastName,
EMAIL = model.Email,
SALT = salt,
CC = "",
PASSWORD = model.Password,
LAST_MAINT_TIME = DateTime.Now,
LAST_MAINT_USER_ID = model.Email
};
context.SPRW_USER.Add(user);
context.SaveChanges();
id = user.USER_ID;
}
return(id);
}
catch (Exception e)
{
throw e;
}
}
