public int mixpreparationdata(MMixPreparationIncrediantsAdded receive) { int result = 0; try { DBParameterCollection paramcollection = new DBParameterCollection(); paramcollection.Add(new DBParameter("@RMRId", receive.RMRId)); paramcollection.Add(new DBParameter("@MixPreparationIncrediantsAddedId", receive.MixPreparationIncrediantsAddedId)); paramcollection.Add(new DBParameter("@MixPreparationIncrediantsAddedDate", receive.MixPreparationIncrediantsAddedDate)); paramcollection.Add(new DBParameter("@MixPreparationIncrediantsAddedShiftId", receive.MixPreparationIncrediantsAddedShiftId)); paramcollection.Add(new DBParameter("@SMP", receive.SMP)); paramcollection.Add(new DBParameter("@Cream", receive.Cream)); paramcollection.Add(new DBParameter("@Milk", receive.Milk)); paramcollection.Add(new DBParameter("@Sugar", receive.Sugar)); paramcollection.Add(new DBParameter("@Stabilizer", receive.Stabilizer)); paramcollection.Add(new DBParameter("@Emulsifier", receive.Emulsifier)); paramcollection.Add(new DBParameter("@TotalMixQty", receive.TotalMixQty)); paramcollection.Add(new DBParameter("@Remarks", receive.Remarks)); paramcollection.Add(new DBParameter("@flag", receive.flag)); result = _DBHelper.ExecuteNonQuery("sp_Prod_PreparationIncrediantsAddedDetails", paramcollection, CommandType.StoredProcedure); } catch (Exception EX) { string MSG = EX.ToString(); } return(result); }
public int mixpreparationdata(MMixPreparationIncrediantsAdded receive) { dampia = new DAMixPreparationIncrediantsAdded(); int Result = 0; try { Result = dampia.mixpreparationdata(receive); } catch (Exception) { throw; } return(Result); }
protected void btnUpdate_Click(object sender, EventArgs e) { { mmpia = new MMixPreparationIncrediantsAdded(); bmpia = new BMixPreparationIncrediantsAdded(); int Result = 0; mmpia.MixPreparationIncrediantsAddedId = 0; mmpia.RMRId = string.IsNullOrEmpty(hId.Value) ? 0 : Convert.ToInt32(hId.Value); mmpia.MixPreparationIncrediantsAddedDate = Convert.ToDateTime(txtDate.Text.ToString()); mmpia.MixPreparationIncrediantsAddedShiftId = Convert.ToInt32(dpShiftDetails.SelectedItem.Value); mmpia.SMP = string.IsNullOrEmpty(txtSMP.Text) ? 0 : Convert.ToDouble(txtSMP.Text); mmpia.Cream = string.IsNullOrEmpty(txtCream.Text) ? 0 : Convert.ToDouble(txtCream.Text); mmpia.Milk = txtMilk.Text; mmpia.Sugar = string.IsNullOrEmpty(txtSugar.Text) ? 0 : Convert.ToDouble(txtSugar.Text); mmpia.Stabilizer = string.IsNullOrEmpty(txtStabilizer.Text) ? 0 : Convert.ToDouble(txtStabilizer.Text); mmpia.Emulsifier = string.IsNullOrEmpty(txtEmulsifier.Text) ? 0 : Convert.ToDouble(txtEmulsifier.Text); mmpia.TotalMixQty = string.IsNullOrEmpty(txtTotalMixQty.Text) ? 0 : Convert.ToDouble(txtTotalMixQty.Text); mmpia.Remarks = txtRemarks.Text; mmpia.flag = "Update"; Result = bmpia.mixpreparationdata(mmpia); if (Result > 0) { divDanger.Visible = false; divwarning.Visible = false; divSusccess.Visible = true; lblSuccess.Text = "Mix Preparation Incrediants Added Data Update Successfully"; pnlError.Update(); // GetPastDetails(); } else { divDanger.Visible = false; divwarning.Visible = true; divSusccess.Visible = false; lblSuccess.Text = "Something went wrong plz contact site admin"; pnlError.Update(); } //return Result; } }