/// <summary>
///
/// </summary>
/// <param name="dbModel"></param>
/// <returns></returns>
public int RecordRemove(UserDbModel dbModel)
{
using (DesarrolloDocenteBDEntities db = new DesarrolloDocenteBDEntities())
{
try
{
var record = db.SEC_USER.Where(x => x.ID == dbModel.Id).FirstOrDefault();
if (record == null)
{
return(3);
}
//db.SEC_ROLE.Remove(record);
record.REMOVED = true;
record.REMOVE_DATE = dbModel.CurrentDate;
record.REMOVE_USER_ID = dbModel.UserInSessionId;
db.SaveChanges();
return(1);
}
catch
{
return(2);
}
};
}
public UserDbModel Login(UserDbModel dbModel)
{
using (DesarrolloDocenteBDEntities db = new DesarrolloDocenteBDEntities())
{
var login = (from user in db.SEC_USER
where user.EMAIL.ToUpper().Equals(dbModel.Email.ToUpper()) && user.USER_PASSWORD.Equals(dbModel.Password)
select user).FirstOrDefault();
if (login == null)
{
return(null);
}
var date = dbModel.CurrentDate;
SEC_SESSION session = new SEC_SESSION()
{
USERID = login.ID,
LOGIN_DATE = date,
TOKEN_STATUS = true,
TOKEN = this.GetToken(String.Concat(login.ID, date)),
IP_ADDRESS = this.GetIpAddress()
};
db.SEC_SESSION.Add(session);
db.SaveChanges();
UserModelMapper mapper = new UserModelMapper();
return(mapper.MapperT1T2(login));
}
}
/// <summary>
/// Actualización de un registro
/// </summary>
/// <param name="dbModel"></param>
/// <returns></returns>
public int RecordUpdate(UserDbModel dbModel)
{
using (DesarrolloDocenteBDEntities db = new DesarrolloDocenteBDEntities())
{
try
{
var record = db.SEC_USER.Where(x => x.ID == dbModel.Id).FirstOrDefault();
if (record == null)
{
return(3);
}
record.NAME = dbModel.Name;
record.LASTNAME = dbModel.Lastname;
record.CELLPHONE = dbModel.Cellphone;
record.EMAIL = dbModel.Email;
record.USER_PASSWORD = dbModel.Password;
record.UPDATE_USER_ID = dbModel.UserInSessionId;
record.UPDATE_DATE = dbModel.CurrentDate;
db.SaveChanges();
return(1);
}
catch
{
return(2);
}
}
}
/// <summary>
/// Se agrega un nuevo registro a los roles
/// </summary>
/// <param name="dbModel">Representa un objeto con la información del rol</param>
/// <returns>entero con la respuesta: 1. OK, 2. KO, 3. Ya existe</returns>
public int RecordCreation(RoleDbModel dbModel)
{
using (DesarrolloDocenteBDEntities db = new DesarrolloDocenteBDEntities())
{
try
{
// Verifica si existe un role con el nombre que se quiere crear el nuevo
if (db.SEC_ROLE.Where(x => x.NAME.ToUpper().Equals(dbModel.Name.ToUpper())).Count() > 0)
{
return(3);
}
RoleModelMapper mapper = new RoleModelMapper();
SEC_ROLE record = mapper.MapperT2T1(dbModel);
db.SEC_ROLE.Add(record);
db.SaveChanges();
return(1);
}
catch
{
return(2);
}
}
}
/// <summary>
///
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
public IEnumerable <UserDbModel> RecordList(string filter)
{
using (DesarrolloDocenteBDEntities db = new DesarrolloDocenteBDEntities())
{
var lista = from role in db.SEC_USER
where !role.REMOVED && role.NAME.ToUpper().Contains(filter.ToUpper())
select role;
UserModelMapper mapper = new UserModelMapper();
var listaFinal = mapper.MapperT1T2(lista);
return(listaFinal);
}
}
/// <summary>
///
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
public IEnumerable <RoleDbModel> RecordList(string filter)
{
using (DesarrolloDocenteBDEntities db = new DesarrolloDocenteBDEntities())
{
//var listaLambda = db.SEC_ROLE.Where(x => !x.REMOVED && x.NAME.ToUpper().Contains(filter.ToUpper())).ToList();
var listaLinq = from role in db.SEC_ROLE
where !role.REMOVED && role.NAME.ToUpper().Contains(filter.ToUpper())
select role;
RoleModelMapper mapper = new RoleModelMapper();
var listaFinal = mapper.MapperT1T2(listaLinq);
return(listaFinal);
}
}
/// <summary>
/// Se agrega un nuevo registro a los roles
/// </summary>
/// <param name="dbModel">Representa un objeto con la información del rol</param>
/// <returns>entero con la respuesta: 1. OK, 2. KO, 3. Ya existe</returns>
public int RecordCreation(UserDbModel dbModel)
{
using (DesarrolloDocenteBDEntities db = new DesarrolloDocenteBDEntities())
{
try
{
UserModelMapper mapper = new UserModelMapper();
SEC_USER record = mapper.MapperT2T1(dbModel);
record.CREATE_DATE = dbModel.CurrentDate;
record.CREATE_USER_ID = dbModel.UserInSessionId;
db.SEC_USER.Add(record);
db.SaveChanges();
return(1);
}
catch
{
return(2);
}
}
}
/// <summary>
///
/// </summary>
/// <param name="dbModel"></param>
/// <returns></returns>
public int RecordRemove(RoleDbModel dbModel)
{
using (DesarrolloDocenteBDEntities db = new DesarrolloDocenteBDEntities())
{
try
{
var record = db.SEC_ROLE.Where(x => x.ID == dbModel.Id).FirstOrDefault();
if (record == null)
{
return(3);
}
//db.SEC_ROLE.Remove(record);
record.REMOVED = true;
db.SaveChanges();
return(1);
}
catch
{
return(2);
}
};
}