private void ProductOutOfStockBtn_Click(object sender, EventArgs e)
{
this.productsPanel[4].BringToFront();
ServiceReference1.ProductServiceClient client = new ServiceReference1.ProductServiceClient();
products = new List <ServiceReference1.Product>(client.GetProductOutOfStock());
setGridView4();
}
private void UpdateProductBtn_Click(object sender, EventArgs e)
{
this.productsPanel[3].BringToFront();
ServiceReference1.ProductServiceClient client = new ServiceReference1.ProductServiceClient();
products = new List <ServiceReference1.Product>(client.GetAllProduct());
setGridView3();
}
private void LastYearSalesBtn_Click(object sender, EventArgs e)
{
this.billsPanel[3].BringToFront();
var source = new BindingSource();
ServiceReference1.ProductServiceClient client = new ServiceReference1.ProductServiceClient();
source.DataSource = client.GetLastYearSales();;
dataGridView7.DataSource = source;
}
private void initOrderDetails()
{
QuantityInOrderTB.Text = "1";
ProductInStockLB.Items.Clear();
ProductInOrderLB.Items.Clear();
TotalProductsTB.Text = "";
TotalItemsTB.Text = "";
TotalAmountTB.Text = "";
ServiceReference1.ProductServiceClient client = new ServiceReference1.ProductServiceClient();
products = new List <ServiceReference1.Product>(client.GetProductInStock());
foreach (ServiceReference1.Product p in products)
{
ProductInStockLB.Items.Add("Id :- " + p.ProductId + " Name :- " + p.ProductName);
}
PaymentMethodLB.SelectedIndex = -1;
bill = new Bill();
}
private void ViewProducsBtn_Click(object sender, EventArgs e)
{
this.productsPanel[1].BringToFront();
var source = new BindingSource();
ServiceReference1.ProductServiceClient client = new ServiceReference1.ProductServiceClient();
List <ServiceReference1.Product> pList = new List <ServiceReference1.Product>(client.GetAllProduct());
source.DataSource = pList;
dataGridView1.DataSource = source;
dataGridView1.Columns["ProductId"].DisplayIndex = 0;
dataGridView1.Columns["ProductName"].DisplayIndex = 1;
dataGridView1.Columns["ProductPrice"].DisplayIndex = 2;
dataGridView1.Columns["TotalQuantity"].DisplayIndex = 3;
dataGridView1.Columns["QuantityAtShop"].DisplayIndex = 4;
dataGridView1.Columns["QuantityAtGodown"].DisplayIndex = 5;
dataGridView1.Columns["Description"].DisplayIndex = 6;
}
private void AddBtn_Click(object sender, EventArgs e)
{
if (ProductNameTB.Text == "")
{
MessageBox.Show("Please enter product name.");
}
else if (ProductPriceTB.Text == "")
{
MessageBox.Show("Please enter product price.");
}
else if (QuantityAtShopTB.Text == "")
{
MessageBox.Show("Please enter product quantity at shop.");
}
else if (QuantityAtGodownTB.Text == "")
{
MessageBox.Show("Please enter product quantity at godown.");
}
else
{
Product p = new Product(ProductNameTB.Text, Convert.ToInt32(ProductPriceTB.Text), Convert.ToInt32(QuantityAtShopTB.Text), Convert.ToInt32(QuantityAtGodownTB.Text), DescriptionTB.Text);
ServiceReference1.Product ps = new ServiceReference1.Product();
ps.ProductId = p.ProductId;
ps.ProductName = p.ProductName;
ps.ProductPrice = p.ProductPrice;
ps.TotalQuantity = p.TotalQuantity;
ps.QuantityAtShop = p.QuantityAtShop;
ps.QuantityAtGodown = p.QuantityAtGodown;
ps.Description = p.Description;
ServiceReference1.ProductServiceClient client = new ServiceReference1.ProductServiceClient();
int id = client.AddProduct(ps);
if (id == -1)
{
AddProductLbl.Text = "Error adding product.";
}
else
{
AddProductLbl.Text = "Product added successfully with id " + id;
}
}
initAddProduct();
}
private void ConfirmOrderBtn_Click(object sender, EventArgs e)
{
int id = PaymentMethodLB.SelectedIndex;
int count = ProductInOrderLB.Items.Count;
if (count == 0)
{
MessageBox.Show("Please Add Product To Order.");
return;
}
this.bill.calculateTotalAmount();
TotalProductsTB.Text = bill.TotalProducts.ToString();
TotalItemsTB.Text = bill.TotalItems.ToString();
TotalAmountTB.Text = bill.TotalAmount.ToString();
if (id == -1)
{
MessageBox.Show("Please Select Payment Method.");
return;
}
bill.PaymentMethod = PaymentMethodLB.SelectedItem.ToString();
ServiceReference1.Bill b = new ServiceReference1.Bill();
b.BillId = bill.BillId;
b.BillDate = bill.BillDate;
b.TotalProducts = bill.TotalProducts;
b.TotalItems = bill.TotalItems;
b.TotalAmount = bill.TotalAmount;
b.PaymentMethod = bill.PaymentMethod;
b.Products = bill.Products.ToArray();
b.Quantity = bill.Quantity.ToArray();
ServiceReference1.ProductServiceClient client = new ServiceReference1.ProductServiceClient();
int billId = client.AddBill(b);
if (billId == -1)
{
OrderIDLbl.Text = "Error in adding to database.";
return;
}
OrderIDLbl.Text = "Bill added with id :- " + billId;
initOrderDetails();
return;
}
private void TransferFromGodownTOSHopBtn_Click(object sender, EventArgs e)
{
int id = dataGridView2.SelectedRows.Count;
if (id == 0)
{
MessageBox.Show("Please Select Product.");
return;
}
if (QuantityTB.Text == "")
{
MessageBox.Show("Please Enter Quantity.");
return;
}
ServiceReference1.Product p = products[dataGridView2.SelectedRows[0].Index];
p.QuantityAtShop += Convert.ToInt32(QuantityTB.Text);
p.QuantityAtGodown -= Convert.ToInt32(QuantityTB.Text);
ServiceReference1.ProductServiceClient client = new ServiceReference1.ProductServiceClient();
client.UpdateProductQuantityAtShop(p.ProductId, p.QuantityAtShop);
client.UpdateProductQuantityAtGodown(p.ProductId, p.QuantityAtGodown);
QuantityTB.Text = "";
}
private void UpdateValueBtn_Click(object sender, EventArgs e)
{
int count = dataGridView3.SelectedRows.Count;
if (count == 0)
{
MessageBox.Show("Please Select Product.");
ProductParameters.SelectedIndex = -1;
return;
}
ServiceReference1.Product p = products[dataGridView3.SelectedRows[0].Index];
int id = ProductParameters.SelectedIndex;
if (id == -1)
{
MessageBox.Show("Please Select Product Parameter.");
ProductParameters.SelectedIndex = -1;
return;
}
ServiceReference1.ProductServiceClient client = new ServiceReference1.ProductServiceClient();
if (id == 0)
{
if (UpdateValueTB.Text != p.ProductName)
{
p.ProductName = UpdateValueTB.Text;
client.UpdateProductName(p.ProductId, p.ProductName);
}
}
else if (id == 1)
{
if (Convert.ToInt32(UpdateValueTB.Text) != p.ProductPrice)
{
p.ProductPrice = Convert.ToInt32(UpdateValueTB.Text);
client.UpdateProductPrice(p.ProductId, p.ProductPrice);
}
}
else if (id == 2)
{
if (Convert.ToInt32(UpdateValueTB.Text) != p.QuantityAtShop)
{
p.TotalQuantity -= p.QuantityAtShop;
p.QuantityAtShop = Convert.ToInt32(UpdateValueTB.Text);
p.TotalQuantity += p.QuantityAtShop;
client.UpdateProductQuantityAtShop(p.ProductId, p.QuantityAtShop);
client.UpdateProductTotalQuantity(p.ProductId, p.TotalQuantity);
}
}
else if (id == 3)
{
if (Convert.ToInt32(UpdateValueTB.Text) != p.QuantityAtGodown)
{
p.TotalQuantity -= p.QuantityAtGodown;
p.QuantityAtGodown = Convert.ToInt32(UpdateValueTB.Text);
p.TotalQuantity += p.QuantityAtGodown;
client.UpdateProductQuantityAtGodown(p.ProductId, p.QuantityAtGodown);
client.UpdateProductTotalQuantity(p.ProductId, p.TotalQuantity);
}
}
else if (id == 4)
{
if (UpdateValueTB.Text != p.Description)
{
p.Description = UpdateValueTB.Text;
client.UpdateProductDescription(p.ProductId, p.Description);
}
}
}
