private void save() { DEProduct product = new DEProduct(); AssignData(product); BLLProduct obj_BLLProduct = new BLLProduct(); try { int int_Result = obj_BLLProduct.InsertData(product); if (int_Result > 0) { MessageBox.Show(UIConstantMessage.Const_strSaveSuccessfully); BindDataGridView(); clearScreen(); } } catch (Exception ex) { throw ex; } finally { product = null; obj_BLLProduct = null; } }
private void bindProductCombo() { BLLProduct obj_BLLProduct = new BLLProduct(); DataTable dt_Product = obj_BLLProduct.LoadProductTableForAllData(); cbx_Product.Items.Clear(); cbx_Product.LoadingType = MTGCComboBox.CaricamentoCombo.DataTable; cbx_Product.SourceDataString = new string[] { "Product_Code", "Product_Description", "Product_Id", "Product_Id" }; cbx_Product.ColumnNum = 3; cbx_Product.ColumnWidth = "150;150;0,0"; cbx_Product.SourceDataTable = dt_Product; cbx_Product.Text = string.Empty; }
private void dgv_Product_DoubleClick(object sender, EventArgs e) { DEProduct product = new DEProduct(); product.Product_Id = Convert.ToInt32(dgv_Product.CurrentRow.Cells[1].Value); BLLProduct obj_BLLProduct = new BLLProduct(); bool bool_Result = obj_BLLProduct.LoadProductRow(product); if (bool_Result == true) { DisplayData(product); } else { MessageBox.Show("Record is not found."); } product = null; obj_BLLProduct = null; }
private void search() { BLLInvoiceDetail obj_BLLInvoiceDetail = new BLLInvoiceDetail(); BLLInvoiceReturnDetail obj_BLLInvoiceReturnDetail = new BLLInvoiceReturnDetail(); BLLProduct obj_BLLProduct = new BLLProduct(); DEInvoiceDetail invDetail = new DEInvoiceDetail(); DEInvoiceReturnDetail invRDetail = new DEInvoiceReturnDetail(); DEProduct product = new DEProduct(); DateTime dateTime_From = Convert.ToDateTime(dtp_InvoiceDateFrom.Value); DateTime dateTime_To = Convert.ToDateTime(dtp_InvoiceDateTo.Value.Date.AddHours(23.9)); try { invDetail.Product_Id = Convert.ToInt32(cbx_Product.SelectedItem.Col3); invRDetail.Product_Id = Convert.ToInt32(cbx_Product.SelectedItem.Col3); product.Product_Id = Convert.ToInt32(cbx_Product.SelectedItem.Col3); } catch (Exception ex) { invDetail.Product_Id = 0; invRDetail.Product_Id = 0; product.Product_Id = 0; } DataTable dt_Sale = new DataTable(); DataTable dt_Return = new DataTable(); dt_Sale = obj_BLLInvoiceDetail.LoadInvoiceDetailTableForAllDataByInvoiceDate(invDetail, dateTime_From, dateTime_To); dt_Return = obj_BLLInvoiceReturnDetail.LoadInvoiceReturnDetailTableForAllDataByInvoiceDate(invRDetail, dateTime_From, dateTime_To); obj_BLLProduct.LoadProductRow(product); bindReport(product, dt_Sale, dt_Return); }
private void BindDataGridView() { DEProduct product = new DEProduct(); BLLProduct obj_BLLProduct = new BLLProduct(); DataTable dt_Product; if (txt_FilteredCode.Text.Trim().Length <= 0) { dt_Product = obj_BLLProduct.LoadProductTableForAllData(); } else { product.Product_Code = txt_FilteredCode.Text; dt_Product = obj_BLLProduct.LoadProductTableForAllDataByProductCode(product); } dgv_Product.DataSource = dt_Product; NumberingTableForDataGridView(dt_Product); FormatDataGridView(); }
private void rdo_isCarton_CheckedChanged(object sender, EventArgs e) { if (cbx_Product.Text.Trim().Length == 0 || cbx_Product.SelectedValue == null) { //MessageBox.Show("Invalid Product Code"); cbx_Product.Text = string.Empty; txt_ProductDescription.Text = string.Empty; txt_Rate.Text = string.Empty; cbx_Product.Focus(); } else { //txt_ProductDescription.Text = cbx_Product.SelectedItem.Col2; DEProduct product = new DEProduct(); product.Product_Id = Convert.ToInt32(cbx_Product.SelectedItem.Col3); BLLProduct obj_BLLProduct = new BLLProduct(); bool bool_Result = obj_BLLProduct.LoadProductRow(product); if (bool_Result == true) { if (rdo_Price1.Checked == true) { if (rdo_isCarton.Checked == true) { txt_Rate.Text = product.Carton_Price.ToString(); } else if (rdo_isUnit.Checked == true) { txt_Rate.Text = product.Unit_Price.ToString(); } else if (rdo_CartonPricePerUnits.Checked == true) { if (product.Carton_Price == 0) { txt_Rate.Text = "0.00"; } else { txt_Rate.Text = (product.Carton_Price / product.NoOfUnitsPerCarton).ToString("##.##"); } } } else { if (rdo_isCarton.Checked == true) { txt_Rate.Text = product.Carton_Price2.ToString(); } else if (rdo_isUnit.Checked == true) { txt_Rate.Text = product.Unit_Price2.ToString(); } else if (rdo_CartonPricePerUnits.Checked == true) { if (product.Carton_Price2 == 0) { txt_Rate.Text = "0.00"; } else { txt_Rate.Text = (product.Carton_Price2 / product.NoOfUnitsPerCarton).ToString("##.##"); } } } txt_Quantity.Focus(); } else { //MessageBox.Show("Invalid Product Code"); //cbx_Product.Text = string.Empty; //txt_ProductDescription.Text = string.Empty; } obj_BLLProduct = null; } }
private void cbx_Product_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { if (cbx_Product.Text.Trim().Length == 0 || cbx_Product.SelectedValue == null) { cbx_Product.Text = string.Empty; txt_ProductDescription.Text = string.Empty; txt_Rate.Text = string.Empty; cbx_Product.Focus(); } else { txt_ProductDescription.Text = cbx_Product.SelectedItem.Col2; DEProduct product = new DEProduct(); product.Product_Id = Convert.ToInt32(cbx_Product.SelectedItem.Col3); BLLProduct obj_BLLProduct = new BLLProduct(); bool bool_Result = obj_BLLProduct.LoadProductRow(product); if (bool_Result == true) { if (rdo_Price1.Checked == true) { if (rdo_isCarton.Checked == true) { txt_Rate.Text = product.Carton_Price.ToString(); } else if (rdo_isUnit.Checked == true) { txt_Rate.Text = product.Unit_Price.ToString(); } else if (rdo_CartonPricePerUnits.Checked == true) { txt_Rate.Text = (product.Carton_Price / product.NoOfUnitsPerCarton).ToString("##.##"); } } else { if (rdo_isCarton.Checked == true) { txt_Rate.Text = product.Carton_Price2.ToString(); } else if (rdo_isUnit.Checked == true) { txt_Rate.Text = product.Unit_Price2.ToString(); } else if (rdo_CartonPricePerUnits.Checked == true) { txt_Rate.Text = (product.Carton_Price2 / product.NoOfUnitsPerCarton).ToString("##.##"); } } } else { cbx_Product.Text = string.Empty; txt_ProductDescription.Text = string.Empty; cbx_Product.Focus(); } obj_BLLProduct = null; } } }