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