/// <summary> /// Code to Save report settings /// </summary> /// <param name="ObjEObject"></param> public DataSet SaveReportSetting(EReportDesign ObjEReportDesign) { DataSet dsReportSetting = new DataSet(); try { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = SQLCon.Sqlconn(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[P_Ins_ReportSetting]"; cmd.Parameters.AddWithValue("@LVPosition", ObjEReportDesign.LVPosition); cmd.Parameters.AddWithValue("@Fabrikat", ObjEReportDesign.Fabrikat); cmd.Parameters.AddWithValue("@ArticleNr", ObjEReportDesign.ArticlNr); cmd.Parameters.AddWithValue("@LieferantMA", ObjEReportDesign.Lieferant); cmd.Parameters.AddWithValue("@LangText", ObjEReportDesign.LangText); cmd.Parameters.AddWithValue("@KurzText", ObjEReportDesign.KurzText); cmd.Parameters.AddWithValue("@Sender", ObjEReportDesign.Sender); cmd.Parameters.AddWithValue("@Menge", ObjEReportDesign.Menge); cmd.Parameters.AddWithValue("@GB", ObjEReportDesign.GB); cmd.Parameters.AddWithValue("@EP", ObjEReportDesign.EP); cmd.Parameters.AddWithValue("@Prices", ObjEReportDesign.Prices); cmd.Parameters.AddWithValue("@MAMO", ObjEReportDesign.MAMO); cmd.Parameters.AddWithValue("@KurzAndLangText", ObjEReportDesign.KurzAnLangText); cmd.Parameters.AddWithValue("@HPos", ObjEReportDesign.HPos); cmd.Parameters.AddWithValue("@ABPos", ObjEReportDesign.ABPos); cmd.Parameters.AddWithValue("@BAPos", ObjEReportDesign.BAPos); cmd.Parameters.AddWithValue("@VRPos", ObjEReportDesign.VRPos); cmd.Parameters.AddWithValue("@UBPos", ObjEReportDesign.UBPos); cmd.Parameters.AddWithValue("@NonePos", ObjEReportDesign.NonePos); cmd.Parameters.AddWithValue("@WithDetKZ", ObjEReportDesign.WithDetailKZ); cmd.Parameters.AddWithValue("@WithTitlePrices", ObjEReportDesign.WithTitlePrices); cmd.Parameters.AddWithValue("@OnheMengeZeroPositions", ObjEReportDesign.OnheMengeZeroPositions); cmd.Parameters.AddWithValue("@OnheMontagePrice", ObjEReportDesign.OnheMontagePrice); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(dsReportSetting); } } } catch (Exception ex) { if (System.Threading.Thread.CurrentThread.CurrentCulture.Name.ToString() == "de-DE") { throw new Exception("Fehler beim Speichern der Daten"); } else { throw new Exception("Error while saving the data"); } } finally { SQLCon.Close(); } return(dsReportSetting); }
/// <summary> /// Code to Save report settings /// </summary> /// <param name="ObjEObject"></param> public void SaveReportSetting(EReportDesign ObjEObject) { try { if (ObjEObject != null) { ObjDReportDesign.SaveReportSetting(ObjEObject); } } catch (Exception ex) { throw; } }
/// <summary> /// Code to fetch report settings from database /// </summary> /// <param name="ObjEObject"></param> /// <returns></returns> public DataSet GetReportSettings(EReportDesign ObjEObject) { DataSet dsReportSetting = new DataSet(); try { if (ObjEObject != null) { dsReportSetting = ObjDReportDesign.GetReportSettings(ObjEObject); } } catch (Exception ex) { throw; } return(dsReportSetting); }
/// <summary> /// Code to fetch report settings from database /// </summary> /// <param name="ObjEObject"></param> /// <returns></returns> public DataSet GetReportSettings(EReportDesign ObjEReportDesign) { DataSet dsReportSetting = new DataSet(); try { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = SQLCon.Sqlconn(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[P_Get_ReportSetting]"; using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(dsReportSetting); } if (dsReportSetting != null && dsReportSetting.Tables.Count > 0) { ObjEReportDesign.dtReportSettings = dsReportSetting.Tables[0]; } } } catch (Exception ex) { if (System.Threading.Thread.CurrentThread.CurrentCulture.Name.ToString() == "de-DE") { throw new Exception("Fehler beim Laden der Daten"); } else { throw new Exception("Error Occured While Retreiving the data"); } } finally { SQLCon.Close(); } return(dsReportSetting); }
private void frmReportSetting_Load(object sender, EventArgs e) { try { if (ObjBReport == null) { ObjBReport = new BReportDesign(); } if (ObjEReport == null) { ObjEReport = new EReportDesign(); } ObjBReport.GetReportSettings(ObjEReport); if (ObjEReport.dtReportSettings.Rows.Count > 0) { BindData(); } FillLVSection(); txtReportName.Text = "ANGEBOT"; dtpReportDate.DateTime = DateTime.Now; cmbLVSection.EditValue = null; } catch (Exception ex) { Utility.ShowError(ex); } }
private void btnSave_Click(object sender, EventArgs e) { try { if (ObjBReport == null) { ObjBReport = new BReportDesign(); } if (ObjEReport == null) { ObjEReport = new EReportDesign(); } ParseReportSettings(); ObjBReport.SaveReportSetting(ObjEReport); if (_ProjectID > 0) { DataTable dtPos = new DataTable(); dtPos.Columns.Add("FromPos"); dtPos.Columns.Add("ToPos"); if (radioGroupSelection.SelectedIndex == 0) { this.Hide(); if (chkMAMO.Checked) { GenerateReportWithputMAMO("Complete", dtPos, cmbLVSection.Text); } else if (chkOnheMontagePrice.Checked) { GenerateReportWithMinutes("Complete", dtPos, cmbLVSection.Text); } else { GenerateReport("Complete", dtPos, cmbLVSection.Text); } this.Close(); } else if (radioGroupSelection.SelectedIndex == 1) { if (gvAddRemovePositions.RowCount == 0) { if (Utility._IsGermany == true) { XtraMessageBox.Show("Bitte machen Sie VON / BIS Angaben."); } else { XtraMessageBox.Show("Please Add From and To values."); } return; } string tfrom = null; string tTo = null; foreach (DataGridViewRow dr in gvAddRemovePositions.Rows) { DataRow drPos = dtPos.NewRow(); tfrom = Convert.ToString(dr.Cells[0].Value); tTo = Convert.ToString(dr.Cells[1].Value); string _fromParent = string.Empty; string _ToParent = string.Empty; if (tfrom.Contains(".")) { _fromParent = tfrom.Substring(0, tfrom.IndexOf('.')); } if (tTo.Contains(".")) { _ToParent = tTo.Substring(0, tTo.IndexOf('.')); } if (_fromParent != _ToParent) { if (Utility._IsGermany) { throw new Exception("Bitte geben Sie den gleichen Parent-Level ein..!"); } else { throw new Exception("Please enter the same Parent level..!"); } } drPos["fromPos"] = Utility.PrepareOZ(tfrom, stRaster); drPos["toPos"] = Utility.PrepareOZ(tTo, stRaster); dtPos.Rows.Add(drPos); } this.Hide(); if (chkMAMO.Checked) { GenerateReportWithputMAMO("Title", dtPos, cmbLVSection.Text); } else if (chkOnheMontagePrice.Checked) { GenerateReportWithMinutes("Title", dtPos, cmbLVSection.Text); } else { GenerateReport("Title", dtPos, cmbLVSection.Text); } this.Close(); } else if (radioGroupSelection.SelectedIndex == 2) { if (string.IsNullOrEmpty(cmbLVSection.Text)) { throw new Exception("Please select atleast one LV Section"); } this.Hide(); if (chkMAMO.Checked) { GenerateReportWithputMAMO("LVSection", dtPos, cmbLVSection.Text); } else if (chkOnheMontagePrice.Checked) { GenerateReportWithMinutes("LVSection", dtPos, cmbLVSection.Text); } else { GenerateReport("LVSection", dtPos, cmbLVSection.Text); } this.Close(); } } } catch (Exception ex) { Utility.ShowError(ex); } }