public void GetMilkProductsTestBeforePackingQCDetails(int RMRId) { DataSet DS = new DataSet(); bmptbpqc = new BMilkProductsTestBeforePackingQC(); DS = bmptbpqc.GetMilkProductsTestBeforePackingQCDetailsById(RMRId); if (!Comman.Comman.IsDataSetEmpty(DS)) { string DATE = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["MilkProductsTestBeforePackingQCDate"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["MilkProductsTestBeforePackingQCDate"].ToString(); //sky if (DATE == "") { txtDate.Text = Convert.ToString(DateTime.Now.ToString("yyy-MM-dd")); } else { DateTime date1 = Convert.ToDateTime(DATE, System.Globalization.CultureInfo.GetCultureInfo("ur-PK").DateTimeFormat); txtDate.Text = (Convert.ToDateTime(date1).ToString("yyyy-MM-dd")); } txtBatchNo.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["BatchNo"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["BatchNo"].ToString(); dpShiftDetails.ClearSelection(); string Shift = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["MilkProductsTestBeforePackingQCShiftId"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["MilkProductsTestBeforePackingQCShiftId"].ToString(); if (Shift == "") { dpShiftDetails.SelectedIndex = 0; } else { dpShiftDetails.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["MilkProductsTestBeforePackingQCShiftId"]).ToString()).Selected = true; } txtparticular.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Particular"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["Particular"].ToString(); txtQuantity.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Quantity"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["Quantity"].ToString(); txtTestName.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["TestName"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["TestName"].ToString(); txtResult.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Result"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["Result"].ToString(); txtRemarks.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Remarks"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["Remarks"].ToString(); dpQCStatusId.ClearSelection(); string QCStatusId = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["MilkProdTestBeforePackingQCStatusId"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["MilkProdTestBeforePackingQCStatusId"].ToString(); if (QCStatusId == "") { dpQCStatusId.SelectedIndex = 0; } else { dpQCStatusId.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["MilkProdTestBeforePackingQCStatusId"]).ToString()).Selected = true; } } }
protected void btnAdd_Click(object sender, EventArgs e) { { mmptbpqc = new MMilkProductsTestBeforePackingQC(); bmptbpqc = new BMilkProductsTestBeforePackingQC(); int Result = 0; mmptbpqc.MilkProductsTestBeforePackingQCId = 0; mmptbpqc.RMRId = string.IsNullOrEmpty(hId.Value) ? 0 : Convert.ToInt32(hId.Value); mmptbpqc.MilkProductsTestBeforePackingQCDate = Convert.ToDateTime(txtDate.Text.ToString()); mmptbpqc.MilkProductsTestBeforePackingQCShiftId = Convert.ToInt32(dpShiftDetails.SelectedItem.Value); mmptbpqc.Particular = string.IsNullOrEmpty(txtparticular.Text) ? string.Empty : txtparticular.Text; mmptbpqc.Quantity = string.IsNullOrEmpty(txtQuantity.Text) ? 0 : Convert.ToDouble(txtQuantity.Text); mmptbpqc.TestName = string.IsNullOrEmpty(txtTestName.Text) ? string.Empty : txtTestName.Text; mmptbpqc.Result = string.IsNullOrEmpty(txtResult.Text) ? string.Empty : txtResult.Text; mmptbpqc.Remarks = string.IsNullOrEmpty(txtRemarks.Text) ? string.Empty : txtRemarks.Text; mmptbpqc.MilkProdTestBeforePackingQCStatusId = Convert.ToInt32(dpQCStatusId.SelectedItem.Value); mmptbpqc.flag = "Insert"; Result = bmptbpqc.milkproductdata(mmptbpqc); if (Result > 0) { divDanger.Visible = false; divwarning.Visible = false; divSusccess.Visible = true; ScriptManager.RegisterStartupScript(this, this.GetType(), "sel3", "$('#bx1').addClass('collapsed-box');", true); //string dates; //dates = string.IsNullOrEmpty(txtSearchDate.Text) ? string.Empty : Convert.ToDateTime(txtSearchDate.Text).ToString("dd-MM-yyyy"); //GetMilkProductsTestBeforePackingQCDetails(dates); RMRecieve R = new RMRecieve(); R.RMRDate = Convert.ToDateTime(txtSearchDate.Text); GetMilkProductsTestBeforePackingQCDetails(R); uprouteList.Update(); lblSuccess.Text = "Milk Packing QC Data Added Successfully"; pnlError.Update(); } else { divDanger.Visible = false; divwarning.Visible = true; divSusccess.Visible = false; lblSuccess.Text = "Something went wrong plz contact site admin"; pnlError.Update(); } //return Result; } }
public void GetMilkProductsTestBeforePackingQCDetails(RMRecieve R) { bmptbpqc = new BMilkProductsTestBeforePackingQC(); DataSet DS = new DataSet(); DS = bmptbpqc.GetMilkProductsTestBeforePackingQCDetails(R); if (!Comman.Comman.IsDataSetEmpty(DS)) { rpMilkBeforePackingQC.DataSource = DS; rpMilkBeforePackingQC.DataBind(); } else { rpMilkBeforePackingQC.DataSource = DS; rpMilkBeforePackingQC.DataBind(); } }
public void GetMilkProductsTestBeforePackingQCDetails(string dates) { bmptbpqc = new BMilkProductsTestBeforePackingQC(); DataSet DS = new DataSet(); DS = bmptbpqc.GetMilkProductsTestBeforePackingQCDetails(dates); if (!Comman.Comman.IsDataSetEmpty(DS)) { rpMilkBeforePackingQC.DataSource = DS; rpMilkBeforePackingQC.DataBind(); } else { DS.Clear(); rpMilkBeforePackingQC.DataSource = DS; rpMilkBeforePackingQC.DataBind(); } }