public void GetAdulterationConfirmationTastQCDetails(int RMRId)
{
DataSet DS = new DataSet();
bactqc = new BAdulterationConfirmationTastQC();
DS = bactqc.GetAdulterationConfirmationTastQCDetailsById(RMRId);
if (!Comman.Comman.IsDataSetEmpty(DS))
{
//string DATE = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["AdulterationConfirmationTestQCDate"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["AdulterationConfirmationTestQCDate"].ToString();
//DateTime date1 = Convert.ToDateTime(DATE, System.Globalization.CultureInfo.GetCultureInfo("ur-PK").DateTimeFormat);
//txtDate.Text = (Convert.ToDateTime(date1).ToString("yyyy-MM-dd"));
//dpShiftDetails.ClearSelection();
//if (dpShiftDetails.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["AdulterationConfirmationTestQCShiftId"]).ToString()) != null)
//{
// dpShiftDetails.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["AdulterationConfirmationTestQCShiftId"]).ToString()).Selected = true;
//}
string DATE = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["AdulterationConfirmationTestQCDate"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["AdulterationConfirmationTestQCDate"].ToString();
if (DATE == "")
{
txtDate.Text = Convert.ToString(DateTime.Now.ToString("yyyy-MM-dd"));
}
else
{
DateTime date1 = Convert.ToDateTime(DATE, System.Globalization.CultureInfo.GetCultureInfo("ur-PK").DateTimeFormat);
txtDate.Text = (Convert.ToDateTime(date1).ToString("yyyy-MM-dd"));
}
dpShiftDetails.ClearSelection();
string ShiftDetails = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["AdulterationConfirmationTestQCShiftId"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["AdulterationConfirmationTestQCShiftId"].ToString();
if (ShiftDetails == "")
{
dpShiftDetails.SelectedIndex = 0;
}
else
{
dpShiftDetails.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["AdulterationConfirmationTestQCShiftId"]).ToString()).Selected = true;
}
txtBatchNo.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["BatchNo"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["BatchNo"].ToString();
txtSugar.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Sugar"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["Sugar"].ToString();
txtStarch.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Starch"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["Starch"].ToString();
txtHydrogenPeroxide.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["HydrogenPeroxide"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["HydrogenPeroxide"].ToString();
txtNeutralizer.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Neutralizer"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["Neutralizer"].ToString();
txtRemarks.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Remarks"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["Remarks"].ToString();
dpStatusDetails.ClearSelection();
string StatusDetails = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["AdulterationConfirmationTestQCStatus"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["AdulterationConfirmationTestQCStatus"].ToString();
if (StatusDetails == "")
{
dpStatusDetails.SelectedIndex = 0;
}
else
{
dpStatusDetails.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["AdulterationConfirmationTestQCStatus"]).ToString()).Selected = true;
}
}
}
public void GetAdulterationConfirmationTastQCDetails()
{
bactqc = new BAdulterationConfirmationTastQC();
DataSet DS = new DataSet();
DS = bactqc.GetAdulterationConfirmationTastQCDetails();
if (!Comman.Comman.IsDataSetEmpty(DS))
{
rpAdulterationConfirmationTestQC.DataSource = DS;
rpAdulterationConfirmationTestQC.DataBind();
}
}
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;
}
}
