Exemple #1
0
        private void AssignData(DEProduct product)
        {
            product.Product_Id          = Convert.ToInt32(txt_Code.Tag);
            product.Product_Code        = txt_Code.Text.Trim();
            product.Product_Description = txt_Description.Text;
            product.Unit_Weight         = Convert.ToDecimal(txt_Weight.Text);
            product.NoOfUnitsPerCarton  = Convert.ToInt32(txt_NoOfUnits.Text);
            product.Unit_Price          = Convert.ToDecimal(txt_UnitPrice.Text);
            product.Carton_Price        = Convert.ToDecimal(txt_CartonPrice.Text);
            product.Unit_Price2         = Convert.ToDecimal(txt_UnitPrice2.Text);
            product.Carton_Price2       = Convert.ToDecimal(txt_CartonPrice2.Text);
            product.MinLVL     = Convert.ToInt32(txt_MinLvl.Text);
            product.ReorderCtn = Convert.ToInt32(txt_ReorderCtn.Text);

            try
            {
                product.Catagory_Id = Convert.ToInt32(cbx_Catagory.SelectedItem.Col3);
            }
            catch (Exception ex)
            {
                product.Catagory_Id = 0;
            }

            try
            {
                product.SrNo = Convert.ToInt32(txt_SrNo.Text);
            }
            catch (Exception ex)
            {
                product.SrNo = 0;
            }
        }
Exemple #2
0
        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;
            }
        }
        public Boolean LoadProductRow(DEProduct product)
        {
            DALProduct obj_DALProduct = new DALProduct();

            Boolean bool_HasRows = obj_DALProduct.LoadProductRow(product);

            obj_DALProduct = null;

            return(bool_HasRows);
        }
        public int DeleteData(DEProduct product)
        {
            DALProduct obj_DALProduct = new DALProduct();

            int int_Result = obj_DALProduct.DeleteData(product);

            obj_DALProduct = null;

            return(int_Result);
        }
        public DataTable LoadProductTableForAllDataByProductCode(DEProduct product)
        {
            DALProduct obj_DALProduct = new DALProduct();

            DataTable dt_Product = obj_DALProduct.LoadProductTableForAllDataByProductCode(product);

            obj_DALProduct = null;

            return(dt_Product);
        }
        public Boolean LoadProductRow(DEProduct product)
        {
            Boolean bool_HasRows = false;

            SqlCommand sqlCmd = new SqlCommand();

            sqlCmd.CommandText = "SELECT Pro.Product_Id,Pro.Product_Code,Pro.Product_Description,Pro.Unit_Weight,Pro.NoOfUnitsPerCarton,Pro.Unit_Price,Pro.Carton_Price,Pro.CartonPrice_Buying,Pro.Catagory_Id,Cat.Catagory_Description,Pro.Active,Pro.ModifiedBy,Pro.ModifiedDate, Pro.Unit_Price2, Pro.Carton_Price2, Pro.MinLVL, Pro.ReorderCtn, Pro.SrNo FROM tbl_Product Pro LEFT JOIN tbl_Catagory Cat on Pro.Catagory_Id = Cat.Catagory_Id where Pro.Active = 'true' And Pro.Product_Id = @Product_Id";

            sqlCmd = DeclareSqlCmdParameter(sqlCmd, product);

            SqlConnection con = new SqlConnection(SqlConjunction.DataConn);

            SqlDataReader sqlDataReader = SqlConjunction.GetSQLExecuteReader(sqlCmd, con);

            while (sqlDataReader.Read())
            {
                product.Product_Id           = sqlDataReader.GetInt32(0);
                product.Product_Code         = sqlDataReader.GetString(1);
                product.Product_Description  = sqlDataReader.GetString(2);
                product.Unit_Weight          = sqlDataReader.GetDecimal(3);
                product.NoOfUnitsPerCarton   = sqlDataReader.GetInt32(4);
                product.Unit_Price           = sqlDataReader.GetDecimal(5);
                product.Carton_Price         = sqlDataReader.GetDecimal(6);
                product.CartonPrice_Buying   = sqlDataReader.GetDecimal(7);
                product.Catagory_Id          = sqlDataReader.GetInt32(8);
                product.Catagory_Description = sqlDataReader.GetString(9);
                product.Active        = sqlDataReader.GetBoolean(10);
                product.ModifiedBy    = sqlDataReader.GetString(11);
                product.ModifiedDate  = sqlDataReader.GetDateTime(12);
                product.Unit_Price2   = sqlDataReader.GetDecimal(13);
                product.Carton_Price2 = sqlDataReader.GetDecimal(14);
                product.MinLVL        = sqlDataReader.GetInt32(15);
                product.ReorderCtn    = sqlDataReader.GetInt32(16);
                product.SrNo          = sqlDataReader.GetInt32(17);
            }

            if (sqlDataReader.HasRows)
            {
                bool_HasRows = true;
            }
            else
            {
                bool_HasRows = false;
            }
            con.Close();

            sqlCmd = null;

            return(bool_HasRows);
        }
Exemple #7
0
 private void DisplayData(DEProduct product)
 {
     txt_Code.Tag               = product.Product_Id;
     txt_Code.Text              = product.Product_Code;
     txt_Description.Text       = product.Product_Description;
     txt_Weight.Text            = Convert.ToString(product.Unit_Weight);
     txt_NoOfUnits.Text         = Convert.ToString(product.NoOfUnitsPerCarton);
     txt_UnitPrice.Text         = Convert.ToString(product.Unit_Price);
     txt_CartonPrice.Text       = Convert.ToString(product.Carton_Price);
     cbx_Catagory.SelectedValue = product.Catagory_Id.ToString();
     txt_UnitPrice2.Text        = Convert.ToString(product.Unit_Price2);
     txt_CartonPrice2.Text      = Convert.ToString(product.Carton_Price2);
     txt_MinLvl.Text            = Convert.ToString(product.MinLVL);
     txt_ReorderCtn.Text        = Convert.ToString(product.ReorderCtn);
     txt_SrNo.Text              = Convert.ToString(product.SrNo);
 }
        public DataTable LoadProductTableForAllDataByProductCode(DEProduct product)
        {
            DataTable dt_Product;

            SqlCommand sqlCmd = new SqlCommand();

            sqlCmd.CommandText = "SELECT 0 As 'No',Pro.Product_Id,Pro.Product_Code,Pro.Product_Description,Pro.Unit_Weight,Pro.NoOfUnitsPerCarton,Pro.Unit_Price,Pro.Carton_Price,Pro.CartonPrice_Buying,Pro.Catagory_Id,Cat.Catagory_Description,Pro.Active,Pro.ModifiedBy,Pro.ModifiedDate, Pro.Unit_Price2, Pro.Carton_Price2, Pro.MinLVL, Pro.ReorderCtn, Pro.SrNo FROM tbl_Product Pro LEFT JOIN tbl_Catagory Cat on Pro.Catagory_Id = Cat.Catagory_Id where Pro.Active = 'true' And Pro.Product_Code  LIKE '%' + @Product_Code+ '%' order by Pro.SrNo";

            sqlCmd = DeclareSqlCmdParameter(sqlCmd, product);

            dt_Product = SqlConjunction.GetSQLDataTable(sqlCmd);

            sqlCmd = null;

            return(dt_Product);
        }
        public int DeleteData(DEProduct product)
        {
            int int_Result;

            SqlCommand sqlCmd = new SqlCommand();

            sqlCmd.CommandText = "DELETE FROM tbl_Product  WHERE Product_Id = @Product_Id";

            DeclareSqlCmdParameter(sqlCmd, product);

            int_Result = SqlConjunction.GetSQLVoid(sqlCmd);

            sqlCmd = null;

            return(int_Result);
        }
        public int UpdateData(DEProduct product)
        {
            int int_Result;

            SqlCommand sqlCmd = new SqlCommand();

            sqlCmd.CommandText = "UPDATE tbl_Product SET Product_Id= @Product_Id, Product_Code=@Product_Code, Product_Description = @Product_Description, Unit_Weight = @Unit_Weight, NoOfUnitsPerCarton = @NoOfUnitsPerCarton,Unit_Price = @Unit_Price, Carton_Price = @Carton_Price, CartonPrice_Buying = @CartonPrice_Buying, Catagory_Id = @Catagory_Id , Active = @Active ,ModifiedBy = @ModifiedBy ,ModifiedDate = @ModifiedDate, Unit_Price2 = @Unit_Price2, Carton_Price2 = @Carton_Price2, MinLVL = @MinLVL, ReorderCtn = @ReorderCtn, SrNo = @SrNo WHERE Product_Id = @Product_Id";

            DeclareSqlCmdParameter(sqlCmd, product);

            int_Result = SqlConjunction.GetSQLVoid(sqlCmd);

            sqlCmd = null;

            return(int_Result);
        }
        public int InsertData(DEProduct product)
        {
            int int_Result;

            SqlCommand sqlCmd = new SqlCommand();

            sqlCmd.CommandText = "SELECT @Product_Id = ISNULL(MAX(Product_Id),0)+1 FROM tbl_Product INSERT  tbl_Product  VALUES(@Product_Id,@Product_Code,@Product_Description,@Unit_Weight,@NoOfUnitsPerCarton,@Unit_Price,@Carton_Price,@CartonPrice_Buying,@Catagory_Id,@Active,@ModifiedBy,@ModifiedDate,@Unit_Price2,@Carton_Price2,@MinLVL,@ReorderCtn, @SrNo)";

            DeclareSqlCmdParameter(sqlCmd, product);

            int_Result = SqlConjunction.GetSQLVoid(sqlCmd);

            sqlCmd = null;

            return(int_Result);
        }
        public int InsertData(DEProduct product)
        {
            DALProduct obj_DALProduct = new DALProduct();

            int int_Result;

            if (product.Product_Id == 0)
            {
                int_Result = obj_DALProduct.InsertData(product);
            }
            else
            {
                int_Result = obj_DALProduct.UpdateData(product);
            }

            obj_DALProduct = null;

            return(int_Result);
        }
Exemple #13
0
        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 SqlCommand DeclareSqlCmdParameter(SqlCommand SqlCmd, DEProduct product)
        {
            SqlCmd.Parameters.AddWithValue("@Product_Id", product.Product_Id);
            SqlCmd.Parameters.AddWithValue("@Product_Code", product.Product_Code);
            SqlCmd.Parameters.AddWithValue("@Product_Description", product.Product_Description);
            SqlCmd.Parameters.AddWithValue("@Unit_Weight", product.Unit_Weight);
            SqlCmd.Parameters.AddWithValue("@NoOfUnitsPerCarton", product.NoOfUnitsPerCarton);
            SqlCmd.Parameters.AddWithValue("@Unit_Price", product.Unit_Price);
            SqlCmd.Parameters.AddWithValue("@Carton_Price", product.Carton_Price);
            SqlCmd.Parameters.AddWithValue("@CartonPrice_Buying", product.CartonPrice_Buying);
            SqlCmd.Parameters.AddWithValue("@Catagory_Id", product.Catagory_Id);
            SqlCmd.Parameters.AddWithValue("@Active", product.Active);
            SqlCmd.Parameters.AddWithValue("@ModifiedBy", product.ModifiedBy);
            SqlCmd.Parameters.AddWithValue("@ModifiedDate", product.ModifiedDate);
            SqlCmd.Parameters.AddWithValue("@Unit_Price2", product.Unit_Price2);
            SqlCmd.Parameters.AddWithValue("@Carton_Price2", product.Carton_Price2);
            SqlCmd.Parameters.AddWithValue("@MinLVL", product.MinLVL);
            SqlCmd.Parameters.AddWithValue("@ReorderCtn", product.ReorderCtn);
            SqlCmd.Parameters.AddWithValue("@SrNo", product.SrNo);

            return(SqlCmd);
        }
Exemple #16
0
        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 bindReport(DEProduct product, DataTable dt_Sale, DataTable dt_Return)
        {
            String str_Product_Code;
            String str_Product_Description;

            try
            {
                str_Product_Code = Convert.ToString(cbx_Product.SelectedItem.Col1);
            }
            catch (Exception ex)
            {
                str_Product_Code = string.Empty;
            }

            try
            {
                str_Product_Description = Convert.ToString(cbx_Product.SelectedItem.Col2);
            }
            catch (Exception ex)
            {
                str_Product_Description = string.Empty;
            }

            rptv_ProductInvoiceReport.Clear();
            rptv_ProductInvoiceReport.Reset();

            rptv_ProductInvoiceReport.ProcessingMode = ProcessingMode.Local;

            LocalReport localReport = rptv_ProductInvoiceReport.LocalReport;

            localReport.ReportEmbeddedResource = "StockAndSale.WinUI.Reports.Classes.Rpt_ProductInvoiceReport.rdlc";

            ReportDataSource ds_InvoiceSale = new ReportDataSource();

            ds_InvoiceSale.Name  = "DS_InvoiceReport_dt_ProductSale";
            ds_InvoiceSale.Value = dt_Sale;

            ReportDataSource ds_InvoiceReturn = new ReportDataSource();

            ds_InvoiceReturn.Name  = "DS_InvoiceReport_dt_ProductReturn";
            ds_InvoiceReturn.Value = dt_Return;

            ReportParameter parDateFrom = new ReportParameter();

            parDateFrom.Name = "parDateFrom";

            ReportParameter parDateTo = new ReportParameter();

            parDateTo.Name = "parDateTo";

            ReportParameter parShowSale = new ReportParameter();

            parShowSale.Name = "parShowSale";

            ReportParameter parShowReturn = new ReportParameter();

            parShowReturn.Name = "parShowReturn";

            ReportParameter parProductCode = new ReportParameter();

            parProductCode.Name = "parProductCode";

            ReportParameter parProductDescription = new ReportParameter();

            parProductDescription.Name = "parProductDescription";

            ReportParameter parNoOfUnitsPerCarton = new ReportParameter();

            parNoOfUnitsPerCarton.Name = "parNoOfUnitsPerCarton";


            parDateFrom.Values.Add(dtp_InvoiceDateFrom.Value.Date.ToString());
            parDateTo.Values.Add(dtp_InvoiceDateTo.Value.Date.ToString());

            if (rdo_All.Checked)
            {
                parShowSale.Values.Add("true");
                parShowReturn.Values.Add("true");
            }
            else if (rdo_Sale.Checked)
            {
                parShowSale.Values.Add("true");
                parShowReturn.Values.Add("false");
            }
            else
            {
                parShowSale.Values.Add("false");
                parShowReturn.Values.Add("true");
            }

            parProductCode.Values.Add(str_Product_Code);
            parProductDescription.Values.Add(product.Product_Description);
            parNoOfUnitsPerCarton.Values.Add(product.NoOfUnitsPerCarton.ToString());

            rptv_ProductInvoiceReport.LocalReport.SetParameters(new ReportParameter[] { parDateFrom, parDateTo, parShowSale, parShowReturn, parProductCode, parProductDescription, parNoOfUnitsPerCarton });

            localReport.DataSources.Add(ds_InvoiceSale);
            localReport.DataSources.Add(ds_InvoiceReturn);

            rptv_ProductInvoiceReport.RefreshReport();
        }
        public int InsertData(DECustomerReturn customerReturn)
        {
            int int_Result = 0;

            DALProductInStore obj_DALProductInStore = new DALProductInStore();
            DALProduct        obj_DALProduct        = new DALProduct();

            DEProductInStore productInStore = new DEProductInStore();

            productInStore.Product_Id = customerReturn.Product_Id;

            DEProduct product = new DEProduct();

            product.Product_Id = customerReturn.Product_Id;
            obj_DALProduct.LoadProductRow(product);

            SqlConnection SqlCon = new SqlConnection(SqlConjunction.DataConn);

            try
            {
                if (SqlCon.State != ConnectionState.Open)
                {
                    SqlCon.Open();
                }
            }

            catch (SqlException ex)
            {
                Console.WriteLine(ex);
            }

            SqlTransaction tn = SqlCon.BeginTransaction();

            {
                try
                {
                    this.InsertData(customerReturn, SqlCon, tn);

                    int int_NoOfUnitsSale = 0;

                    if (customerReturn.isCarton == true)
                    {
                        int_NoOfUnitsSale = (customerReturn.Qty * product.NoOfUnitsPerCarton);
                    }
                    else
                    {
                        int_NoOfUnitsSale = customerReturn.Qty;
                    }

                    DataTable dt_ProductInStoreTemp = obj_DALProductInStore.LoadProductInStoreTableByProductId(productInStore, SqlCon, tn);

                    if (dt_ProductInStoreTemp.Rows.Count > 0)
                    {
                        int int_NoOfUnitsInStore = Convert.ToInt32(dt_ProductInStoreTemp.Rows[0][0].ToString());

                        productInStore.NoOfUnits = (int_NoOfUnitsInStore + int_NoOfUnitsSale);

                        obj_DALProductInStore.UpdateData(productInStore, SqlCon, tn);
                    }
                    else
                    {
                        productInStore.NoOfUnits = (int_NoOfUnitsSale * (-1));

                        obj_DALProductInStore.InsertData(productInStore, SqlCon, tn);
                    }


                    tn.Commit();
                    int_Result = 1;
                }
                catch (Exception ex)
                {
                    tn.Rollback();
                    int_Result = 0;
                    throw (ex);
                }
                finally
                {
                    obj_DALProductInStore = null;

                    SqlCon.Close();
                    tn.Dispose();
                }

                return(int_Result);
            }
        }
Exemple #19
0
        public int CancelDetailInvoice(DEInvoiceDetail invoiceDetail)
        {
            int int_Result = 0;

            DALProductInStore obj_DALProductInStore = new DALProductInStore();
            DALProduct        obj_DALProduct        = new DALProduct();

            DEProductInStore productInStore = new DEProductInStore();

            productInStore.Product_Id = invoiceDetail.Product_Id;

            DEProduct product = new DEProduct();

            product.Product_Id = invoiceDetail.Product_Id;
            obj_DALProduct.LoadProductRow(product);

            SqlConnection SqlCon = new SqlConnection(SqlConjunction.DataConn);

            try
            {
                if (SqlCon.State != ConnectionState.Open)
                {
                    SqlCon.Open();
                }
            }

            catch (SqlException ex)
            {
                Console.WriteLine(ex);
            }

            SqlTransaction tn = SqlCon.BeginTransaction();

            {
                try
                {
                    int int_NoOfUnitsSale = 0;

                    if (invoiceDetail.isCarton)
                    {
                        int_NoOfUnitsSale = invoiceDetail.Qty * product.NoOfUnitsPerCarton;
                    }
                    else
                    {
                        int_NoOfUnitsSale = invoiceDetail.Qty;
                    }

                    DataTable dt_ProductInStoreTemp = obj_DALProductInStore.LoadProductInStoreTableByProductId(productInStore, SqlCon, tn);

                    if (dt_ProductInStoreTemp.Rows.Count > 0)
                    {
                        int int_NoOfUnitsInStore = Convert.ToInt32(dt_ProductInStoreTemp.Rows[0][0].ToString());

                        productInStore.NoOfUnits = (int_NoOfUnitsInStore + int_NoOfUnitsSale);

                        obj_DALProductInStore.UpdateData(productInStore, SqlCon, tn);
                    }
                    else
                    {
                    }

                    this.updateActiveData(invoiceDetail, SqlCon, tn);

                    tn.Commit();
                    int_Result = 1;
                }
                catch (Exception ex)
                {
                    tn.Rollback();
                    int_Result = 0;
                    throw (ex);
                }
                finally
                {
                    obj_DALProductInStore = null;

                    SqlCon.Close();
                    tn.Dispose();
                }

                return(int_Result);
            }
        }
        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;
                }
            }
        }