public int icecreamdata(MIceCreamMixProcessing receive) { int result = 0; try { DBParameterCollection paramcollection = new DBParameterCollection(); paramcollection.Add(new DBParameter("@IceCreamMixProcessingId", receive.IceCreamMixProcessingId)); paramcollection.Add(new DBParameter("@RMRId", receive.RMRId)); paramcollection.Add(new DBParameter("@IceCreamMixProcessingDate", receive.IceCreamMixProcessingDate)); paramcollection.Add(new DBParameter("@IceCreamMixProcessingShiftId", receive.IceCreamMixProcessingShiftId)); paramcollection.Add(new DBParameter("@StartingTime", receive.StartingTime)); paramcollection.Add(new DBParameter("@EndTime", receive.EndTime)); paramcollection.Add(new DBParameter("@BatchQuantity", receive.BatchQuantity)); paramcollection.Add(new DBParameter("@HeatTemperature", receive.HeatTemperature)); paramcollection.Add(new DBParameter("@homogenizerPressureStage1", receive.homogenizerPressureStage1)); paramcollection.Add(new DBParameter("@HomogenizerPressureStage2", receive.HomogenizerPressureStage2)); paramcollection.Add(new DBParameter("@ChillingTemperature", receive.ChillingTemperature)); paramcollection.Add(new DBParameter("@AGINGStartingTime", receive.AGINGStartingTime)); paramcollection.Add(new DBParameter("@AGINGEndTime", receive.AGINGEndTime)); paramcollection.Add(new DBParameter("@FinalTemperatureInAGINGVAT", receive.FinalTemperatureInAGINGVAT)); paramcollection.Add(new DBParameter("@OperatedBy", receive.OperatedBy)); paramcollection.Add(new DBParameter("@TechnicianName", receive.TechnicianName)); paramcollection.Add(new DBParameter("@Remarks", receive.Remarks)); paramcollection.Add(new DBParameter("@flag", receive.flag)); result = _DBHelper.ExecuteNonQuery("sp_Prod_IceCreamMixProcessingDetails", paramcollection, CommandType.StoredProcedure); } catch (Exception EX) { String MSG = EX.ToString(); } return(result); }
public int icecreamdata(MIceCreamMixProcessing receive) { daimp = new DAIceCreamMixProcessing(); int Result = 0; try { Result = daimp.icecreamdata(receive); } catch (Exception) { throw; } return(Result); }
protected void btnUpdate_Click(object sender, EventArgs e) { { mimp = new MIceCreamMixProcessing(); bimp = new BIceCreamMixProcessing(); int Result = 0; mimp.IceCreamMixProcessingId = 0; mimp.RMRId = string.IsNullOrEmpty(hId.Value) ? 0 : Convert.ToInt32(hId.Value); mimp.IceCreamMixProcessingDate = Convert.ToDateTime(txtDate.Text.ToString()); mimp.IceCreamMixProcessingShiftId = Convert.ToInt32(dpShiftDetails.SelectedItem.Value); mimp.StartingTime = txtStartingTime.Text; mimp.EndTime = txtEndTime.Text; mimp.BatchQuantity = string.IsNullOrEmpty(txtBatchQuantity.Text) ? 0 : Convert.ToDouble(txtBatchQuantity.Text); mimp.HeatTemperature = string.IsNullOrEmpty(txtHeatTemperature.Text) ? 0 : Convert.ToDouble(txtHeatTemperature.Text); mimp.homogenizerPressureStage1 = string.IsNullOrEmpty(txthomogenizerPressureStage1.Text) ? 0 : Convert.ToDouble(txthomogenizerPressureStage1.Text); mimp.HomogenizerPressureStage2 = string.IsNullOrEmpty(txtHomogenizerPressureStage2.Text) ? 0 : Convert.ToDouble(txtHomogenizerPressureStage2.Text); mimp.ChillingTemperature = string.IsNullOrEmpty(txtChillingTemperature.Text) ? 0 : Convert.ToDouble(txtChillingTemperature.Text); mimp.AGINGStartingTime = txtAGINGStartingTime.Text; mimp.AGINGEndTime = txtAGINGEndTime.Text; mimp.FinalTemperatureInAGINGVAT = string.IsNullOrEmpty(txtFinalTemperatureInAGINGVAT.Text) ? 0 : Convert.ToDouble(txtFinalTemperatureInAGINGVAT.Text); mimp.OperatedBy = txtOperatedBy.Text; mimp.TechnicianName = txtTechnicianName.Text; mimp.Remarks = txtRemarks.Text; mimp.flag = "Update"; Result = bimp.icecreamdata(mimp); if (Result > 0) { divDanger.Visible = false; divwarning.Visible = false; divSusccess.Visible = true; lblSuccess.Text = "Ice Cream Mix Processing 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; } }