public List <PurchaseDTO> GetAllPurchases()
{
List <PurchaseDTO> list = new List <PurchaseDTO>();
foreach (Purchase p in dataContext.Purchases)
{
list.Add(PurchaseDTOConverter.ConvertPurchase(p));
}
return(list);
}
public bool Save(PurchaseDTO dto)
{
//int result = dataContext.ExecuteCommand(string.Format(DataResource.SQL_SavePurchase, dto.MerchantID, dto.TotalInUSD, dto.TotalInPeso, dto.ExchangeRate, null , dto.Remarks));
Purchase p = PurchaseDTOConverter.ConvertPurchaseDTO(dto);
dataContext.Purchases.InsertOnSubmit(p);
int result = dataContext.GetChangeSet().Inserts.Count;
dataContext.SubmitChanges();
return(result > 0);
}
public PurchaseDTO GetOnePurchase(int id)
{
PurchaseDTO result = null;
Purchase data = dataContext.Purchases.Where(x => x.PurchaseID == id).FirstOrDefault();
if (data != null)
{
result = PurchaseDTOConverter.ConvertPurchase(data);
}
return(result);
}
