private void Button_Click_1(object sender, RoutedEventArgs e)
{
int Item_Id = int.Parse(ItemCombo.SelectedValue.ToString());
var SelectItem = context.Items.Where(item => item.ID == Item_Id).FirstOrDefault();
int No = int.Parse(NoOfInvoice.Text);
purchaseInvoice CurrentEdit = context.purchaseInvoices.Where(recip => recip.ID == No).FirstOrDefault();
ItemInPurchaseInvoice CurrentEditQuan = context.ItemInPurchaseInvoices.Where(recip => recip.purchaseInvoice_Id == CurrentEdit.ID && recip.Item_Id == SelectItem.ID).FirstOrDefault();
if (CurrentEdit == null)
{
return;
}
SelectItem.Quantity += CurrentEditQuan.Quantity;
CurrentEditQuan.Quantity = int.Parse(Quantity.Text);
SelectItem.Quantity -= CurrentEditQuan.Quantity;
ListViewRecipt Row = ListView.SelectedItem as ListViewRecipt;
if (Row == null)
{
return;
}
SubtractTotal(Row.Quantity, Row.PriceForPiece);
Row.Quantity = int.Parse(Quantity.Text);
ListView.Items.Remove(ListView.SelectedItem);
Total.Text = calculateTotal(Row.Quantity, Row.PriceForPiece).ToString();
CategoryCombo.IsEnabled = true;
ItemCombo.IsEnabled = true;
ListView.Items.Add(Row);
context.SaveChanges();
}
private void Button_Click(object sender, RoutedEventArgs e)
{
if (Regex.IsMatch(Quantity.Text, "[^ 0-9]*") || double.Parse(Quantity.Text) <= 0)
{
MessageBox.Show("This Quantity is not Valid");
}
else if (CategoryCombo.SelectedIndex != -1 && ItemCombo.SelectedIndex != -1 && SupllierCombo.SelectedIndex != -1 && Quantity.Text != "")
{
int Item_Id = int.Parse(ItemCombo.SelectedValue.ToString());
var SelectItem = context.Items.Where(item => item.ID == Item_Id).FirstOrDefault();
int AvailableQuantity = SelectItem.Quantity;
if (int.Parse(Quantity.Text) > AvailableQuantity)
{
MessageBox.Show("There aren't This Quantity In Store");
}
else
{
int QuantityValue = int.Parse(Quantity.Text);
int supp_Id = int.Parse(SupllierCombo.SelectedValue.ToString());
if (CreatedObject == false)
{
recipt = new purchaseInvoice()
{
Date = DateTime.Now,
Supplier = context.Suppliers.Where(sup => sup.ID == supp_Id).FirstOrDefault(),
ItemInPurchaseInvoices = new List <ItemInPurchaseInvoice>()
};
CreatedObject = true;
context.purchaseInvoices.Add(recipt);
}
ItemInPurchaseInvoice itemsRecipted = new ItemInPurchaseInvoice();
itemsRecipted.Item = SelectItem;
itemsRecipted.purchaseInvoice = recipt;
itemsRecipted.Quantity = QuantityValue;
recipt.ItemInPurchaseInvoices.Add(itemsRecipted);
SelectItem.ItemInPurchaseInvoices.Add(itemsRecipted);
SelectItem.Quantity -= int.Parse(Quantity.Text);
TotalValues += (int.Parse(Quantity.Text) * SelectItem.SellPrice);
var suplier = context.Suppliers.Where(sallr => sallr.ID == supp_Id).FirstOrDefault();
suplier.purchaseInvoices.Add(recipt);
context.SaveChanges();
Total.Text = TotalValues.ToString();
NoOfInvoice.Text = recipt.ID.ToString();
salesMan.Text = SupllierCombo.Text;
this.ListView.Items.Add(new ListViewRecipt {
ID = int.Parse(NoOfInvoice.Text), Category = CategoryCombo.Text, Item_Name = ItemCombo.Text, Quantity = int.Parse(Quantity.Text), PriceForPiece = SelectItem.SellPrice, TotalPrice = double.Parse(Quantity.Text) * SelectItem.SellPrice
});
Edit.IsEnabled = true;
Delete.IsEnabled = true;
SupllierCombo.IsEnabled = false;
}
}
else
{
MessageBox.Show("Enter Correct Data");
}
}
public ItemInPurchaseInvoice CreateInvoice(int SelectItem, int recipt, int QuantityValue)
{
ItemInPurchaseInvoice itemsRecipted = new ItemInPurchaseInvoice();
itemsRecipted.Item_Id = SelectItem;
itemsRecipted.purchaseInvoice_Id = recipt;
itemsRecipted.Quantity = QuantityValue;
context.ItemInPurchaseInvoices.Add(itemsRecipted);
context.SaveChanges();
return(itemsRecipted);
}
private void Button_Click(object sender, RoutedEventArgs e)
{
try
{ int result = 0;
if (NameText.SelectedIndex != -1 && CategoryCombo.SelectedIndex != -1 && Quantity.Text != "" && int.TryParse(Quantity.Text, out result) == true)
{
if (result < 0)
{
MessageBox.Show("Enter Positive Num Only");
return;
}
int item_Id = int.Parse(ItemCombo.SelectedValue.ToString());
var query = itmLay.GetItem(item_Id);
int quan = int.Parse(Quantity.Text);
int Sal_Id = int.Parse(NameText.SelectedValue.ToString());
int inv_Id = int.Parse(NoOfInvoice.Text);
ItemInPurchaseInvoice itm = ItmpurLay.CreateInvoice(item_Id, inv_Id, quan);
itmLay.IncreaseQuantity(query, quan);
DateTime date = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day);
List1.ItemsSource = null;
var Items = itmLay.GetItemWithItemsMapping(inv_Id, date);
Add.IsEnabled = true;
List1.ItemsSource = null;
List1.ItemsSource = Items.ToList();
MessageBox.Show("Done");
}
else
{
MessageBox.Show("Pleast Enter All DAta And Quantity Should be number Positive");
} }
catch
{
MessageBox.Show("Enter Valid Data");
}
}
private void btnadditem_Click(object sender, RoutedEventArgs e)
{
int qty, sellprice, buyprice;
bool tryqty = int.TryParse(txtQty.Text, out qty);
bool trysellprice = int.TryParse(txtsellprice.Text, out sellprice);
bool trybuyprice = int.TryParse(txtBuyPrice.Text, out buyprice);
//bool xx = int.Parse(txtsellprice.Text) > int.Parse(txtBuyPrice.Text);
if (LVitems.Items.Count == 0 && cmbitems.Items.Count > 0 && txtQty.Text != "" && tryqty && sellprice > buyprice && qty > 0 && trysellprice && trybuyprice)
{
cmbsuppliers.IsEnabled = false;
Item items = (Item)cmbitems.SelectedItem;
Item current_item = context.Items.Where(c => c.ID == items.ID).First();
current_item.Quantity += int.Parse(txtQty.Text);
current_item.SellPrice = int.Parse(txtsellprice.Text);
current_item.BuyPrice = int.Parse(txtBuyPrice.Text);
Supplier selected_supplier = (Supplier)cmbsuppliers.SelectedItem;
if (FirstClick == false)
{
pi = new purchaseInvoice();
pi.Date = DateTime.Now;
// pi.Quantity = int.Parse(txtQty.Text);
pi.Supplier = selected_supplier;
pi.Supplier = (Supplier)cmbsuppliers.SelectedItem;
pi.KindOfInvoice = true;
pi.TotalPrice = int.Parse(txtQty.Text) * int.Parse(current_item.BuyPrice.ToString());
context.purchaseInvoices.Add(pi);
FirstClick = true;
}
selected_supplier.purchaseInvoices.Add(pi);
ItemInPurchaseInvoice iip = new ItemInPurchaseInvoice();
// iip.Item = ;
iip.Item_Id = current_item.ID;
iip.purchaseInvoice_Id = pi.ID;
iip.purchaseInvoice = pi;
iip.Quantity = int.Parse(txtQty.Text);
////////////////
context.ItemInPurchaseInvoices.Add(iip);
context.SaveChanges();
MessageBox.Show("your items succesfuly");
}
else if (LVitems.Items.Count >= 1)
{
cmbsuppliers.IsEnabled = false;
foreach (var item in listoflvitems)
{
// Context c = new Context();
Supplier selected_supplier = (Supplier)cmbsuppliers.SelectedItem;
Item current_item = context.Items.Where(cc => cc.ID == item.ID).First();
// Item current_item = context.Items.Where(c => c.ID == item.ID).First();
if (FirstClick == false)
{
pi = new purchaseInvoice();
pi.Date = DateTime.Now;
// pi.Quantity = int.Parse(txtQty.Text);
pi.KindOfInvoice = true;
pi.Supplier = selected_supplier;
pi.Supplier = (Supplier)cmbsuppliers.SelectedItem;
// pi.TotalPrice = int.Parse(txtQty.Text) * int.Parse(current_item.BuyPrice.ToString());
context.purchaseInvoices.Add(pi);
FirstClick = true;
}
//purchaseInvoice pi = new purchaseInvoice();
pi.Date = DateTime.Now;
// pi.Quantity = item.Quantity;
// Supplier selected_supplier =item.SupplierID;
pi.Supplier = item.Supplier;
pi.KindOfInvoice = true;
pi.Supplier = item.Supplier; //(Supplier)cmbsuppliers.SelectedItem;
pi.TotalPrice = item.Quantity * int.Parse(current_item.BuyPrice.ToString());
// selected_supplier.purchaseInvoices.Add(pi);
ItemInPurchaseInvoice iip = new ItemInPurchaseInvoice();
//item.item.ItemInPurchaseInvoices = new List<ItemInPurchaseInvoice>();
// iip.Item = ;
iip.Item_Id = current_item.ID;
iip.purchaseInvoice_Id = pi.ID;
iip.purchaseInvoice = pi;
iip.Quantity = item.Quantity;
current_item.Quantity += item.Quantity;
current_item.SellPrice = item.SellPrice;
current_item.BuyPrice = item.BuyPrice;
item.Supplier.purchaseInvoices.Add(pi);
//item.item
context.ItemInPurchaseInvoices.Add(iip);
//context.Suppliers.Add();
context.SaveChanges();
}
MessageBox.Show("your list of items added succesfuly");
LVitems.Items.Clear();
listoflvitems.Clear();
}
else
{
MessageBox.Show("Plz check that:\n 1-you choosed an item \n" +
" 2-you choosed a supplier \n " +
"3- sell price bigger than buy price and bigger than zero ");
}
}
