public static bool Update(Domain.TBL_USER user)
{
try
{
var db = new Data.Access.Context();
var value = db.TBL_USER.SingleOrDefault(a => a.CDG_ID == user.CDG_ID);
if (value == null)
{
return(false);
}
value.CAR_EMAIL = user.CAR_EMAIL;
value.CAR_NAME = user.CAR_NAME;
value.COD_PROFILE = user.COD_PROFILE;
db.SaveChanges();
return(true);
}
catch (Exception ex)
{
TBL_ERROR.Create(ex, Utilities.Basic.GetCurrentMethod(), "Inventory.Data.Management.TBL_USER");
return(false);
}
}
public static bool User_Update(int userId, string name, string email, byte profileId)
{
var user = new Domain.TBL_USER();
user.CAR_NAME = name;
user.CAR_EMAIL = email;
user.COD_PROFILE = profileId;
user.CDG_ID = userId;
var success = Data.Management.TBL_USER.Update(user);
return(success);
}
//crear usuario
//listar usuarios
//retornar usuario
public static bool User_Create(string userName, string password, string name, string email, byte profileId)
{
var user = new Domain.TBL_USER();
user.CAR_NAME = name;
user.CAR_PASSWORD = Utilities.Encryption.StringToMD5Hash(password);
user.CAR_USER_NAME = userName;
user.CAR_EMAIL = email;
user.COD_PROFILE = profileId;
var id = Data.Management.TBL_USER.Save(user);
return(id != 0 ? true : false);
}
public static int Save(Domain.TBL_USER user)
{
try
{
var db = new Data.Access.Context();
user.DAT_TIMESTAMP = DateTime.Now;
//este estado variar en un futuro si varia la forma de activacion
user.COD_STATUS = (byte)Domain.Status.TBL_USER.ENABLED;
db.TBL_USER.Add(user);
db.SaveChanges();
var id = db.TBL_USER.OrderByDescending(d => d.CDG_ID).First().CDG_ID;
return(id);
}
catch (Exception ex)
{
TBL_ERROR.Create(ex, Utilities.Basic.GetCurrentMethod(), "Inventory.Data.Management.TBL_USER");
return(0);
}
}