public int adulterationqcdata(MAdulterationConfirmationTastQC receive)
{
int result = 0;
try
{
DBParameterCollection paramcollection = new DBParameterCollection();
paramcollection.Add(new DBParameter("@RMRId", receive.RMRId));
paramcollection.Add(new DBParameter("@AdulterationConfirmationTestQCId", receive.AdulterationConfirmationTestQCId));
paramcollection.Add(new DBParameter("@AdulterationConfirmationTestQCDate", receive.AdulterationConfirmationTestQCDate));
paramcollection.Add(new DBParameter("@AdulterationConfirmationTestQCShiftId", receive.AdulterationConfirmationTestQCShiftId));
paramcollection.Add(new DBParameter("@Sugar", receive.Sugar));
paramcollection.Add(new DBParameter("@Starch", receive.Starch));
paramcollection.Add(new DBParameter("@HydrogenPeroxide", receive.HydrogenPeroxide));
paramcollection.Add(new DBParameter("@Neutralizer", receive.Neutralizer));
paramcollection.Add(new DBParameter("@Remarks", receive.Remarks));
paramcollection.Add(new DBParameter("@AdulterationConfirmationTestQCStatus", receive.AdulterationConfirmationTestQCStatus));
paramcollection.Add(new DBParameter("@flag", receive.flag));
result = _DBHelper.ExecuteNonQuery("prod_spAdulterationConfirmationTestQCDetails ", paramcollection, CommandType.StoredProcedure);
}
catch (Exception EX)
{
String MSG = EX.ToString();
}
return(result);
}
public int adulterationqcdata(MAdulterationConfirmationTastQC receive)
{
daactqc = new DAAdulterationConfirmationTastQC();
int Result = 0;
try
{
Result = daactqc.adulterationqcdata(receive);
}
catch (Exception)
{
throw;
}
return(Result);
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
{
mactqc = new MAdulterationConfirmationTastQC();
bactqc = new BAdulterationConfirmationTastQC();
int Result = 0;
mactqc.AdulterationConfirmationTestQCId = 0;
mactqc.RMRId = string.IsNullOrEmpty(hId.Value) ? 0 : Convert.ToInt32(hId.Value);
mactqc.AdulterationConfirmationTestQCDate = Convert.ToDateTime(txtDate.Text.ToString());
mactqc.AdulterationConfirmationTestQCShiftId = Convert.ToInt32(dpShiftDetails.SelectedItem.Value);
mactqc.Sugar = string.IsNullOrEmpty(txtSugar.Text) ? 0 : Convert.ToDouble(txtSugar.Text);
mactqc.Starch = string.IsNullOrEmpty(txtStarch.Text) ? 0 : Convert.ToDouble(txtStarch.Text);
mactqc.HydrogenPeroxide = string.IsNullOrEmpty(txtHydrogenPeroxide.Text) ? 0 : Convert.ToDouble(txtHydrogenPeroxide.Text);
mactqc.Neutralizer = string.IsNullOrEmpty(txtNeutralizer.Text) ? 0 : Convert.ToDouble(txtNeutralizer.Text);
mactqc.Remarks = txtRemarks.Text;
mactqc.AdulterationConfirmationTestQCStatus = Convert.ToInt32(dpStatusDetails.SelectedItem.Value);
mactqc.flag = "Update";
Result = bactqc.adulterationqcdata(mactqc);
if (Result > 0)
{
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
lblSuccess.Text = "Adulteration Confirmation Tast QC Data Add 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;
}
}