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;
}
}
}
