private decimal GetDiscountedPrice()
{
string price = String.IsNullOrWhiteSpace(this.txtPrice.Text) ? "0.00" : this.txtPrice.Text;
string percentage = String.IsNullOrWhiteSpace(this.txtDiscount.Text) ? "0.00" : this.txtDiscount.Text;
decimal priceValue = Convert.ToDecimal(price);
decimal percentageValue = Convert.ToDecimal(percentage);
using (CommonServiceBLL comService = new CommonServiceBLL())
{
return(comService.GetDiscountedPrice(priceValue, percentageValue));
}
}
private void getProductMasterData()
{
using (CommonServiceBLL commonServiceBLL = new CommonServiceBLL())
{
CommonDataResponse commonDataResponse = commonServiceBLL.GetMasterData();
this.SizeList = commonDataResponse.Sizes;
this.CategoryList = commonDataResponse.Categories;
this.StatusList = commonDataResponse.Status;
this.PortionList = commonDataResponse.Portions;
this.getProducts();
}
}
private void btnOk_Click(object sender, EventArgs e)
{
using (CommonServiceBLL common = new CommonServiceBLL())
{
string password = ConfigurationManager.ConnectionStrings["Passowrd"].ConnectionString;
string Newpassword = common.ComputeSha256Hash(txtPassword.Text);
if (password.Equals(Newpassword))
{
// The password is ok.
this.DialogResult = DialogResult.OK;
}
else
{
// The password is invalid.
txtPassword.Clear();
MessageBox.Show("Inivalid password.");
txtPassword.Focus();
}
}
}
private void SetDataToPriceForm(ProductPriceVM product)
{
decimal finalPrice;
using (CommonServiceBLL common = new CommonServiceBLL())
{
finalPrice = common.GetDiscountedPrice(product.Price, product.Discount);
}
ProductVM selectedProduct = this.products.Find(pro => pro.Id == product.ProductId);
if (selectedProduct != null)
{
this.txtPrice.Text = product.Price.ToString();
this.txtDiscount.Text = product.Discount.ToString();
this.lblFinalPrice.Text = finalPrice.ToString();
this.cmbSelectCategory.SelectedIndex = selectedProduct.mpt_CategoryEnum - 1;
this.cmbSelectProduct.SelectedItem = selectedProduct;
this.cmbSelectSize.DataSource = this.SizeList.Where(s => s.Data == product.mpt_SizeEnum).ToList();
this.cmbSelectSize.SelectedIndex = 0;
}
this.PriceFormFieldValidation();
}
private void AddUpdateItem_Load(object sender, EventArgs e)
{
this.productTable = new DataTable();
this.priceTable = new DataTable();
productTable.Columns.Add("Name");
productTable.Columns.Add("Code");
productTable.Columns.Add("Category");
productTable.Columns.Add("Id");
productTable.Columns.Add("CategoryEnum");
priceTable.Columns.Add("Size");
priceTable.Columns.Add("Price (Rs.)");
priceTable.Columns.Add("Discount (%)");
priceTable.Columns.Add("Discounted Price (Rs.)");
priceTable.Columns.Add("SizeEnum");
priceTable.Columns.Add("ProductId");
priceTable.Columns.Add("Id");
productGridView.DataSource = productTable;
gridViewSpecifications.DataSource = priceTable;
productGridView.Columns["Id"].Visible = false;
productGridView.Columns["CategoryEnum"].Visible = false;
gridViewSpecifications.Columns["SizeEnum"].Visible = false;
gridViewSpecifications.Columns["ProductId"].Visible = false;
gridViewSpecifications.Columns["Id"].Visible = false;
var viewButton = new DataGridViewButtonColumn();
viewButton.Name = "dataGridViewButton";
viewButton.HeaderText = "View";
viewButton.Text = "View";
viewButton.UseColumnTextForButtonValue = true;
productGridView.Columns.Add(viewButton);
var editButton = new DataGridViewButtonColumn();
editButton.Name = "dataGridViewEditButton";
editButton.HeaderText = "Edit";
editButton.Text = "Edit";
editButton.UseColumnTextForButtonValue = true;
productGridView.Columns.Add(editButton);
var deleteButton = new DataGridViewButtonColumn();
deleteButton.Name = "dataGridViewDeleteButton";
deleteButton.HeaderText = "Delete";
deleteButton.Text = "Delete";
deleteButton.UseColumnTextForButtonValue = true;
productGridView.Columns.Add(deleteButton);
var specEditButton = new DataGridViewButtonColumn();
specEditButton.Name = "specificationEditButton";
specEditButton.HeaderText = "Edit";
specEditButton.Text = "Edit";
specEditButton.UseColumnTextForButtonValue = true;
gridViewSpecifications.Columns.Add(specEditButton);
var specDeleteButton = new DataGridViewButtonColumn();
specDeleteButton.Name = "specificationDeleteButton";
specDeleteButton.HeaderText = "Delete";
specDeleteButton.Text = "Delete";
specDeleteButton.UseColumnTextForButtonValue = true;
gridViewSpecifications.Columns.Add(specDeleteButton);
productGridView.Columns[0].Width = 210;
productGridView.Columns[1].Width = 155;
productGridView.Columns[2].Width = 150;
gridViewSpecifications.Columns[0].Width = 115;
gridViewSpecifications.Columns[1].Width = 80;
gridViewSpecifications.Columns[2].Width = 80;
gridViewSpecifications.Columns[3].Width = 80;
using (CommonServiceBLL commonServiceBLL = new CommonServiceBLL())
{
CommonDataResponse commonDataResponse = commonServiceBLL.GetMasterData();
this.SizeList = commonDataResponse.Sizes;
this.CategoryList = commonDataResponse.Categories;
this.StatusList = commonDataResponse.Status;
this.PortionList = commonDataResponse.Portions;
this.getProducts(); // get products from db
// Set combobox data
cmbSelectSize.DisplayMember = cmbCategory.DisplayMember = cmbSelectCategory.DisplayMember = "Name";
cmbSelectSize.ValueMember = cmbCategory.ValueMember = cmbSelectCategory.ValueMember = "Data";
cmbSelectProduct.DisplayMember = "Name";
cmbSelectProduct.ValueMember = "Id";
cmbCategory.DataSource = this.CategoryList;
cmbSelectCategory.DataSource = this.CategoryList;
cmbSelectSize.DataSource = this.SelectedSizeList;
cmbCategory.SelectedIndex = 0;
cmbSelectCategory.SelectedIndex = 0;
cmbSelectProduct.SelectedIndex = -1;
cmbSelectSize.SelectedIndex = -1;
foreach (ProductVM product in products)
{
DataRow itemDataRow = this.productTable.NewRow();
itemDataRow[0] = product.Name;
itemDataRow[1] = product.Code;
itemDataRow[2] = product.CategoryName;
itemDataRow[3] = product.Id;
itemDataRow[4] = product.mpt_CategoryEnum;
this.productTable.Rows.Add(itemDataRow);
}
}
productGridView.RowHeadersVisible = false;
this.ProductFormFieldValidation(); // validate product from
this.PriceFormFieldValidation(); // validate price form
this.txtDiscount.Text = "0.0";
}
private void dataGridItems_CellClick(object sender, DataGridViewCellEventArgs e)
{
//if click is on new row or header row
if (e.RowIndex == productGridView.NewRowIndex || e.RowIndex < 0)
{
return;
}
//Check if click is on specific column
if (e.ColumnIndex == productGridView.Columns["dataGridViewDeleteButton"].Index)
{
DataRowView data = (DataRowView)productGridView.Rows[e.RowIndex].DataBoundItem;
ProductVM productVM = MapDataRowViewToProductVM(data);
using (ProductBLL productBLL = new ProductBLL())
{
productVM.mpt_StatusEnum = 2;
int response = productBLL.ManageProduct(productVM);
if (response != 0)
{
productGridView.Rows.Remove(productGridView.Rows[e.RowIndex]);
}
else
{
MessageBox.Show("Unable to delete the item");
}
}
}
else if (e.ColumnIndex == productGridView.Columns["dataGridViewEditButton"].Index)
{
DataRowView data = (DataRowView)productGridView.Rows[e.RowIndex].DataBoundItem;
ProductVM productVM = MapDataRowViewToProductVM(data);
this.productId = productVM.Id;
SetDataToForm(productVM);
this.btnAddUpdate.Text = "Update";
this.isProductUpdate = true;
this.updatedRow = productGridView.Rows[e.RowIndex];
}
else if (e.ColumnIndex == productGridView.Columns["dataGridViewButton"].Index)
{
using (CommonServiceBLL commonServiceBLL = new CommonServiceBLL())
{
DataRowView data = (DataRowView)productGridView.Rows[e.RowIndex].DataBoundItem;
ProductVM productVM = MapDataRowViewToProductVM(data);
productVM = this.products.Find(item => item.Id == productVM.Id);
this.priceTable.Clear();
foreach (ProductPriceVM productPrice in productVM.PriceList)
{
DataRow itemDataRow = this.priceTable.NewRow();
itemDataRow[0] = productPrice.SizeName;
itemDataRow[1] = productPrice.Price;
itemDataRow[2] = productPrice.Discount;
itemDataRow[3] = commonServiceBLL.GetDiscountedPrice(productPrice.Price, productPrice.Discount);
itemDataRow[4] = productPrice.mpt_SizeEnum;
itemDataRow[5] = productPrice.ProductId;
itemDataRow[6] = productPrice.Id;
this.priceTable.Rows.Add(itemDataRow);
}
this.lblShowSelectedProduct.Text = productVM.Name;
}
}
}
