public int milkproductdata(MMilkProductsTestBeforePackingQC receive)
        {
            int result = 0;

            try
            {
                DBParameterCollection paramcollection = new DBParameterCollection();
                paramcollection.Add(new DBParameter("@MilkProductsTestBeforePackingQCId", receive.MilkProductsTestBeforePackingQCId));
                paramcollection.Add(new DBParameter("@RMRId", receive.RMRId));
                paramcollection.Add(new DBParameter("@MilkProductsTestBeforePackingQCDate", receive.MilkProductsTestBeforePackingQCDate));
                paramcollection.Add(new DBParameter("@MilkProductsTestBeforePackingQCShiftId", receive.MilkProductsTestBeforePackingQCShiftId));
                paramcollection.Add(new DBParameter("@Particular", receive.Particular));
                paramcollection.Add(new DBParameter("@Quantity", receive.Quantity));
                paramcollection.Add(new DBParameter("@TestName", receive.TestName));
                paramcollection.Add(new DBParameter("@Result", receive.Result));
                paramcollection.Add(new DBParameter("@Remarks", receive.Remarks));
                paramcollection.Add(new DBParameter("@MilkProdTestBeforePackingQCStatusId", receive.MilkProdTestBeforePackingQCStatusId));
                paramcollection.Add(new DBParameter("@flag", receive.flag));
                result = _DBHelper.ExecuteNonQuery("sp_Prod_MilkProductsTestBeforePackingQCDetails ", paramcollection, CommandType.StoredProcedure);
            }
            catch (Exception EX)
            {
                String MSG = EX.ToString();
            }
            return(result);
        }
Beispiel #2
0
        protected void btnAdd_Click(object sender, EventArgs e)
        {
            {
                mmptbpqc = new MMilkProductsTestBeforePackingQC();
                bmptbpqc = new BMilkProductsTestBeforePackingQC();
                int Result = 0;
                mmptbpqc.MilkProductsTestBeforePackingQCId = 0;
                mmptbpqc.RMRId = string.IsNullOrEmpty(hId.Value) ? 0 : Convert.ToInt32(hId.Value);
                mmptbpqc.MilkProductsTestBeforePackingQCDate    = Convert.ToDateTime(txtDate.Text.ToString());
                mmptbpqc.MilkProductsTestBeforePackingQCShiftId = Convert.ToInt32(dpShiftDetails.SelectedItem.Value);
                mmptbpqc.Particular = string.IsNullOrEmpty(txtparticular.Text) ? string.Empty : txtparticular.Text;
                mmptbpqc.Quantity   = string.IsNullOrEmpty(txtQuantity.Text) ? 0 : Convert.ToDouble(txtQuantity.Text);
                mmptbpqc.TestName   = string.IsNullOrEmpty(txtTestName.Text) ? string.Empty : txtTestName.Text;
                mmptbpqc.Result     = string.IsNullOrEmpty(txtResult.Text) ? string.Empty : txtResult.Text;
                mmptbpqc.Remarks    = string.IsNullOrEmpty(txtRemarks.Text) ? string.Empty : txtRemarks.Text;
                mmptbpqc.MilkProdTestBeforePackingQCStatusId = Convert.ToInt32(dpQCStatusId.SelectedItem.Value);
                mmptbpqc.flag = "Insert";
                Result        = bmptbpqc.milkproductdata(mmptbpqc);
                if (Result > 0)
                {
                    divDanger.Visible   = false;
                    divwarning.Visible  = false;
                    divSusccess.Visible = true;

                    ScriptManager.RegisterStartupScript(this, this.GetType(), "sel3", "$('#bx1').addClass('collapsed-box');", true);

                    //string dates;
                    //dates = string.IsNullOrEmpty(txtSearchDate.Text) ? string.Empty : Convert.ToDateTime(txtSearchDate.Text).ToString("dd-MM-yyyy");
                    //GetMilkProductsTestBeforePackingQCDetails(dates);
                    RMRecieve R = new RMRecieve();
                    R.RMRDate = Convert.ToDateTime(txtSearchDate.Text);
                    GetMilkProductsTestBeforePackingQCDetails(R);
                    uprouteList.Update();
                    lblSuccess.Text = "Milk Packing QC Data Added Successfully";
                    pnlError.Update();
                }
                else
                {
                    divDanger.Visible   = false;
                    divwarning.Visible  = true;
                    divSusccess.Visible = false;
                    lblSuccess.Text     = "Something went wrong plz contact site admin";
                    pnlError.Update();
                }

                //return Result;
            }
        }
        public int milkproductdata(MMilkProductsTestBeforePackingQC receive)
        {
            damptbpqc = new DAMilkProductsTestBeforePackingQC();
            int Result = 0;

            try
            {
                Result = damptbpqc.milkproductdata(receive);
            }

            catch (Exception)
            {
                throw;
            }
            return(Result);
        }