private async void ExecuteAddToBillAsync()
{
if (NewSaleCategory.PriceTotalAfterDiscount == null || NewSaleCategory.Category == null)
{
return;
}
var mySettings = new MetroDialogSettings()
{
AffirmativeButtonText = "موافق",
DialogMessageFontSize = 25,
DialogTitleFontSize = 30
};
if (_saleCategories.SingleOrDefault(s => s.CategoryID == _newSaleCategory.CategoryID) != null)
{
MessageDialogResult result = await _currentWindow.ShowMessageAsync("خطأ", "هذا الصنف موجود مسبقاً فى الفاتورة", MessageDialogStyle.Affirmative, mySettings);
return;
}
if (_newSaleCategory.Qty > _selectedCategory.Qty)
{
MessageDialogResult result = await _currentWindow.ShowMessageAsync("خطأ", "هذه الكمية غير متوفرة فى المخزن", MessageDialogStyle.Affirmative, mySettings);
return;
}
_saleCategories.Add(_newSaleCategory);
NewSaleCategory = new SaleCategoryVM();
NewSale.Cost = SaleCategories.Sum(s => s.CostTotal);
NewSale.PriceAfterDiscount = SaleCategories.Sum(s => s.PriceTotalAfterDiscount);
NewSale.Price = SaleCategories.Sum(s => s.PriceTotal);
OldPrices = new ObservableCollection <SaleCategory>();
}
private async void ExecuteBrowseCategoriesAsync()
{
OldPrices = new ObservableCollection <SaleCategory>();
NewSaleCategory = new SaleCategoryVM();
Key = "";
Load();
_categoriesDialog.DataContext = this;
await _currentWindow.ShowMetroDialogAsync(_categoriesDialog);
}
private async void ExecuteAddToBillAsync()
{
try
{
if (NewSaleCategory.Price == null || NewSaleCategory.Qty == null || NewSaleCategory.Category == null)
{
return;
}
var mySettings = new MetroDialogSettings()
{
AffirmativeButtonText = "موافق",
DialogMessageFontSize = 25,
DialogTitleFontSize = 30
};
//if (_saleCategories.SingleOrDefault(s => s.CategoryID == _newSaleCategory.CategoryID) != null)
//{
// MessageDialogResult result = await _currentWindow.ShowMessageAsync("خطأ", "هذا الصنف موجود مسبقاً فى الفاتورة", MessageDialogStyle.Affirmative, mySettings);
// return;
//}
if (_newSaleCategory.Qty > _selectedCategory.Qty + _saleCategoryServ.GetCategoryQty(ID, _newSaleCategory.CategoryID))
{
MessageDialogResult result = await _currentWindow.ShowMessageAsync("خطأ", "هذه الكمية غير متوفرة فى المخزن", MessageDialogStyle.Affirmative, mySettings);
return;
}
_saleCategories.Add(_newSaleCategory);
NewSaleCategory = new SaleCategoryVM();
SelectedSale.Cost = SaleCategories.Sum(s => s.CostTotal);
SelectedSale.Price = SaleCategories.Sum(s => s.PriceTotal);
OldPrices = new ObservableCollection <SaleCategory>();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void ExecuteSave()
{
Mouse.OverrideCursor = Cursors.Wait;
DateTime _dt = DateTime.Now;
_newSale.RegistrationDate = _dt;
_saleServ.AddSale(_newSale);
int _saleID = _saleServ.GetLastSaleID();
foreach (var item in _saleCategories)
{
SaleCategory _saleCategory = new SaleCategory
{
CategoryID = item.CategoryID,
Cost = item.Cost,
PriceAfterDiscount = item.PriceAfterDiscount,
PriceTotalAfterDiscount = item.PriceTotalAfterDiscount,
CostTotal = item.CostTotal,
Price = item.Price,
PriceTotal = item.PriceTotal,
Discount = item.Discount,
DiscountValue = item.DiscountValue,
DiscountValueTotal = item.DiscountValueTotal,
SaleID = _saleID,
Qty = item.Qty
};
_saleCategoryServ.AddSaleCategory(_saleCategory);
Category cat = _categoryServ.GetCategory(item.CategoryID);
cat.Qty = cat.Qty - item.Qty;
_categoryServ.UpdateCategory(cat);
}
ClientAccount _account = new ClientAccount
{
ClientID = _newSale.ClientID,
Date = _newSale.Date,
RegistrationDate = _dt,
Statement = "فاتورة مبيعات رقم " + _saleID,
Credit = _newSale.Paid,
Debit = _newSale.PriceAfterDiscount + _newSale.TransportCost
};
_clientAccountServ.AddAccount(_account);
if (_newSale.Paid > 0)
{
Safe _safe = new Safe
{
Date = _newSale.Date,
RegistrationDate = _dt,
Statement = "فاتورة مبيعات رقم " + _saleID + " للعميل: " + _selectedClient.Name,
Amount = _newSale.Paid,
Source = 4
};
_safeServ.AddSafe(_safe);
}
DS ds = new DS();
ds.Sale.Rows.Clear();
int i = 0;
foreach (var item in _saleCategories)
{
ds.Sale.Rows.Add();
ds.Sale[i]["ID"] = _saleID;
ds.Sale[i]["Date"] = _newSale.Date;
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(_newSale.PriceAfterDiscount), 2);;
ds.Sale[i]["OldDebt"] = Math.Abs(Convert.ToDecimal(_newSale.OldDebt));
ds.Sale[i]["TransportCost"] = _newSale.TransportCost;
ds.Sale[i]["BillTotal"] = Math.Abs(Math.Round(Convert.ToDecimal(_newSale.PriceTotal), 2));
ds.Sale[i]["Paid"] = _newSale.Paid;
ds.Sale[i]["NewDebt"] = Math.Abs(Math.Round(Convert.ToDecimal(_newSale.NewDebt), 2));
if (_newSale.NewDebt > 0)
{
ds.Sale[i]["Type"] = "له";
}
else if (_newSale.NewDebt < 0)
{
ds.Sale[i]["Type"] = "عليه";
}
ds.Sale[i]["Salesperson"] = _selectedSalesperson.Name;
ds.Sale[i]["PrintingMan"] = _newSale.PrintingMan;
if (_newSale.OldDebt > 0)
{
ds.Sale[i]["Type2"] = "له";
}
else if (_newSale.OldDebt < 0)
{
ds.Sale[i]["Type2"] = "عليه";
}
ds.Sale[i]["Address"] = _selectedClient.Address;
try
{
ToWord toWord = new ToWord(Math.Abs(Convert.ToDecimal(_newSale.NewDebt)), currencies[0]);
ds.Sale[i]["NewDebtAR"] = toWord.ConvertToArabic();
}
catch
{
ds.Sale[i]["NewDebtAR"] = string.Empty;
}
i++;
}
ReportWindow rpt = new ReportWindow();
SaleReport saleRPT = new SaleReport();
saleRPT.SetDataSource(ds.Tables["Sale"]);
rpt.crv.ViewerCore.ReportSource = saleRPT;
Mouse.OverrideCursor = null;
_currentWindow.Hide();
rpt.ShowDialog();
NewSale = new Sale();
NewSaleCategory = new SaleCategoryVM();
SaleCategories = new ObservableCollection <SaleCategoryVM>();
NewSale.Date = DateTime.Now;
OldPrices = new ObservableCollection <SaleCategory>();
_currentWindow.ShowDialog();
}
private void ExecuteSave(string parameter)
{
try
{
Mouse.OverrideCursor = Cursors.Wait;
DateTime _dt = DateTime.Now;
_newSale.RegistrationDate = _dt;
_saleServ.AddSale(_newSale);
int _saleID = _saleServ.GetLastSaleID();
foreach (var item in _saleCategories)
{
SaleCategory _saleCategory = new SaleCategory
{
CategoryID = item.CategoryID,
Cost = item.Cost,
CostTotal = item.CostTotal,
Price = item.Price,
PriceTotal = item.PriceTotal,
SaleID = _saleID,
Qty = item.Qty
};
_saleCategoryServ.AddSaleCategory(_saleCategory);
Category cat = _categoryServ.GetCategory(item.CategoryID);
cat.Qty = cat.Qty - item.Qty;
_categoryServ.UpdateCategory(cat);
}
ClientAccount _account = new ClientAccount
{
ClientID = _newSale.ClientID,
Date = _newSale.Date,
RegistrationDate = _dt,
Statement = "فاتورة مبيعات رقم " + _saleID,
Credit = _newSale.CashPaid + _newSale.DiscountPaid,
Debit = _newSale.Price
};
_clientAccountServ.AddAccount(_account);
if (_newSale.CashPaid > 0)
{
Safe _safe = new Safe
{
Date = _newSale.Date,
RegistrationDate = _dt,
Statement = "فاتورة مبيعات رقم " + _saleID + " للعميل: " + _selectedClient.Name,
Amount = _newSale.CashPaid,
Source = 4
};
_safeServ.AddSafe(_safe);
}
DS ds = new DS();
ds.Sale.Rows.Clear();
int i = 0;
foreach (var item in _saleCategories)
{
ds.Sale.Rows.Add();
ds.Sale[i]["ID"] = _saleID;
ds.Sale[i]["Date"] = _newSale.Date;
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.Price), 2);
ds.Sale[i]["TotalPrice"] = Math.Round(Convert.ToDecimal(item.PriceTotal), 2);
ds.Sale[i]["BillPrice"] = Math.Round(Convert.ToDecimal(_newSale.Price), 2);;
ds.Sale[i]["OldDebt"] = Math.Abs(Convert.ToDecimal(_newSale.OldDebt));
ds.Sale[i]["BillTotal"] = Math.Abs(Math.Round(Convert.ToDecimal(_newSale.PriceTotal), 2));
ds.Sale[i]["Paid"] = _newSale.CashPaid;
ds.Sale[i]["DiscountPaid"] = _newSale.DiscountPaid;
ds.Sale[i]["NewDebt"] = Math.Abs(Math.Round(Convert.ToDecimal(_newSale.NewDebt), 2));
if (_newSale.NewDebt > 0)
{
ds.Sale[i]["Type"] = "له";
}
else if (_newSale.NewDebt < 0)
{
ds.Sale[i]["Type"] = "عليه";
}
if (_newSale.OldDebt > 0)
{
ds.Sale[i]["Type2"] = "له";
}
else if (_newSale.OldDebt < 0)
{
ds.Sale[i]["Type2"] = "عليه";
}
i++;
}
ReportWindow rpt = new ReportWindow();
if (parameter == "Client")
{
SaleReport saleRPT = new SaleReport();
saleRPT.SetDataSource(ds.Tables["Sale"]);
rpt.crv.ViewerCore.ReportSource = saleRPT;
Mouse.OverrideCursor = null;
}
else
{
SaleReport2 saleRPT = new SaleReport2();
saleRPT.SetDataSource(ds.Tables["Sale"]);
rpt.crv.ViewerCore.ReportSource = saleRPT;
Mouse.OverrideCursor = null;
}
_currentWindow.Hide();
rpt.ShowDialog();
NewSale = new Sale();
NewSaleCategory = new SaleCategoryVM();
SaleCategories = new ObservableCollection <SaleCategoryVM>();
NewSale.Date = DateTime.Now;
OldPrices = new ObservableCollection <SaleCategory>();
_currentWindow.ShowDialog();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
