private void saveButton_Click(object sender, EventArgs e)
{
purchase.ProductName = productComboBox.Text;
purchase.ProductQty = Convert.ToInt32(qtyTextBox.Text);
purchase.ProductUnit = unitLabel.Text;
purchase.ProductPrice = Convert.ToDouble(priceTextBox.Text);
purchase.ProductTotal = Convert.ToDouble(totalTextBox.Text);
purchase.PurchaseDate = purchaseDate.Value.ToString("dd-MM-yyyy");
purchase.PurchasePartyName = dealerComboBox.Text;
purchase.PurchaseType = purchaseTypeComboBox.Text;
purchase.ExpireDate = expireDate.Value.ToString("dd-MM-yyyy");
purchase.Profit = Convert.ToDouble(profitTextBox.Text);
if (productComboBox.Text == "" || qtyTextBox.Text == "" || priceTextBox.Text == "")
{
MessageBox.Show("Field must not be empty..");
}
if (!_purchaseManager.IsStock(productComboBox.Text))
{
if (_purchaseManager.Add(purchase))
{
if (_purchaseManager.AddStock(purchase))
{
MessageBox.Show("Added");
return;
}
else
{
MessageBox.Show("Not Added");
return;
}
}
else
{
MessageBox.Show("Not Added");
return;
}
}
else
{
if (_purchaseManager.Add(purchase))
{
if (_purchaseManager.UpdateStock(purchase))
{
MessageBox.Show("Update Added");
return;
}
else
{
MessageBox.Show("Not Update Added");
return;
}
}
else
{
MessageBox.Show("Not Added");
return;
}
}
}
private void addButton_Click(object sender, EventArgs e)
{
purchase.Date = sDateTimePicker.Text;
purchase.BillNo = billTextBox.Text;
purchase.Code = codeTextBox.Text;
//purchase.ManufacturedDate = manufacturedDateTextBox.Text;
purchase.ExpireDate = eDateTimePicker2.Value.ToString();
purchase.Remarks = remarksTextBox.Text;
if (purchase.Date == "" || purchase.BillNo == "")
{
MessageBox.Show("Please Select Supplier Field..");
return;
}
if (!CheckIfNumeric(purchase.BillNo))
{
MessageBox.Show("Please enter numeric Invoice Number.");
billTextBox.Clear();
return;
}
else if (purchase.BillNo.Length < 4)
{
MessageBox.Show("Invoice No filed is required minimum 5 digit length");
billTextBox.Clear();
return;
}
else if (_purchaseManager.IsExistBillNo(billTextBox.Text))
{
MessageBox.Show("Invoice No is already exist");
billTextBox.Clear();
return;
}
try
{
supplierCombo = supplierComboBox.SelectedValue.ToString();
if (Convert.ToInt32(supplierCombo) <= 0)
{
MessageBox.Show("Please,, Select any Supplier..");
return;
}
}
catch (Exception excp)
{
//MessageBox.Show(excp.Message);
MessageBox.Show("Please,, Select any Supplier..");
return;
}
try
{
categoryCombo = categoryComboBox.SelectedValue.ToString();
if (Convert.ToInt32(categoryCombo) <= 0)
{
MessageBox.Show("Please,, Select any Category..");
return;
}
}
catch (Exception excp)
{
//MessageBox.Show(excp.Message);
MessageBox.Show("Please,, Select any Category..");
return;
}
try
{
productCombo = productComboBox.SelectedValue.ToString();
if (Convert.ToInt32(productCombo) <= 0)
{
MessageBox.Show("Please,, Select any Product..");
return;
}
}
catch (Exception)
{
//MessageBox.Show(excp.Message);
MessageBox.Show("Please,, Select any Product..");
return;
}
if (aQuantityTextBox.Text == "" || purchase.ManufacturedDate == "" ||
purchase.ExpireDate == "" || purchase.Remarks == "" || quantityTextBox.Text == "" ||
unitPriceTextBox.Text == "" || totalPriceTextBox.Text == "" || MRPTextBox.Text == "")
{
MessageBox.Show("Please Product field is required..");
return;
}
if (!CheckIfNumeric(quantityTextBox.Text))
{
MessageBox.Show("Please enter numeric Quantity.");
codeTextBox.Clear();
return;
}
if (!CheckIfNumeric(unitPriceTextBox.Text))
{
MessageBox.Show("Please enter numeric UnitPrice.");
codeTextBox.Clear();
return;
}
//if (!CheckIfNumeric(MRPTextBox.Text))
//{
// MessageBox.Show("Please enter numeric MRP.");
// codeTextBox.Clear();
// return;
//}
purchase.SupplierId = Convert.ToInt32(supplierComboBox.SelectedValue.ToString());
purchase.CategoryId = Convert.ToInt32(categoryComboBox.SelectedValue.ToString());
purchase.ProductId = Convert.ToInt32(productComboBox.SelectedValue.ToString());
purchase.AvailableQuantity = Convert.ToDouble(aQuantityTextBox.Text);
purchase.Quantity = Convert.ToDouble(quantityTextBox.Text);
purchase.UnitPrice = Convert.ToDouble(unitPriceTextBox.Text);
purchase.TotalPrice = Convert.ToDouble(totalPriceTextBox.Text);
//purchase.PreviousUnitPrice = Convert.ToDouble(pUnitPriceTextBox.Text);
//purchase.PreviousMRP = Convert.ToDouble(pMRPTextBox.Text);
purchase.MRP = Convert.ToDouble(MRPTextBox.Text);
purchaseDetails.BillNo = billTextBox.Text;
purchaseDetails.CategoryId = Convert.ToInt32(categoryComboBox.SelectedValue.ToString());
purchaseDetails.ProductId = purchase.ProductId = Convert.ToInt32(productComboBox.SelectedValue.ToString());
purchaseDetails.Code = codeTextBox.Text;
purchaseDetails.Category = categoryComboBox.Text;
purchaseDetails.Product = productComboBox.Text;
purchaseDetails.ManufacturedDate = menufactureDateTimePicker1.Value.ToString();
purchaseDetails.ExpireDate = eDateTimePicker2.Value.ToString();
purchaseDetails.Quantity = Convert.ToDouble(quantityTextBox.Text);
purchaseDetails.UnitPrice = Convert.ToDouble(unitPriceTextBox.Text);
purchaseDetails.TotalPrice = Convert.ToDouble(totalPriceTextBox.Text);
purchaseDetails.MRP = Convert.ToDouble(MRPTextBox.Text);
purchaseDetails.Remarks = remarksTextBox.Text;
if (addButton.Text == "Update")
{
FalsePurchaseDataGridView();
TrueShowDataGridView();
if (_purchaseManager.UpdatePurchaseItem(purchaseDetails, id))
{
MessageBox.Show("Purchase Product Updated Successfully");
//Edit();
List <PurchaseDetails> purchaseViews = _purchaseManager.DisplayPurchaeItem();
showPurchaseDataGridView.DataSource = purchaseViews;
SL();
addButton.Text = "Save";
Clear();
return;
}
else
{
MessageBox.Show("Purchase Product Not Updated, Check details");
return;
}
}
//if (Convert.ToDouble(aQuantityTextBox.Text) < Convert.ToDouble(quantityTextBox.Text))
//{
// MessageBox.Show("Sorry, there is no more available quantity..");
// return;
//}
if (_purchaseManager.SavePurchaseItem(purchase))
{
FalseShowDataGridView();
TruePurchaseDataGridView();
MessageBox.Show("Successfully Added ..");
//List<PurchaseView> purchaseViews = _purchaseManager.DisplayPurchaeItem();
//purchaseDataGridView.DataSource = purchaseViews;
//SL();
//Clear();
DataRow dr = dataTable.NewRow();
dr["Product"] = productComboBox.Text;
dr["ManufacturedDate"] = menufactureDateTimePicker1.Value.ToString();
dr["ExpireDate"] = eDateTimePicker2.Value.ToString();
dr["Quantity"] = quantityTextBox.Text;
dr["UnitPrice"] = unitPriceTextBox.Text;
dr["TotalPrice"] = totalPriceTextBox.Text;
dr["MRP"] = MRPTextBox.Text;
dr["Remarks"] = remarksTextBox.Text;
dataTable.Rows.Add(dr);
purchaseDataGridView.DataSource = dataTable;
total = total + Convert.ToDouble(totalPriceTextBox.Text);
//totalLabel.Text = total.ToString();
//for (int i = 0; i < Convert.ToDouble(quantityTextBox.Text); i++)
//{
// _purchaseManager.DeletePurchaseProduct(purchase.ProductId);
//}
string productName = productComboBox.Text;
DataTable dtbl = _purchaseManager.CodeSelect(productName);
foreach (DataRow dataRow in dtbl.Rows)
{
double profit = Convert.ToDouble(MRPTextBox.Text) - Convert.ToDouble(unitPriceTextBox.Text);
stock.Code = codeTextBox.Text;
stock.Product = productComboBox.Text;
stock.Category = categoryComboBox.Text;
stock.ManufacturedDate = menufactureDateTimePicker1.Value.ToString();
stock.Quantity = Convert.ToDouble(quantityTextBox.Text);
stock.UnitPrice = Convert.ToDouble(unitPriceTextBox.Text);
stock.MRP = Convert.ToDouble(MRPTextBox.Text);
stock.Profit = profit;
if (!_purchaseManager.IsStockProductName(productComboBox.Text))
{
_purchaseManager.AddStock(stock);
}
else
{
_purchaseManager.UpdateStock(stock);
}
}
}
else
{
MessageBox.Show("No purchased,Check purchasing Details..");
}
}
