public void GetMicrobiologicalCultureStockRegisterQCDetails()
{
bmbcsrqc = new BMicrobiologicalCultureStockRegisterQC();
DataSet DS = new DataSet();
DS = bmbcsrqc.GetMicrobiologicalCultureStockRegisterQCDetails();
if (!Comman.Comman.IsDataSetEmpty(DS))
{
rpMicrobiologicalCultureStockRegisterQC.DataSource = DS;
rpMicrobiologicalCultureStockRegisterQC.DataBind();
}
}
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();
}
}
public void GetMicrobiologicalCultureStockRegisterQCDetails(int MicrobiologicalCultureStockRegisterQCId)
{
DataSet DS = new DataSet();
bmbcsrqc = new BMicrobiologicalCultureStockRegisterQC();
DS = bmbcsrqc.GetMicrobiologicalCultureStockRegisterQCDetailsById(MicrobiologicalCultureStockRegisterQCId);
if (!Comman.Comman.IsDataSetEmpty(DS))
{
//string DATE = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["MicrobiologicalStockDate"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["MicrobiologicalStockDate"].ToString();
//DateTime date1 = Convert.ToDateTime(DATE, System.Globalization.CultureInfo.GetCultureInfo("ur-PK").DateTimeFormat);
//txtStockDate.Text = (Convert.ToDateTime(date1).ToString("yyyy-MM-dd"));
//string DATE2 = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["ReceivedDate"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["ReceivedDate"].ToString();
//DateTime date2 = Convert.ToDateTime(DATE2, System.Globalization.CultureInfo.GetCultureInfo("ur-PK").DateTimeFormat);
//txtReceivedDate.Text = (Convert.ToDateTime(date2).ToString("yyyy-MM-dd"));
//string DATE3 = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["PackingDate"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["PackingDate"].ToString();
//DateTime date3 = Convert.ToDateTime(DATE3, System.Globalization.CultureInfo.GetCultureInfo("ur-PK").DateTimeFormat);
//txtPackingDate.Text = (Convert.ToDateTime(date3).ToString("yyyy-MM-dd"));
string DATE = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["MicrobiologicalStockDate"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["MicrobiologicalStockDate"].ToString();
if (DATE == "")
{
txtStockDate.Text = Convert.ToString(DateTime.Now.ToString("yyy-MM-dd"));
}
else
{
DateTime date1 = Convert.ToDateTime(DATE, System.Globalization.CultureInfo.GetCultureInfo("ur-PK").DateTimeFormat);
txtStockDate.Text = (Convert.ToDateTime(date1).ToString("yyyy-MM-dd"));
}
string DATE2 = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["ReceivedDate"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["ReceivedDate"].ToString();
if (DATE2 == "")
{
txtReceivedDate.Text = Convert.ToString(DateTime.Now.ToString("yyy-MM-dd"));
}
else
{
DateTime date1 = Convert.ToDateTime(DATE, System.Globalization.CultureInfo.GetCultureInfo("ur-PK").DateTimeFormat);
txtReceivedDate.Text = (Convert.ToDateTime(date1).ToString("yyyy-MM-dd"));
}
string DATE3 = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["PackingDate"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["PackingDate"].ToString();
if (DATE3 == "")
{
txtPackingDate.Text = Convert.ToString(DateTime.Now.ToString("yyy-MM-dd"));
}
else
{
DateTime date1 = Convert.ToDateTime(DATE, System.Globalization.CultureInfo.GetCultureInfo("ur-PK").DateTimeFormat);
txtPackingDate.Text = (Convert.ToDateTime(date1).ToString("yyyy-MM-dd"));
}
txtOpeningStock.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["OpeningStock"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["OpeningStock"].ToString();
txtReceipt.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Receipt"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["Receipt"].ToString();
txtIssue.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Issue"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["Issue"].ToString();
txtDamage.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Damage"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["Damage"].ToString();
txtReturned.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Returned"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["Returned"].ToString();
txtClosingStock.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["ClosingStock"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["ClosingStock"].ToString();
txtCultureUsed.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["CultureUsed"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["CultureUsed"].ToString();
txtVerifiedBy.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["VerifiedBy"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["VerifiedBy"].ToString();
}
}
