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);
}
static public void AddExpenditure(ExpenditureDTO Expenditure)
{
using (SuperGmachEntities db = new SuperGmachEntities())
{
try
{
Expenditure e = ExpenditureConvert.TDOtoDAL(Expenditure);
db.Expenditure.Add(e);
//fundId 1 is for the main fund
if (Expenditure.NameStatus == "performed")
{
FundBL.Subtract_Balance(Expenditure.Amount, "1");
}
db.SaveChanges();
}
catch (Exception e)
{
throw e;
}
}
}
