public int microbiologicalmilkproductdata(MMicrobiologicalAnalysisForMilkAndMilkProductsQC receive)
{
int result = 0;
try
{
DBParameterCollection paramcollection = new DBParameterCollection();
paramcollection.Add(new DBParameter("@MicrobiologicalAnalysisForMilkAndMilkProductsQCId", receive.MicrobiologicalAnalysisForMilkAndMilkProductsQCId));
paramcollection.Add(new DBParameter("@MicrobiologicalAnalysisForMilkAndMilkProductsQCDate", receive.MicrobiologicalAnalysisForMilkAndMilkProductsQCDate));
paramcollection.Add(new DBParameter("@MicrobiologicalAnalysisForMilkAndMilkProductsQCShiftId", receive.MicrobiologicalAnalysisForMilkAndMilkProductsQCShiftId));
paramcollection.Add(new DBParameter("@TestedBy", receive.TestedBy));
paramcollection.Add(new DBParameter("@ActionTakenBy", receive.ActionTakenBy));
paramcollection.Add(new DBParameter("@VerifiedBy", receive.VerifiedBy));
paramcollection.Add(new DBParameter("@SampleTakenPlace", receive.SampleTakenPlace));
paramcollection.Add(new DBParameter("@SampleTestingTime", receive.SampleTestingTime));
paramcollection.Add(new DBParameter("@ColiForm", receive.ColiForm));
paramcollection.Add(new DBParameter("@TBCCFUAndML", receive.TBCCFUAndML));
paramcollection.Add(new DBParameter("@YeastAndMouldCFUAndML", receive.YeastAndMouldCFUAndML));
paramcollection.Add(new DBParameter("@CorrectiveActionRequired", receive.CorrectiveActionRequired));
paramcollection.Add(new DBParameter("@Remarks", receive.Remarks));
paramcollection.Add(new DBParameter("@flag", receive.flag));
result = _DBHelper.ExecuteNonQuery("sp_Prod_MicrobiologicalAnalysisForMilkAndMilkProductsQCDetails", paramcollection, CommandType.StoredProcedure);
}
catch (Exception EX)
{
string MSG = EX.ToString();
}
return(result);
}
public int microbiologicalmilkproductdata(MMicrobiologicalAnalysisForMilkAndMilkProductsQC receive)
{
dambafmampqc = new DAMicrobiologicalAnalysisForMilkAndMilkProductsQC();
int Result = 0;
try
{
Result = dambafmampqc.microbiologicalmilkproductdata(receive);
}
catch (Exception)
{
throw;
}
return(Result);
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
mmbafmampqc = new MMicrobiologicalAnalysisForMilkAndMilkProductsQC();
bmbafmampqc = new BMicrobiologicalAnalysisForMilkAndMilkProductsQC();
int Result = 0;
mmbafmampqc.MicrobiologicalAnalysisForMilkAndMilkProductsQCId = string.IsNullOrEmpty(hId.Value) ? 0 : Convert.ToInt32(hId.Value);
mmbafmampqc.MicrobiologicalAnalysisForMilkAndMilkProductsQCDate = Convert.ToDateTime(txtDate.Text.ToString());
mmbafmampqc.MicrobiologicalAnalysisForMilkAndMilkProductsQCShiftId = Convert.ToInt32(dpShiftDetails.SelectedItem.Value);
mmbafmampqc.TestedBy = string.IsNullOrEmpty(txtTestedBy.Text) ? string.Empty : txtTestedBy.Text;
mmbafmampqc.ActionTakenBy = string.IsNullOrEmpty(txtActionTakenBy.Text) ? string.Empty : txtActionTakenBy.Text;
mmbafmampqc.VerifiedBy = string.IsNullOrEmpty(txtVerifiedBy.Text) ? string.Empty : txtVerifiedBy.Text;
mmbafmampqc.SampleTakenPlace = string.IsNullOrEmpty(txtSampleTakenPlace.Text) ? string.Empty : txtSampleTakenPlace.Text;
mmbafmampqc.SampleTestingTime = string.IsNullOrEmpty(txtSampleTestingTime.Text) ? string.Empty : txtSampleTestingTime.Text;
mmbafmampqc.ColiForm = string.IsNullOrEmpty(txtColiForm.Text) ? string.Empty : txtColiForm.Text;
mmbafmampqc.TBCCFUAndML = string.IsNullOrEmpty(txtTBCCFUML.Text) ? string.Empty : txtTBCCFUML.Text;
mmbafmampqc.YeastAndMouldCFUAndML = string.IsNullOrEmpty(txtYeastMouldCFUML.Text) ? string.Empty : txtYeastMouldCFUML.Text;
mmbafmampqc.CorrectiveActionRequired = string.IsNullOrEmpty(txtCorrectiveActionRequired.Text) ? string.Empty : txtCorrectiveActionRequired.Text;
mmbafmampqc.Remarks = string.IsNullOrEmpty(txtRemarks.Text) ? string.Empty : txtRemarks.Text;
mmbafmampqc.flag = "Update";
Result = bmbafmampqc.microbiologicalmilkproductdata(mmbafmampqc);
if (Result > 0)
{
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
lblSuccess.Text = "Microbiological Analysis For Milk And Milk ProductsQC Updated 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
}
protected void btnAdd_Click(object sender, EventArgs e)
{
mmbafmampqc = new MMicrobiologicalAnalysisForMilkAndMilkProductsQC();
bmbafmampqc = new BMicrobiologicalAnalysisForMilkAndMilkProductsQC();
int Result = 0;
mmbafmampqc.MicrobiologicalAnalysisForMilkAndMilkProductsQCId = 0;
mmbafmampqc.MicrobiologicalAnalysisForMilkAndMilkProductsQCDate = Convert.ToDateTime(txtDate.Text.ToString());
mmbafmampqc.MicrobiologicalAnalysisForMilkAndMilkProductsQCShiftId = Convert.ToInt32(dpShiftDetails.SelectedItem.Value);
mmbafmampqc.TestedBy = string.IsNullOrEmpty(txtTestedBy.Text)?string.Empty :txtTestedBy.Text;
mmbafmampqc.ActionTakenBy = string.IsNullOrEmpty(txtActionTakenBy.Text) ? string.Empty : txtActionTakenBy.Text;
mmbafmampqc.VerifiedBy = string.IsNullOrEmpty(txtVerifiedBy.Text) ? string.Empty : txtVerifiedBy.Text;
mmbafmampqc.SampleTakenPlace = string.IsNullOrEmpty(txtSampleTakenPlace.Text) ? string.Empty : txtSampleTakenPlace.Text;
mmbafmampqc.SampleTestingTime = string.IsNullOrEmpty(txtSampleTestingTime.Text)?string.Empty :txtSampleTestingTime.Text;
mmbafmampqc.ColiForm = string.IsNullOrEmpty(txtColiForm.Text) ? string.Empty : txtColiForm.Text;
mmbafmampqc.TBCCFUAndML = string.IsNullOrEmpty(txtTBCCFUML.Text) ? string.Empty : txtTBCCFUML.Text;
mmbafmampqc.YeastAndMouldCFUAndML = string.IsNullOrEmpty(txtYeastMouldCFUML.Text) ? string.Empty : txtYeastMouldCFUML.Text;
mmbafmampqc.CorrectiveActionRequired = string.IsNullOrEmpty(txtCorrectiveActionRequired.Text) ? string.Empty : txtCorrectiveActionRequired.Text;
mmbafmampqc.Remarks = string.IsNullOrEmpty(txtRemarks.Text) ? string.Empty : txtRemarks.Text;
mmbafmampqc.flag = "Insert";
Result = bmbafmampqc.microbiologicalmilkproductdata(mmbafmampqc);
if (Result > 0)
{
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
lblSuccess.Text = "Microbiological Analysis For Milk And Milk ProductsQC Added Successfully";
pnlError.Update();
ScriptManager.RegisterStartupScript(this, this.GetType(), "sel3", "$('#bx1').removeClass('collapsed-box');", true);
}
else
{
divDanger.Visible = false;
divwarning.Visible = true;
divSusccess.Visible = false;
lblSuccess.Text = "Something went wrong plz contact site admin";
pnlError.Update();
}
//return Result;
}
