public void AddSaleOfferCategory(SaleOfferCategory saleOfferCategory)
{
using (SalesDB db = new SalesDB())
{
db.SalesOffersCategories.Add(saleOfferCategory);
db.SaveChanges();
}
}
private void ExecuteSave()
{
Mouse.OverrideCursor = Cursors.Wait;
DateTime _dt = DateTime.Now;
_saleOfferServ.AddSaleOffer(_newSaleOffer);
int _saleOfferID = _saleOfferServ.GetLastSaleOfferID();
foreach (var item in _saleOfferCategories)
{
SaleOfferCategory _saleOfferCategory = new SaleOfferCategory
{
CategoryID = item.CategoryID,
PriceAfterDiscount = item.PriceAfterDiscount,
PriceTotalAfterDiscount = item.PriceTotalAfterDiscount,
Price = item.Price,
PriceTotal = item.PriceTotal,
Discount = item.Discount,
DiscountValue = item.DiscountValue,
DiscountValueTotal = item.DiscountValueTotal,
SaleOfferID = _saleOfferID,
Qty = item.Qty
};
_saleOfferCategoryServ.AddSaleOfferCategory(_saleOfferCategory);
}
DS ds = new DS();
ds.Sale.Rows.Clear();
int i = 0;
foreach (var item in _saleOfferCategories)
{
ds.Sale.Rows.Add();
ds.Sale[i]["Client"] = _selectedClient.Name;
ds.Sale[i]["Serial"] = i + 1;
ds.Sale[i]["Category"] = item.Category + " " + item.Company;
ds.Sale[i]["Qty"] = item.Qty;
ds.Sale[i]["Price"] = Math.Round(Convert.ToDecimal(item.PriceAfterDiscount), 2);
ds.Sale[i]["TotalPrice"] = Math.Round(Convert.ToDecimal(item.PriceTotalAfterDiscount), 2);
ds.Sale[i]["BillPrice"] = Math.Round(Convert.ToDecimal(_newSaleOffer.PriceAfterDiscount), 2);;
i++;
}
ReportWindow rpt = new ReportWindow();
SaleOfferReport saleOfferRPT = new SaleOfferReport();
saleOfferRPT.SetDataSource(ds.Tables["Sale"]);
rpt.crv.ViewerCore.ReportSource = saleOfferRPT;
Mouse.OverrideCursor = null;
_currentWindow.Hide();
rpt.ShowDialog();
NewSaleOffer = new SaleOffer();
NewSaleOfferCategory = new SaleOfferCategoryVM();
SaleOfferCategories = new ObservableCollection <SaleOfferCategoryVM>();
NewSaleOffer.Date = DateTime.Now;
OldPrices = new ObservableCollection <SaleCategory>();
_currentWindow.ShowDialog();
}
