protected void btnUpdateProductindetail_Click(object sender, EventArgs e) { stdmdata = new MStandardization(); stdbdata = new BStandardization(); int Result = 0; stdmdata.RMRId = string.IsNullOrEmpty(hId.Value) ? 0 : Convert.ToInt32(hId.Value); stdmdata.StandardDate = DateTime.Now.ToString(); stdmdata.StdShiftId = Convert.ToInt32(dpShiftDetails.SelectedItem.Value); stdmdata.SiloNo = string.IsNullOrEmpty(txtSiloNo.Text) ? string.Empty : txtSiloNo.Text; stdmdata.RCMQuantity = string.IsNullOrEmpty(txtRCMQty.Text) ? 0 : Convert.ToDouble(txtRCMQty.Text); stdmdata.StandardizationStartTime = txtStandardizationStartTime.Text; stdmdata.StandardizationEndTime = txtStandardizationEndTime.Text; stdmdata.CuttingMilkQuantity = string.IsNullOrEmpty(txtCuttingMilkQuantity.Text) ? 0 : Convert.ToDouble(txtCuttingMilkQuantity.Text); stdmdata.CuttingMilkFAT = string.IsNullOrEmpty(txtCuttingMilkFat.Text) ? 0 : Convert.ToDouble(txtCuttingMilkFat.Text); stdmdata.CuttingMilkSNF = string.IsNullOrEmpty(txtCuttingMilkSnf.Text) ? 0 : Convert.ToDouble(txtCuttingMilkSnf.Text); stdmdata.Skim = string.IsNullOrEmpty(txtSkim.Text) ? 0 : Convert.ToDouble(txtSkim.Text); stdmdata.SkimFAT = string.IsNullOrEmpty(txtSkimFat.Text) ? 0 : Convert.ToDouble(txtSkimFat.Text); stdmdata.SkimSNF = string.IsNullOrEmpty(txtSkimSnf.Text) ? 0 : Convert.ToDouble(txtSkimSnf.Text); stdmdata.RCM = string.IsNullOrEmpty(txtRcm.Text) ? 0 : Convert.ToDouble(txtRcm.Text); stdmdata.SMP = string.IsNullOrEmpty(txtRcm.Text) ? 0 : Convert.ToDouble(txtRcm.Text); stdmdata.CreamAdd = string.IsNullOrEmpty(txtCreamAdd.Text) ? 0 : Convert.ToDouble(txtCreamAdd.Text); stdmdata.CreamProduced = string.IsNullOrEmpty(txtCreamAdd.Text) ? 0 : Convert.ToDouble(txtCreamAdd.Text); stdmdata.Remarks = txtRemarks.Text; stdmdata.StandardizationStatusId = Convert.ToInt32(dpStandardDone.SelectedItem.Value); //stdmdata.Custom1 = txtCustom1.Text; //stdmdata.Custom2 = txtCustom2.Text; //stdmdata.Custom3 = txtCustom3.Text; //stdmdata.Custom4 = txtCustom4.Text; //stdmdata.Custom5 = txtCustom5.Text; stdmdata.flag = "Update"; Result = stdbdata.StandardizationData(stdmdata); if (Result > 0) { divDanger.Visible = false; divwarning.Visible = false; divSusccess.Visible = true; lblSuccess.Text = "Data Updated Successfully"; ScriptManager.RegisterStartupScript(this, this.GetType(), "sel3", "$('#bx1').addClass('collapsed-box');", true); pnlError.Update(); //string dates; //dates = string.IsNullOrEmpty(txtSearchDate.Text) ? string.Empty : Convert.ToDateTime(txtSearchDate.Text).ToString("dd-MM-yyyy"); RMRecieve R = new RMRecieve(); R.RMRDate = Convert.ToDateTime(txtSearchDate.Text); GetStandardizationDetails(R); uprouteList.Update(); // ClearTextbox(); } else { divDanger.Visible = false; divwarning.Visible = true; divSusccess.Visible = false; lblSuccess.Text = "Something went wrong plz contact site admin"; pnlError.Update(); } }
public void GetStandardizationDetails(string dates) { stdbdata = new BStandardization(); DataSet DS = new DataSet(); DS = stdbdata.GetStandardizationDetails(dates); if (!Comman.Comman.IsDataSetEmpty(DS)) { rpStandardizationList.DataSource = DS; rpStandardizationList.DataBind(); } else { DS.Clear(); rpStandardizationList.DataSource = DS; rpStandardizationList.DataBind(); } }
public void GetStandardizationDetails(RMRecieve R) { stdbdata = new BStandardization(); DataSet DS = new DataSet(); DS = stdbdata.GetStandardizationDetails(R); if (!Comman.Comman.IsDataSetEmpty(DS)) { rpStandardizationList.DataSource = DS; rpStandardizationList.DataBind(); } else if (DS.Tables[0].Rows.Count == 0) { //this.BindRepeater(dt); rpStandardizationList.DataSource = DS; rpStandardizationList.DataBind(); } }
protected void btnAddProductionInfo_Click(object sender, EventArgs e) { stdmdata = new MStandardization(); stdbdata = new BStandardization(); int Result = 0; stdmdata.StdId = 0; stdmdata.RMRId = string.IsNullOrEmpty(hId.Value) ? 0 : Convert.ToInt32(hId.Value); foreach (RepeaterItem item in rpStandardizationList.Items) { HiddenField hdfID = item.FindControl("hfQualityId") as HiddenField; if (hdfID != null) { stdmdata.QualityId = string.IsNullOrEmpty(hdfID.Value) ? 0 : Convert.ToInt32(hdfID.Value); } } stdmdata.StandardDate = DateTime.Now.ToString(); stdmdata.StdShiftId = Convert.ToInt32(dpShiftDetails.SelectedItem.Value); stdmdata.SiloNo = string.IsNullOrEmpty(txtSiloNo.Text) ? string.Empty : txtSiloNo.Text; stdmdata.RCMQuantity = string.IsNullOrEmpty(txtRCMQty.Text) ? 0 : Convert.ToDouble(txtRCMQty.Text); stdmdata.StandardizationStartTime = string.IsNullOrEmpty(txtStandardizationStartTime.Text) ? string.Empty : txtStandardizationStartTime.Text; stdmdata.StandardizationEndTime = string.IsNullOrEmpty(txtStandardizationEndTime.Text) ? string.Empty : txtStandardizationEndTime.Text; stdmdata.CuttingMilkQuantity = string.IsNullOrEmpty(txtCuttingMilkQuantity.Text) ? 0 : Convert.ToDouble(txtCuttingMilkQuantity.Text); stdmdata.CuttingMilkFAT = string.IsNullOrEmpty(txtCuttingMilkFat.Text) ? 0 : Convert.ToDouble(txtCuttingMilkFat.Text); stdmdata.CuttingMilkSNF = string.IsNullOrEmpty(txtCuttingMilkSnf.Text) ? 0 : Convert.ToDouble(txtCuttingMilkSnf.Text); stdmdata.Skim = string.IsNullOrEmpty(txtSkim.Text) ? 0 : Convert.ToDouble(txtSkim.Text); stdmdata.SkimFAT = string.IsNullOrEmpty(txtSkimFat.Text) ? 0 : Convert.ToDouble(txtSkimFat.Text); stdmdata.SkimSNF = string.IsNullOrEmpty(txtSkimSnf.Text) ? 0 : Convert.ToDouble(txtSkimSnf.Text); stdmdata.RCM = string.IsNullOrEmpty(txtRcm.Text) ? 0 : Convert.ToDouble(txtRcm.Text); stdmdata.SMP = string.IsNullOrEmpty(txtRcm.Text) ? 0 : Convert.ToDouble(txtRcm.Text); stdmdata.CreamAdd = string.IsNullOrEmpty(txtCreamAdd.Text) ? 0 : Convert.ToDouble(txtCreamAdd.Text); stdmdata.CreamProduced = string.IsNullOrEmpty(txtCreamAdd.Text) ? 0 : Convert.ToDouble(txtCreamAdd.Text); //stdmdata.TotalQuantity = string.IsNullOrEmpty(txtTotalQuantity.Text) ? 0 : Convert.ToDouble(txtTotalQuantity.Text); //stdmdata.TypeOfMilk = string.IsNullOrEmpty(txtTypeOfMilk.Text) ? string.Empty : txtTypeOfMilk.Text; stdmdata.Remarks = string.IsNullOrEmpty(txtRemarks.Text) ? string.Empty : txtRemarks.Text; stdmdata.StandardizationStatusId = Convert.ToInt32(dpStandardDone.SelectedItem.Value); stdmdata.flag = "Insert"; Result = stdbdata.StandardizationData(stdmdata); if (Result > 0) { divDanger.Visible = false; divwarning.Visible = false; divSusccess.Visible = true; lblSuccess.Text = "Data Added Successfully"; ScriptManager.RegisterStartupScript(this, this.GetType(), "sel3", "$('#bx1').addClass('collapsed-box');", true); pnlError.Update(); string dates; dates = string.IsNullOrEmpty(txtSearchDate.Text) ? string.Empty : Convert.ToDateTime(txtSearchDate.Text).ToString("dd-MM-yyyy"); GetStandardizationDetails(dates); uprouteList.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 GetStandardizationDetails(int RMRId) { DataSet DS = new DataSet(); stdbdata = new BStandardization(); DS = stdbdata.GetStandardizationDetailsbyId(RMRId); if (!Comman.Comman.IsDataSetEmpty(DS)) { string DATE = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["QualityDate"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["QualityDate"].ToString(); //sky 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(); txtSiloNo.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["SiloNo"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["SiloNo"].ToString(); txtRCMQty.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["RCMQuantity"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["RCMQuantity"].ToString(); dpShiftDetails.ClearSelection(); try { dpShiftDetails.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["StdShiftId"]).ToString()).Selected = true; } catch (InvalidCastException) { dpShiftDetails.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["QualityShiftId"]).ToString()).Selected = true; } txtFat.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Fat"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["Fat"].ToString(); txtSnf.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["SNF"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["SNF"].ToString(); txtRCMQty.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["RCMQuantity"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["RCMQuantity"].ToString(); if (DS.Tables[0].Rows[0]["StandardizationStartTime"].ToString() == "") { txtStandardizationStartTime.Text = Convert.ToString(DateTime.Now.ToString("HH:mm")); } else { txtStandardizationStartTime.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["StandardizationStartTime"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["StandardizationStartTime"].ToString(); } txtStandardizationEndTime.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["StandardizationEndTime"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["StandardizationEndTime"].ToString(); txtCuttingMilkQuantity.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["CuttingMilkQuantity"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["CuttingMilkQuantity"].ToString(); txtCuttingMilkFat.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["CuttingMilkFat"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["CuttingMilkFat"].ToString(); txtCuttingMilkSnf.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["CuttingMilkSNF"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["CuttingMilkSNF"].ToString(); txtSkim.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Skim"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["Skim"].ToString(); txtSkimFat.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["SkimFAT"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["SkimFAT"].ToString(); txtSkimSnf.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["SkimSNF"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["SkimSNF"].ToString(); txtRcm.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["RCM"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["RCM"].ToString(); txtSmpAdd.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["SMP"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["SMP"].ToString(); txtCreamAdd.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["CreamAdd"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["CreamAdd"].ToString(); txtCreamProduced.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["CreamProduced"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["CreamProduced"].ToString(); txtTotalQuantity.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Qty"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["Qty"].ToString(); txtTypeOfMilk.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["TypeOfMilk"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["TypeOfMilk"].ToString(); txtRemarks.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Remarks"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["Remarks"].ToString(); if (DS.Tables[0].Rows[0]["StatusName"].ToString() != null) { txtStatus.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["StatusName"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["StatusName"].ToString(); } else { txtStatus.Text = dpStandardDone.SelectedItem.Text; } dpStandardDone.ClearSelection(); try { if (Convert.ToInt32(DS.Tables[0].Rows[0]["StandardizationStatusId"]).ToString() != "") { dpStandardDone.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["StandardizationStatusId"]).ToString()).Selected = true; } } catch (InvalidCastException) { dpStandardDone.SelectedIndex = 2; } } }