/// <summary>
 /// Function to insert values to BarcodeSettings table
 /// </summary>
 /// <param name="barcodesettingsinfo"></param>
 public void BarcodeSettingsAdd(BarcodeSettingsInfo barcodesettingsinfo)
 {
     try
     {
         if (sqlcon.State == ConnectionState.Closed)
         {
             sqlcon.Open();
         }
         SqlCommand sccmd = new SqlCommand("BarcodeSettingsAddorEdit", sqlcon);
         sccmd.CommandType = CommandType.StoredProcedure;
         SqlParameter sprmparam = new SqlParameter();
         sprmparam = sccmd.Parameters.Add("@showProductCode", SqlDbType.Bit);
         sprmparam.Value = barcodesettingsinfo.ShowProductCode;
         sprmparam = sccmd.Parameters.Add("@showCompanyName", SqlDbType.Bit);
         sprmparam.Value = barcodesettingsinfo.ShowCompanyName;
         sprmparam = sccmd.Parameters.Add("@companyName", SqlDbType.VarChar);
         sprmparam.Value = barcodesettingsinfo.CompanyName;
         sprmparam = sccmd.Parameters.Add("@showPurchaseRate", SqlDbType.Bit);
         sprmparam.Value = barcodesettingsinfo.ShowPurchaseRate;
         sprmparam = sccmd.Parameters.Add("@showMRP", SqlDbType.Bit);
         sprmparam.Value = barcodesettingsinfo.ShowMRP;
         sprmparam = sccmd.Parameters.Add("@point", SqlDbType.VarChar);
         sprmparam.Value = barcodesettingsinfo.Point;
         sprmparam = sccmd.Parameters.Add("@zero", SqlDbType.VarChar);
         sprmparam.Value = barcodesettingsinfo.Zero;
         sprmparam = sccmd.Parameters.Add("@one", SqlDbType.VarChar);
         sprmparam.Value = barcodesettingsinfo.One;
         sprmparam = sccmd.Parameters.Add("@two", SqlDbType.VarChar);
         sprmparam.Value = barcodesettingsinfo.Two;
         sprmparam = sccmd.Parameters.Add("@three", SqlDbType.VarChar);
         sprmparam.Value = barcodesettingsinfo.Three;
         sprmparam = sccmd.Parameters.Add("@four", SqlDbType.VarChar);
         sprmparam.Value = barcodesettingsinfo.Four;
         sprmparam = sccmd.Parameters.Add("@five", SqlDbType.VarChar);
         sprmparam.Value = barcodesettingsinfo.Five;
         sprmparam = sccmd.Parameters.Add("@six", SqlDbType.VarChar);
         sprmparam.Value = barcodesettingsinfo.Six;
         sprmparam = sccmd.Parameters.Add("@seven", SqlDbType.VarChar);
         sprmparam.Value = barcodesettingsinfo.Seven;
         sprmparam = sccmd.Parameters.Add("@eight", SqlDbType.VarChar);
         sprmparam.Value = barcodesettingsinfo.Eight;
         sprmparam = sccmd.Parameters.Add("@nine", SqlDbType.VarChar);
         sprmparam.Value = barcodesettingsinfo.Nine;
         sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar);
         sprmparam.Value = barcodesettingsinfo.Extra1;
         sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar);
         sprmparam.Value = barcodesettingsinfo.Extra2;
         sccmd.ExecuteNonQuery();
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.ToString());
     }
     finally
     {
         sqlcon.Close();
     }
 }
        public void BarcodeSettingsAdd(BarcodeSettingsInfo barcodesettingsinfo)
        {
            try
            {
                SpBarcodeSettings.BarcodeSettingsAdd(barcodesettingsinfo);

            }
            catch (Exception ex)
            {
                MessageBox.Show("BCP3:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
        }
        public BarcodeSettingsInfo BarcodeSettingsViewForBarCodePrinting()
        {
            BarcodeSettingsInfo barcodesettingsinfo = new BarcodeSettingsInfo();
               try
               {
               barcodesettingsinfo = SpBarcodeSettings.BarcodeSettingsViewForBarCodePrinting();

               }
               catch (Exception ex)
               {
               MessageBox.Show("BCP1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
               }
               return barcodesettingsinfo;
        }
 /// <summary>
 /// Function to view all values for Barcode Printing
 /// </summary>
 /// <returns></returns>
 public BarcodeSettingsInfo BarcodeSettingsViewForBarCodePrinting()
 {
     BarcodeSettingsInfo barcodesettingsinfo = new BarcodeSettingsInfo();
     SqlDataReader sdrreader = null;
     try
     {
         if (sqlcon.State == ConnectionState.Closed)
         {
             sqlcon.Open();
         }
         SqlCommand sccmd = new SqlCommand("BarcodeSettingsViewForBarcodePrinting", sqlcon);
         sccmd.CommandType = CommandType.StoredProcedure;
         sdrreader = sccmd.ExecuteReader();
         while (sdrreader.Read())
         {
             barcodesettingsinfo.BarcodeSettingsId = decimal.Parse(sdrreader[0].ToString());
             barcodesettingsinfo.ShowProductCode = bool.Parse(sdrreader[2].ToString());
             barcodesettingsinfo.ShowCompanyName = bool.Parse(sdrreader[1].ToString());
             barcodesettingsinfo.CompanyName = sdrreader[3].ToString();
             barcodesettingsinfo.ShowPurchaseRate = bool.Parse(sdrreader[4].ToString());
             barcodesettingsinfo.ShowMRP = bool.Parse(sdrreader[5].ToString());
             barcodesettingsinfo.Point = sdrreader[6].ToString();
             barcodesettingsinfo.Zero = sdrreader[7].ToString();
             barcodesettingsinfo.One = sdrreader[8].ToString();
             barcodesettingsinfo.Two = sdrreader[9].ToString();
             barcodesettingsinfo.Three = sdrreader[10].ToString();
             barcodesettingsinfo.Four = sdrreader[11].ToString();
             barcodesettingsinfo.Five = sdrreader[12].ToString();
             barcodesettingsinfo.Six = sdrreader[13].ToString();
             barcodesettingsinfo.Seven = sdrreader[14].ToString();
             barcodesettingsinfo.Eight = sdrreader[15].ToString();
             barcodesettingsinfo.Nine = sdrreader[16].ToString();
             barcodesettingsinfo.Extra1 = sdrreader[17].ToString();
             barcodesettingsinfo.Extra2 = sdrreader[18].ToString();
         }
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.ToString());
     }
     finally
     {
         sdrreader.Close();
         sqlcon.Close();
     }
     return barcodesettingsinfo;
 }