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); } } }