public List <Log> GetListLogs()
{
try
{
Data.Entities entities = new Data.Entities();
List <Log> _ListLog = entities.Logs.OrderByDescending(x => x.date_transaction).ToList();
return(_ListLog);
}
catch (Exception ex)
{
throw new Exception("Error de DAL -" + ex.Message);
}
}
public List <Log> GetListLogs(string startDate, string endDate, int Uid)
{
try
{
Data.Entities entities = new Data.Entities();
List <Log> list = new List <Log>();
list = entities.Logs.SqlQuery("SELECT * FROM Log l WITH(NOLOCK) WHERE L.date_transaction >= CAST(@startdt AS varchar) AND L.date_transaction <= CAST(@enddt AS varchar) AND Uid=@uid "
, new SqlParameter("@startdt", startDate)
, new SqlParameter("@uid", Uid)
, new SqlParameter("@enddt", endDate)).ToList();
return(list);
}
catch (Exception ex)
{
throw new Exception("Error de DAL -" + ex.Message);
}
}
public ObjResponse InsertLog(Log _objLog)
{
try
{
Data.Entities entities = new Data.Entities();
ObjResponse _response = new ObjResponse();
entities.Logs.Add(_objLog);
if (entities.SaveChanges() > 0)
{
_response.Message = "Se inserto Correctamente"; _response.Response = true;
}
else
{
_response.Message = "Algo salio mal :( "; _response.Response = false;
}
return(_response);
}
catch (Exception ex)
{
if (!string.IsNullOrWhiteSpace(ex.InnerException.InnerException.Message))
{
if (ex.InnerException.InnerException.Message.Contains("FOREIGN KEY"))
{
throw new Exception("Error de DAL - El UID enviado no corresponde a ningun usuario creado en el sistema.");
}
else
{
throw new Exception("Error de DAL -" + ex.InnerException.InnerException.Message);
}
}
else
{
throw new Exception("Error de DAL -" + ex.Message);
}
}
}
