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); }
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; } }