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