public int Draineddata(MReturnDrainedMilkQualityQC receive)
        {
            int result = 0;

            try
            {
                DBParameterCollection paramcollection = new DBParameterCollection();

                paramcollection.Add(new DBParameter("@ReturnDrainedMilkQualityQCId", receive.ReturnDrainedMilkQualityQCId));
                paramcollection.Add(new DBParameter("@RMRId", receive.RMRId));
                paramcollection.Add(new DBParameter("@ReturnDrainedMilkQCDate", receive.ReturnDrainedMilkQCDate));
                paramcollection.Add(new DBParameter("@ReturnDrainedMilkQCShiftId", receive.ReturnDrainedMilkQCShiftId));
                paramcollection.Add(new DBParameter("@Source", receive.Source));
                paramcollection.Add(new DBParameter("@Quantity", receive.Quantity));
                paramcollection.Add(new DBParameter("@MBRT", receive.MBRT));
                paramcollection.Add(new DBParameter("@TEMP", receive.TEMP));
                paramcollection.Add(new DBParameter("@Remarks", receive.Remarks));
                paramcollection.Add(new DBParameter("@ReturnDrainedMilkQcStatusId", receive.ReturnDrainedMilkQcStatusId));
                paramcollection.Add(new DBParameter("@flag", receive.flag));
                result = _DBHelper.ExecuteNonQuery("sp_Prod_ReturnDrainedMilkQualityQCDetails", paramcollection, CommandType.StoredProcedure);
            }
            catch (Exception EX)
            {
                string MSG = EX.ToString();
            }
            return(result);
        }
        public int Draineddata(MReturnDrainedMilkQualityQC recieve)
        {
            dadrainedqc = new DAReturnDrainedMilkQualityQC();
            int Result = 0;

            try
            {
                Result = dadrainedqc.Draineddata(recieve);
            }
            catch (Exception)
            {
                throw;
            }
            return(Result);
        }
示例#3
0
        protected void btnAdd_Click1(object sender, EventArgs e)
        {
            {
                mdrainedqc = new MReturnDrainedMilkQualityQC();
                bdrainedqc = new BReturnDrainedMilkQualityQC();
                int Result = 0;
                mdrainedqc.ReturnDrainedMilkQualityQCId = 0;
                mdrainedqc.RMRId = string.IsNullOrEmpty(hId.Value) ? 0 : Convert.ToInt32(hId.Value);
                mdrainedqc.ReturnDrainedMilkQCDate    = Convert.ToDateTime(txtDate.Text.ToString());
                mdrainedqc.ReturnDrainedMilkQCShiftId = Convert.ToInt32(dpShiftDetails.SelectedItem.Value);
                mdrainedqc.Source   = string.IsNullOrEmpty(txtSource.Text)?string.Empty:(txtSource.Text);
                mdrainedqc.Quantity = string.IsNullOrEmpty(txtQuantity.Text) ? 0 : Convert.ToDouble(txtQuantity.Text);
                mdrainedqc.MBRT     = string.IsNullOrEmpty(txtMBRT.Text) ? 0 : Convert.ToDouble(txtMBRT.Text);
                mdrainedqc.TEMP     = string.IsNullOrEmpty(txtTEMP.Text) ? 0 : Convert.ToDouble(txtTEMP.Text);
                mdrainedqc.Remarks  = string.IsNullOrEmpty(txtRemarks.Text)?string.Empty:(txtRemarks.Text);
                mdrainedqc.ReturnDrainedMilkQcStatusId = Convert.ToInt32(dpDrainedMilkQCStatusId.SelectedItem.Value);
                mdrainedqc.flag = "Insert";
                Result          = bdrainedqc.Draineddata(mdrainedqc);
                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 = string.IsNullOrEmpty(txtSearchDate.Text) ? string.Empty : Convert.ToDateTime(txtSearchDate.Text).ToString("dd-MM-yyyy");
                    //GetDrainedMilkQCDetails(dates);
                    RMRecieve R = new RMRecieve();
                    R.RMRDate = Convert.ToDateTime(txtSearchDate.Text);
                    GetDrainedMilkQCDetails(R);
                    uprouteList.Update();
                    lblSuccess.Text = "ReturnDrainedMilkQualityQC 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;
            }
        }