public int microbiologicaldata(MMicrobiologicalCultureStockRegisterQC receive)
{
int result = 0;
try
{
DBParameterCollection paramcollection = new DBParameterCollection();
paramcollection.Add(new DBParameter("@MicrobiologicalCultureStockRegisterQCId", receive.MicrobiologicalCultureStockRegisterQCId));
paramcollection.Add(new DBParameter("@MicrobiologicalStockDate", receive.MicrobiologicalStockDate));
paramcollection.Add(new DBParameter("@ReceivedDate", receive.ReceivedDate));
paramcollection.Add(new DBParameter("@PackingDate", receive.PackingDate));
paramcollection.Add(new DBParameter("@OpeningStock", receive.OpeningStock));
paramcollection.Add(new DBParameter("@Receipt", receive.Receipt));
paramcollection.Add(new DBParameter("@Issue", receive.Issue));
paramcollection.Add(new DBParameter("@Damage", receive.Damage));
paramcollection.Add(new DBParameter("@Returned", receive.Returned));
paramcollection.Add(new DBParameter("@ClosingStock", receive.ClosingStock));
paramcollection.Add(new DBParameter("@CultureUsed", receive.CultureUsed));
paramcollection.Add(new DBParameter("@VerifiedBy", receive.VerifiedBy));
paramcollection.Add(new DBParameter("@flag", receive.flag));
result = _DBHelper.ExecuteNonQuery("sp_Prod_MicrobiologicalCultureStockRegisterQCDetails", paramcollection, CommandType.StoredProcedure);
}
catch (Exception EX)
{
string MSG = EX.ToString();
}
return(result);
}
public int microbiologicaldata(MMicrobiologicalCultureStockRegisterQC receive)
{
dambcsrqc = new DAMicrobiologicalCultureStockRegisterQC();
int Result = 0;
try
{
Result = dambcsrqc.microbiologicaldata(receive);
}
catch (Exception)
{
throw;
}
return(Result);
}
protected void btnUpdate_Click1(object sender, EventArgs e)
{
mmbcsrqc = new MMicrobiologicalCultureStockRegisterQC();
bmbcsrqc = new BMicrobiologicalCultureStockRegisterQC();
int Result = 0;
mmbcsrqc.MicrobiologicalCultureStockRegisterQCId = Convert.ToInt32(hId.Value);
mmbcsrqc.MicrobiologicalStockDate = Convert.ToDateTime(txtStockDate.Text.ToString());
mmbcsrqc.ReceivedDate = Convert.ToDateTime(txtReceivedDate.Text.ToString());
mmbcsrqc.PackingDate = Convert.ToDateTime(txtPackingDate.Text.ToString());
mmbcsrqc.OpeningStock = string.IsNullOrEmpty(txtOpeningStock.Text) ? 0 : Convert.ToDouble(txtOpeningStock.Text);
mmbcsrqc.Receipt = string.IsNullOrEmpty(txtReceipt.Text) ? string.Empty : txtReceipt.Text;
mmbcsrqc.Issue = string.IsNullOrEmpty(txtIssue.Text) ? string.Empty : txtIssue.Text;
mmbcsrqc.Damage = string.IsNullOrEmpty(txtDamage.Text) ? string.Empty : txtDamage.Text;
mmbcsrqc.Returned = string.IsNullOrEmpty(txtReturned.Text) ? string.Empty : txtReturned.Text;
mmbcsrqc.ClosingStock = string.IsNullOrEmpty(txtClosingStock.Text) ? 0 : Convert.ToDouble(txtClosingStock.Text);
mmbcsrqc.CultureUsed = string.IsNullOrEmpty(txtCultureUsed.Text) ? string.Empty : txtCultureUsed.Text;
mmbcsrqc.VerifiedBy = string.IsNullOrEmpty(txtVerifiedBy.Text) ? string.Empty : txtVerifiedBy.Text;
mmbcsrqc.flag = "Update";
Result = bmbcsrqc.microbiologicaldata(mmbcsrqc);
if (Result > 0)
{
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
lblSuccess.Text = "Micro biological Culture Stock Register QC Data 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();
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
mmbcsrqc = new MMicrobiologicalCultureStockRegisterQC();
bmbcsrqc = new BMicrobiologicalCultureStockRegisterQC();
int Result = 0;
mmbcsrqc.MicrobiologicalCultureStockRegisterQCId = 0;
mmbcsrqc.MicrobiologicalStockDate = Convert.ToDateTime(txtStockDate.Text.ToString());
mmbcsrqc.ReceivedDate = Convert.ToDateTime(txtReceivedDate.Text.ToString());
mmbcsrqc.PackingDate = Convert.ToDateTime(txtPackingDate.Text.ToString());
mmbcsrqc.OpeningStock = string.IsNullOrEmpty(txtOpeningStock.Text) ? 0 : Convert.ToDouble(txtOpeningStock.Text);
mmbcsrqc.Receipt = string.IsNullOrEmpty(txtReceipt.Text) ? string.Empty :txtReceipt.Text;
mmbcsrqc.Issue = string.IsNullOrEmpty(txtIssue.Text)?string.Empty:txtIssue.Text;
mmbcsrqc.Damage = string.IsNullOrEmpty(txtDamage.Text) ? string.Empty:txtDamage.Text;
mmbcsrqc.Returned = string.IsNullOrEmpty(txtReturned.Text) ? string.Empty:txtReturned.Text;
mmbcsrqc.ClosingStock = string.IsNullOrEmpty(txtClosingStock.Text) ? 0 : Convert.ToDouble(txtClosingStock.Text);
mmbcsrqc.CultureUsed = string.IsNullOrEmpty(txtCultureUsed.Text) ? string.Empty:txtCultureUsed.Text;
mmbcsrqc.VerifiedBy = string.IsNullOrEmpty(txtVerifiedBy.Text) ? string.Empty : txtVerifiedBy.Text;
mmbcsrqc.flag = "Insert";
Result = bmbcsrqc.microbiologicaldata(mmbcsrqc);
if (Result > 0)
{
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
lblSuccess.Text = "Micro biological Culture Stock Register QC Data 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();
}
}
