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);
}
public static Purchase ConvertPurchaseDTO(PurchaseDTO p)
{
return(new Purchase()
{
ExchangeRate = p.ExchangeRate,
MerchantID = p.MerchantID,
PurchaseDate = p.PurchaseDate,
PurchaseID = p.PurchaseID,
Remarks = p.Remarks,
TotalInPeso = p.TotalInPeso,
TotalInUSD = p.TotalInUSD
});
}
public bool Update(int id, PurchaseDTO dto)
{
int result = 0;
//int result = dataContext.ExecuteCommand(string.Format(DataResource.SQL_UpdatePurchase, dto.MerchantID, dto.TotalInUSD, dto.TotalInPeso, dto.ExchangeRate, dto.PurchaseDate, dto.Remarks, id));
Purchase p = dataContext.Purchases.Where(x => x.PurchaseID == id).FirstOrDefault();
if (p != null)
{
p.MerchantID = dto.MerchantID;
p.PurchaseDate = dto.PurchaseDate;
p.Remarks = dto.Remarks;
p.TotalInPeso = dto.TotalInPeso;
p.TotalInUSD = dto.TotalInUSD;
p.ExchangeRate = dto.ExchangeRate;
}
result = dataContext.GetChangeSet().Updates.Count;
dataContext.SubmitChanges();
return(result > 0);
}