public int homodata(MHomogenizer receive) { int result = 0; try { DBParameterCollection paramcollection = new DBParameterCollection(); //paramcollection.Add(new DBParameter("@HomogenizerId", receive.HomogenizerId)); paramcollection.Add(new DBParameter("@RMRId", receive.RMRId)); paramcollection.Add(new DBParameter("@HomogenizerDate", receive.HomogenizerDate)); paramcollection.Add(new DBParameter("@HomogenizerShiftId", receive.HomogenizerShiftId)); paramcollection.Add(new DBParameter("@MachineStartTime", receive.MachineStartTime)); paramcollection.Add(new DBParameter("@MachineEndTime", receive.MachineEndTime)); paramcollection.Add(new DBParameter("@PressureFirstStage", receive.PressureFirstStage)); paramcollection.Add(new DBParameter("@PressureSecondStage", receive.PressureSecondStage)); paramcollection.Add(new DBParameter("@OilleakageId", receive.OilleakageId)); paramcollection.Add(new DBParameter("@HomogenizedQty", receive.HomogenizedQty)); paramcollection.Add(new DBParameter("@Technician", receive.Technician)); paramcollection.Add(new DBParameter("@Homogenized", receive.Homogenized)); paramcollection.Add(new DBParameter("@Remarks", receive.Remarks)); paramcollection.Add(new DBParameter("@HomogenizerStatusId", receive.HomogenizerStatusId)); paramcollection.Add(new DBParameter("@flag", receive.flag)); result = _DBHelper.ExecuteNonQuery("sp_prod_HomogenizerDetails", paramcollection, CommandType.StoredProcedure); } catch (Exception EX) { String MSG = EX.ToString(); } return(result); }
protected void btnUpdate_Click(object sender, EventArgs e) { { mhomo = new MHomogenizer(); bhomo = new BHomogenizer(); int Result = 0; mhomo.HomogenizerId = 0; mhomo.RMRId = string.IsNullOrEmpty(hId.Value) ? 0 : Convert.ToInt32(hId.Value); mhomo.HomogenizerDate = Convert.ToDateTime(txtHomogenizerDate.Text.ToString()); mhomo.HomogenizerShiftId = Convert.ToInt32(dpShiftDetails.SelectedItem.Value); //mhomo.StatusId = Convert.ToInt32(dpStatusDetails.SelectedItem.Value); mhomo.PressureFirstStage = string.IsNullOrEmpty(txtPressureFisrtStage.Text) ? 0 : Convert.ToDouble(txtPressureFisrtStage.Text); mhomo.PressureSecondStage = string.IsNullOrEmpty(txtPressureSecondStage.Text) ? 0 : Convert.ToDouble(txtPressureSecondStage.Text); // mhomo.Oilleakage = string.IsNullOrEmpty(txtOilleakage.Text) ? 0 : Convert.ToDouble(txtOilleakage.Text); mhomo.OilleakageId = Convert.ToInt32(dpOilLeakage.SelectedItem.Value); mhomo.HomogenizedQty = string.IsNullOrEmpty(txtQtyHomogenized.Text) ? 0 : Convert.ToDouble(txtQtyHomogenized.Text); mhomo.Technician = txtTechnician.Text; //mhomo.Homogenized = txtHomogenized.Text; mhomo.Remarks = txtRemarks.Text; mhomo.MachineStartTime = txtStartingTime.Text; mhomo.MachineEndTime = txtEndTime.Text; mhomo.Technician = txtTechnician.Text; mhomo.HomogenizerStatusId = Convert.ToInt32(dpStatusDetails.SelectedItem.Value); mhomo.flag = "Update"; Result = bhomo.homodata(mhomo); 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"); //GetHomogenizerDetails(dates); RMRecieve R = new RMRecieve(); R.RMRDate = Convert.ToDateTime(txtSearchDate.Text); GetHomogenizerDetails(R); uprouteList.Update(); lblSuccess.Text = "Homogenizer Data Update 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 homodata(MHomogenizer receive) { dahomo = new DAHomogenizer(); int Result = 0; try { Result = dahomo.homodata(receive); } catch (Exception) { throw; } return(Result); }