Exemplo n.º 1
0
        public void BatchAddParticularFields(BatchInfo batchinfo)
        {
            try
            {

                SPBatch.BatchAddParticularFields(batchinfo);
            }
            catch (Exception ex)
            {

                MessageBox.Show("BBll3:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
        }
Exemplo n.º 2
0
        public decimal BatchAddReturnIdentity(BatchInfo batchinfo)
        {
            decimal decReturnValue = 0;
            try
            {
                decReturnValue=SPBatch.BatchAddReturnIdentity(batchinfo);
            }
            catch (Exception ex)
            {

                MessageBox.Show("BBll15:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            return decReturnValue;
        }
Exemplo n.º 3
0
        public decimal BatchAddAndDelete(BatchInfo batchinfo, decimal decProductIdForEdit)
        {
            decimal decReturnValue = 0;
            try
            {
                decReturnValue=SPBatch.BatchAddAndDelete(batchinfo, decProductIdForEdit);
            }
            catch (Exception ex)
            {

                MessageBox.Show("BBll29:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            return decReturnValue;
        }
Exemplo n.º 4
0
        public int BatchAddWithBarCode(BatchInfo batchinfo)
        {
            int inReturnValue = 0;
               try
               {
               inReturnValue=SPBatch.BatchAddWithBarCode(batchinfo);
               }
               catch (Exception ex)
               {

               MessageBox.Show("BBll18:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
               }
               return inReturnValue;
        }
Exemplo n.º 5
0
        public bool BatchEditForProductEdit(BatchInfo batchinfo)
        {
            bool isResult = false;
               try
               {

              isResult= SPBatch.BatchEditForProductEdit(batchinfo);
               }
               catch (Exception ex)
               {

               MessageBox.Show("BBll21:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
               }
               return isResult;
        }
Exemplo n.º 6
0
        public BatchInfo BatchView(decimal batchId)
        {
            BatchInfo batchinfo = new BatchInfo();
            try
            {
                batchinfo=SPBatch.BatchView(batchId);
            }
            catch (Exception ex)
            {

                MessageBox.Show("BBll7:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            return batchinfo;
        }
Exemplo n.º 7
0
        public BatchInfo BatchAndProductViewByBarcode(string strBarcode)
        {
            BatchInfo batchinfo = new BatchInfo();
            try
            {
                batchinfo=SPBatch.BatchAndProductViewByBarcode(strBarcode);
            }
            catch (Exception ex)
            {

                MessageBox.Show("BBll16:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            return batchinfo;
        }
Exemplo n.º 8
0
        public void BatchEdit(BatchInfo batchinfo)
        {
            try
            {

                SPBatch.BatchEdit(batchinfo);
            }
            catch (Exception ex)
            {

                MessageBox.Show("BBll4:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
        }
Exemplo n.º 9
0
 /// <summary>
 /// Function to get particular values from Batch Table based on the parameter
 /// </summary>
 /// <param name="batchId"></param>
 /// <returns></returns>
 public BatchInfo BatchView(decimal batchId)
 {
     BatchInfo batchinfo = new BatchInfo();
     SqlDataReader sdrreader = null;
     try
     {
         if (sqlcon.State == ConnectionState.Closed)
         {
             sqlcon.Open();
         }
         SqlCommand sccmd = new SqlCommand("BatchView", sqlcon);
         sccmd.CommandType = CommandType.StoredProcedure;
         SqlParameter sprmparam = new SqlParameter();
         sprmparam = sccmd.Parameters.Add("@batchId", SqlDbType.Decimal);
         sprmparam.Value = batchId;
         sdrreader = sccmd.ExecuteReader();
         while (sdrreader.Read())
         {
             batchinfo.BatchId = decimal.Parse(sdrreader["BatchId"].ToString());
             batchinfo.BatchNo = sdrreader["BatchNo"].ToString();
             batchinfo.ProductId = decimal.Parse(sdrreader["ProductId"].ToString());
             batchinfo.ManufacturingDate = DateTime.Parse(sdrreader["ManufacturingDate"].ToString());
             batchinfo.ExpiryDate = DateTime.Parse(sdrreader["ExpiryDate"].ToString());
             batchinfo.Extra1 = sdrreader["Extra1"].ToString();
             batchinfo.Extra2 = sdrreader["Extra2"].ToString();
             batchinfo.narration = (sdrreader["narration"].ToString());
         }
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.ToString());
     }
     finally
     {
         sdrreader.Close();
         sqlcon.Close();
     }
     return batchinfo;
 }
Exemplo n.º 10
0
 /// <summary>
 /// Function to Batch Edit For Product Edit
 /// </summary>
 /// <param name="batchinfo"></param>
 /// <returns></returns>
 public bool BatchEditForProductEdit(BatchInfo batchinfo)
 {
     decimal decResult = 0;
     try
     {
         if (sqlcon.State == ConnectionState.Closed)
         {
             sqlcon.Open();
         }
         SqlCommand sccmd = new SqlCommand("BatchEditForProductEdit", sqlcon);
         sccmd.CommandType = CommandType.StoredProcedure;
         SqlParameter sprmparam = new SqlParameter();
         sprmparam = sccmd.Parameters.Add("@batchId", SqlDbType.Decimal);
         sprmparam.Value = batchinfo.BatchId;
         sprmparam = sccmd.Parameters.Add("@batchNo", SqlDbType.VarChar);
         sprmparam.Value = batchinfo.BatchNo;
         sprmparam = sccmd.Parameters.Add("@productId", SqlDbType.Decimal);
         sprmparam.Value = batchinfo.ProductId;
         sprmparam = sccmd.Parameters.Add("@manufacturingDate", SqlDbType.DateTime);
         sprmparam.Value = batchinfo.ManufacturingDate;
         sprmparam = sccmd.Parameters.Add("@expiryDate", SqlDbType.DateTime);
         sprmparam.Value = batchinfo.ExpiryDate;
         sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar);
         sprmparam.Value = batchinfo.Extra1;
         sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar);
         sprmparam.Value = batchinfo.Extra2;
         sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar);
         sprmparam.Value = batchinfo.narration;
         decResult = sccmd.ExecuteNonQuery();
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.ToString());
     }
     finally
     {
         sqlcon.Close();
     }
     if (decResult > 0)
     {
         return true;
     }
     else
     {
         return false;
     }
 }
Exemplo n.º 11
0
 /// <summary>
 /// Function to Batch And Product View By Barcode
 /// </summary>
 /// <param name="strBarcode"></param>
 /// <returns></returns>
 public BatchInfo BatchAndProductViewByBarcode(string strBarcode)
 {
     BatchInfo batchinfo = new BatchInfo();
     SqlDataReader sdrreader = null;
     try
     {
         if (sqlcon.State == ConnectionState.Closed)
         {
             sqlcon.Open();
         }
         SqlCommand sccmd = new SqlCommand("BatchAndProductViewByBarcode", sqlcon);
         sccmd.CommandType = CommandType.StoredProcedure;
         SqlParameter sprmparam = new SqlParameter();
         sprmparam = sccmd.Parameters.Add("@barcode", SqlDbType.VarChar);
         sprmparam.Value = strBarcode;
         sdrreader = sccmd.ExecuteReader();
         while (sdrreader.Read())
         {
             batchinfo.BatchId = decimal.Parse(sdrreader[0].ToString());
             batchinfo.BatchNo = sdrreader[1].ToString();
             batchinfo.ProductId = decimal.Parse(sdrreader[2].ToString());
             batchinfo.barcode = sdrreader[3].ToString();
         }
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.ToString());
     }
     finally
     {
         sdrreader.Close();
         sqlcon.Close();
     }
     return batchinfo;
 }
Exemplo n.º 12
0
 /// <summary>
 /// Function to Batch Add With BarCode
 /// </summary>
 /// <param name="batchinfo"></param>
 /// <returns></returns>
 public int BatchAddWithBarCode(BatchInfo batchinfo)
 {
     int inResultId = 0;
     try
     {
         if (sqlcon.State == ConnectionState.Closed)
         {
             sqlcon.Open();
         }
         SqlCommand sccmd = new SqlCommand("BatchAddWithBarCode", sqlcon);
         sccmd.CommandType = CommandType.StoredProcedure;
         SqlParameter sprmparam = new SqlParameter();
         sprmparam = sccmd.Parameters.Add("@batchNo", SqlDbType.VarChar);
         sprmparam.Value = batchinfo.BatchNo;
         sprmparam = sccmd.Parameters.Add("@productId", SqlDbType.Decimal);
         sprmparam.Value = batchinfo.ProductId;
         sprmparam = sccmd.Parameters.Add("@manufacturingDate", SqlDbType.DateTime);
         sprmparam.Value = batchinfo.ManufacturingDate;
         sprmparam = sccmd.Parameters.Add("@expiryDate", SqlDbType.DateTime);
         sprmparam.Value = batchinfo.ExpiryDate;
         sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar);
         sprmparam.Value = batchinfo.Extra1;
         sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar);
         sprmparam.Value = batchinfo.Extra2;
         sprmparam = sccmd.Parameters.Add("@extraDate", SqlDbType.DateTime);
         sprmparam.Value = batchinfo.ExtraDate;
         sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar);
         sprmparam.Value = batchinfo.narration;
         sprmparam = sccmd.Parameters.Add("@barcode", SqlDbType.VarChar);
         sprmparam.Value = batchinfo.barcode;
         sprmparam = sccmd.Parameters.Add("@partNo", SqlDbType.VarChar);
         sprmparam.Value = batchinfo.partNo;
         inResultId = Convert.ToInt32(sccmd.ExecuteScalar());
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.ToString());
     }
     finally
     {
         sqlcon.Close();
     }
     return inResultId;
 }
Exemplo n.º 13
0
 /// <summary>
 /// Function to add a Batch with purticular table
 /// </summary>
 /// <param name="batchinfo"></param>
 public void BatchAddParticularFields(BatchInfo batchinfo)
 {
     try
     {
         if (sqlcon.State == ConnectionState.Closed)
         {
             sqlcon.Open();
         }
         SqlCommand sccmd = new SqlCommand("BatchAddParticularFields", sqlcon);
         sccmd.CommandType = CommandType.StoredProcedure;
         SqlParameter sprmparam = new SqlParameter();
         sprmparam = sccmd.Parameters.Add("@batchNo", SqlDbType.VarChar);
         sprmparam.Value = batchinfo.BatchNo;
         sprmparam = sccmd.Parameters.Add("@productId", SqlDbType.Decimal);
         sprmparam.Value = batchinfo.ProductId;
         sprmparam = sccmd.Parameters.Add("@barcode", SqlDbType.Decimal);
         sprmparam.Value = batchinfo.barcode;
         sprmparam = sccmd.Parameters.Add("@manufacturingDate", SqlDbType.DateTime);
         sprmparam.Value = batchinfo.ManufacturingDate;
         sprmparam = sccmd.Parameters.Add("@expiryDate", SqlDbType.DateTime);
         sprmparam.Value = batchinfo.ExpiryDate;
         sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar);
         sprmparam.Value = batchinfo.Extra1;
         sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar);
         sprmparam.Value = batchinfo.Extra2;
         sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar);
         sprmparam.Value = batchinfo.narration;
         sccmd.ExecuteNonQuery();
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.ToString());
     }
     finally
     {
         sqlcon.Close();
     }
 }