static public List <ExpenditureDTO> GetExpendituresList() { List <ExpenditureDTO> list = new List <ExpenditureDTO>(); using (SuperGmachEntities db = new SuperGmachEntities()) { foreach (Expenditure ex in db.Expenditure) { list.Add(ExpenditureConvert.DALtoDTO(ex)); } } return(list); }
static public ExpenditureDTO GetByID(int id) { ExpenditureDTO exDTO = new ExpenditureDTO(); using (SuperGmachEntities db = new SuperGmachEntities()) { try { var e = db.Expenditure.FirstOrDefault(exp => exp.Id == id); exDTO = ExpenditureConvert.DALtoDTO(e); } catch (Exception ex) { throw ex; } } return(exDTO); }