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; } }