public OBRA_MSTR_DTO GetObraMstrRepository(int id)
{
OBRA_MSTR_DTO getObraMstrDto = new OBRA_MSTR_DTO();
if (ReferenceEquals(context, null))
{
context = new CalfuEntities();
}
try
{
_obraMstr = new OBRA_MSTR();
_obraMstr = context.OBRA_MSTR.Where(x => x.OBRA_ID.Equals(id)).FirstOrDefault();
getObraMstrDto.OBRA_ID = _obraMstr.OBRA_ID;
getObraMstrDto.ALIAS = _obraMstr.ALIAS;
getObraMstrDto.ANCHO = _obraMstr.ANCHO;
getObraMstrDto.DESCRIPCION = _obraMstr.DESCRIPCION;
getObraMstrDto.FILE_NAME = _obraMstr.FILE_NAME;
getObraMstrDto.ME_GUSTA = _obraMstr.ME_GUSTA;
getObraMstrDto.NO_ME_GUSTA = _obraMstr.NO_ME_GUSTA;
getObraMstrDto.TIPO_OBRA_ID = _obraMstr.TIPO_OBRA_ID;
getObraMstrDto.FLAG_VIGENTE = _obraMstr.FLAG_VIGENTE;
//OBRA_MSTR_DTO getObraMstrDto = context.OBRA_MSTR.Where(x => x.OBRA_ID.Equals(id)).ProjectTo<OBRA_MSTR_DTO>().FirstOrDefault();
return(getObraMstrDto);
}
catch (Exception ex)
{
return(null);
}
}
public List <OBRA_MSTR_DTO> SelectTop5ObrasMstrRepository()
{
try
{
_listObraMstrDtos = new List <OBRA_MSTR_DTO>();
if (ReferenceEquals(context, null))
{
context = new CalfuEntities();
}
_listObraMstrDtos = (from obraMstrbd in context.OBRA_MSTR
where obraMstrbd.FLAG_VIGENTE == 1
select new OBRA_MSTR_DTO
{
OBRA_ID = obraMstrbd.OBRA_ID,
ALIAS = obraMstrbd.ALIAS,
ANCHO = obraMstrbd.ANCHO,
DESCRIPCION = obraMstrbd.DESCRIPCION,
FILE_NAME = obraMstrbd.FILE_NAME,
ME_GUSTA = obraMstrbd.ME_GUSTA,
NO_ME_GUSTA = obraMstrbd.NO_ME_GUSTA,
TIPO_OBRA_ID = obraMstrbd.TIPO_OBRA_ID
}).OrderByDescending(x => x.ME_GUSTA).Take(5).ToList();
return(_listObraMstrDtos);
}
catch (Exception ex)
{
return(null);
}
}
public bool DeleteObraMstrRepository(int id)
{
try
{
if (ReferenceEquals(context, null))
{
context = new CalfuEntities();
}
OBRA_MSTR obraMstr = context.OBRA_MSTR.Where(x => x.OBRA_ID.Equals(id)).SingleOrDefault();
if (!ReferenceEquals(obraMstr, null))
{
obraMstr.FLAG_VIGENTE = 2;
context.SaveChanges();
//context.OBRA_MSTR.Remove(obraMstr);
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
return(false);
}
}
public bool UpdateObraMstr(OBRA_MSTR_DTO dto)
{
try
{
if (ReferenceEquals(context, null))
{
context = new CalfuEntities();
}
OBRA_MSTR obraMstr = context.OBRA_MSTR.Where(x => x.OBRA_ID.Equals(dto.OBRA_ID)).SingleOrDefault();
if (!ReferenceEquals(null, obraMstr))
{
obraMstr.ALIAS = dto.ALIAS;
obraMstr.ANCHO = dto.ANCHO;
obraMstr.DESCRIPCION = dto.DESCRIPCION;
obraMstr.FILE_NAME = dto.FILE_NAME;
obraMstr.ME_GUSTA = dto.ME_GUSTA;
obraMstr.NO_ME_GUSTA = dto.NO_ME_GUSTA;
obraMstr.TIPO_OBRA_ID = dto.TIPO_OBRA_ID;
context.SaveChanges();
}
context.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool UpdateUserMstr(USER_MSTR_DTO dto)
{
try
{
if (ReferenceEquals(context, null))
{
context = new CalfuEntities();
}
USER_MSTR userMstr = context.USER_MSTR.Where(x => x.USER_ID.Equals(dto.USER_ID)).SingleOrDefault();
if (!ReferenceEquals(null, userMstr))
{
userMstr.USER_NAME = dto.USER_NAME;
userMstr.USER_PASS = dto.USER_PASS;
userMstr.USER_NICK = dto.USER_NICK;
context.SaveChanges();
}
context.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool DeleteUserMstrRepository(int id)
{
try
{
if (ReferenceEquals(context, null))
{
context = new CalfuEntities();
}
USER_MSTR userMstr = context.USER_MSTR.Where(x => x.USER_ID.Equals(id)).SingleOrDefault();
if (!ReferenceEquals(userMstr, null))
{
context.USER_MSTR.Remove(userMstr);
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
return(false);
}
}
public List <USER_MSTR_DTO> SelectUserMstrRepository()
{
try
{
_listUserMstrDtos = new List <USER_MSTR_DTO>();
if (ReferenceEquals(context, null))
{
context = new CalfuEntities();
}
_listUserMstrDtos = (from userMstrbd in context.USER_MSTR
select new USER_MSTR_DTO
{
USER_ID = userMstrbd.USER_ID,
USER_NAME = userMstrbd.USER_NAME,
USER_PASS = userMstrbd.USER_PASS,
USER_NICK = userMstrbd.USER_NICK
}).OrderBy(x => x.USER_ID).ToList();
return(_listUserMstrDtos);
}
catch (Exception ex)
{
return(null);
}
}
public bool LoginByName(string nick, string pass)
{
try
{
if (ReferenceEquals(context, null))
{
context = new CalfuEntities();
}
USER_MSTR userMstr = context.USER_MSTR.Where(x => x.USER_NICK.Equals(nick) && x.USER_PASS.Equals(pass)).FirstOrDefault();
if (ReferenceEquals(userMstr, null))
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
return(false);
}
}
public bool ExistObraMstrRepository(int id)
{
if (ReferenceEquals(context, null))
{
context = new CalfuEntities();
}
OBRA_MSTR obraMstr = context.OBRA_MSTR.Where(x => x.OBRA_ID.Equals(id)).SingleOrDefault();
if (ReferenceEquals(obraMstr, null))
{
return(true);
}
else
{
return(false);
}
}
public bool ExistUserMstrRepository(int id)
{
if (ReferenceEquals(context, null))
{
context = new CalfuEntities();
}
USER_MSTR userMstr = context.USER_MSTR.Where(x => x.USER_ID.Equals(id)).SingleOrDefault();
if (!ReferenceEquals(userMstr, null))
{
return(true);
}
else
{
return(false);
}
}
