//decrease amount of item in stock
private bool decreaseAmountOfItemInStock(int itemCode, int amountToDecrease)
{
ItemStockTable itemStockT = new ItemStockTable();
DataRow rowToUpdate = itemStockT.Find("codeItemInStoke", itemCode + "");
bool returnValue = true;
if (rowToUpdate != null)
{
int oldAmount = int.Parse(rowToUpdate["amountOfStoke"].ToString());
rowToUpdate["amountOfStoke"] = (oldAmount - amountToDecrease).ToString();
try
{
itemStockT.Update(rowToUpdate);
}
catch (Exception)
{
returnValue = false;
}
}
else
{
returnValue = false;
}
return(returnValue);
}
private void btnApprove_Click(object sender, EventArgs e)
{
try
{
ItemStockTable itemsStockT = new ItemStockTable();
DataRow rowToAdd;
if (ItemsStockList.Count != 0)
{
foreach (var item in ItemsStockList)
{
rowToAdd = itemsStockT.Dt.NewRow();
rowToAdd["codeItemInStoke"] = item.CodeItemStock;
rowToAdd["CodeItem"] = item.CodeItem;
rowToAdd["colorOfItem"] = item.CodeColor;
rowToAdd["codeSize"] = item.CodeSize;
rowToAdd["amountOfStoke"] = item.Amount;
rowToAdd["minStoke"] = 0;
rowToAdd["maxStoke"] = 100;
itemsStockT.Add(rowToAdd);
}
MessageBox.Show("הפריטים הוספו למלאי בהצלחה");
this.Close();
}
else
{
MessageBox.Show("אין מלאי להוספה");
}
}
catch (Exception)
{
}
}
public FrmAddItemStock()
{
ColorsTable colorsT = new ColorsTable();
SizesTable sizesT = new SizesTable();
ItemsTable itemsT = new ItemsTable();
ItemStockTable itemStockT = new ItemStockTable();
ItemsStockList = new List <SingleitemStock>();
NextCode = itemStockT.getNextCode();
InitializeComponent();
//colors cmb
cmbColors.DataSource = colorsT.Dt;
cmbColors.DisplayMember = "NameColor";
cmbColors.ValueMember = "CodeColor";
cmbColors.SelectedValue = -1;
cmbColors.Text = "-בחר צבע-";
//sizes cmb
cmbSizes.DataSource = sizesT.Dt;
cmbSizes.DisplayMember = "nameSize";
cmbSizes.ValueMember = "codeSize";
cmbSizes.SelectedValue = -1;
cmbSizes.Text = "-בחר מידה-";
//items cmb
cmbItems.DataSource = itemsT.Dt;
cmbItems.DisplayMember = "NameItem";
cmbItems.ValueMember = "CodeItem";
cmbItems.SelectedValue = -1;
cmbItems.Text = "-בחר פריט-";
//disable cmb and txtAmount before choosing an item
cmbSizes.Enabled = false;
cmbColors.Enabled = false;
txtAmount.Enabled = false;
btnAddStock.Enabled = false;
//add events to cmb and txt
cmbColors.KeyPress += new KeyPressEventHandler(cmbColors_KeyPress);
cmbSizes.KeyPress += new KeyPressEventHandler(cmbColors_KeyPress);
cmbItems.KeyPress += new KeyPressEventHandler(cmbColors_KeyPress);
txtAmount.KeyPress += new KeyPressEventHandler(txtAmount_KeyPress);
cmbItems.SelectedValueChanged += new EventHandler(cmbItems_SelectedValueChanged);
cmbColors.SelectedValueChanged += new EventHandler(cmbSizes_SelectedValueChanged);
cmbSizes.SelectedValueChanged += new EventHandler(cmbSizes_SelectedValueChanged);
txtAmount.TextChanged += new EventHandler(cmbSizes_SelectedValueChanged);
btnAddStock.Click += new EventHandler(btnAddStock_Click);
btnApprove.Click += new EventHandler(btnApprove_Click);
//initialize itemStocks list
int columnWidth = lstItemsStock.Width / 4;
lstItemsStock.View = View.Details;
lstItemsStock.GridLines = true;
lstItemsStock.FullRowSelect = true;
lstItemsStock.RightToLeft = RightToLeft.Yes;
lstItemsStock.Columns.Add("כמות", columnWidth);
lstItemsStock.Columns.Add("מידה", columnWidth);
lstItemsStock.Columns.Add("צבע", columnWidth);
lstItemsStock.Columns.Add("שם פריט", columnWidth);
}
//add row for order, rows for order details and row for credit card.
private bool addOrderDetails()
{
bool returnValue = true;
int orderCode = 0;
ItemStockTable itemStockT = new ItemStockTable();
ItemsTable itemT = new ItemsTable();
OrderDetailsTable orderDetailsT = new OrderDetailsTable();
//add order
try
{
OrdersTable ordersTable = new OrdersTable();
DataRow rowToAdd = ordersTable.Dt.NewRow();
DataRow currentRow = OrderToAdd.BuildRow();
orderCode = int.Parse(currentRow["CodeOrder"].ToString());
rowToAdd["CodeOrder"] = currentRow["CodeOrder"];
rowToAdd["IDCust"] = currentRow["IDCust"];
rowToAdd["DateOrder"] = currentRow["DateOrder"];
returnValue = ordersTable.Add(rowToAdd);
}
catch (Exception)
{
returnValue = false;
}
//add order details
OrderDetails detailToAdd;
groupItemsList();
foreach (var item in ShoppingCartListItems)
{
if (item.ItemAmount > 0)
{
detailToAdd = new OrderDetails();
detailToAdd.CodeOrder = orderCode;
detailToAdd.CodeItemStoke = itemStockT.getItemStockCode(item.ItemCode, item.ColorCode, item.SizeCode) + "";
//decrease amount of items in stock
returnValue = decreaseAmountOfItemInStock(int.Parse(detailToAdd.CodeItemStoke), item.ItemAmount);
detailToAdd.Amount = item.ItemAmount;
detailToAdd.PriceItem = itemT.getItemPrice(item.ItemCode);
detailToAdd.SaleItem = itemT.isSaleItem(item.ItemCode);
try
{
DataRow rowToAdd = detailToAdd.BuildRow();
returnValue = orderDetailsT.Add(rowToAdd);
}
catch (Exception)
{
returnValue = false;
}
}
}
//add credit card details
CreditCardOfCustomers card = new CreditCardOfCustomers();
CreditCardOfCustomersTable creditCardT = new CreditCardOfCustomersTable();
card.CodeCreditCard = creditCardT.getNextCode();
card.CodeOrder = orderCode;
card.NumCreditCard = txtNumCard.Text;
card.ValidityOfCreditCard = dtpValidate.Value;
card.IdOwner = txtBID.Text;
card.ThreeNumOnCard = int.Parse(txtBThree.Text);
card.TotalOfPrice = lblPaymentSum.Text;
card.NumOfPayments = (int)nudNumOfPayments.Value;
card.KindOfDeal = "חיוב";
DataRow rowToAddToCreditCardT = card.BuildRow();
try
{
creditCardT.Add(rowToAddToCreditCardT);
}
catch (Exception)
{
returnValue = false;
}
return(returnValue);
}