/// <summary>
/// Code to Get Form blatt articles mapping
/// </summary>
/// <param name="ObjEFormBlatt"></param>
/// <returns></returns>
public EFormBlatt GetFormBlattMapping(EFormBlatt ObjEFormBlatt)
{
try
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = SQLCon.Sqlconn();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[P_Get_FormBlattMapping]";
cmd.Parameters.Add("@ProjectID", ObjEFormBlatt.ProjectID);
Object ObjReturn = cmd.ExecuteScalar();
if (!string.IsNullOrEmpty(Convert.ToString(ObjReturn)))
{
throw new Exception("Bitte weisen Sie dem Kostentyp 'Nachunternehmerleistungen/Stoffkosten' Warengruppen-/arten zu");
}
}
}
catch (Exception ex)
{
throw;
}
finally
{
SQLCon.Close();
}
return(ObjEFormBlatt);
}
private void btnSaveFormBlattArticles_Click(object sender, EventArgs e)
{
try
{
DataView dvArticles = null;
DataTable Temp = ObjEFormBlatt.dtBlattArticles.Copy();
Temp.Columns.Remove("WGDescription");
Temp.Columns.Remove("WADescription");
DataTable dt = Temp;
if (dt != null)
{
dvArticles = dt.DefaultView;
dvArticles.RowFilter = "IsAssigned = '" + true + "'";
}
if (ObjEFormBlatt == null)
{
ObjEFormBlatt = new EFormBlatt();
}
if (ObjBFormBlatt == null)
{
ObjBFormBlatt = new BFormBlatt();
}
ObjEFormBlatt = ObjBFormBlatt.Save_FormBlattArticles(ObjEFormBlatt, dvArticles.ToTable());
if (Utility._IsGermany == true)
{
frmOTTOPro.UpdateStatus("Artikelangaben für das Formblatt erfolgreich gespeichert");
}
else
{
frmOTTOPro.UpdateStatus("FormBlatt Articles Saved Successfully");
}
}
catch (Exception ex) { Utility.ShowError(ex); }
}
/// <summary>
/// Code to fetch cost types from database and Bind to combobox
/// </summary>
private void BindBlattType()
{
try
{
if (ObjEFormBlatt == null)
{
ObjEFormBlatt = new EFormBlatt();
}
if (ObjBFormBlatt == null)
{
ObjBFormBlatt = new BFormBlatt();
}
ObjBFormBlatt.Get_FormBlattTypes(ObjEFormBlatt);
if (ObjEFormBlatt.dtBlattTypes != null)
{
cmbFormBlatttypes.DataSource = ObjEFormBlatt.dtBlattTypes;
cmbFormBlatttypes.ValueMember = "LookupID";
cmbFormBlatttypes.DisplayMember = "Value";
cmbFormBlatttypes.SelectedIndex = -1;
}
}
catch (Exception ex)
{
Utility.ShowError(ex);
}
}
/// <summary>
/// Code to Get Form blatt articles mapping
/// </summary>
/// <param name="ObjEFormBlatt"></param>
/// <returns></returns>
public EFormBlatt GetFormBlattMapping(EFormBlatt ObjEFormBlatt)
{
try
{
ObjEFormBlatt = ObjDFormBlatt.GetFormBlattMapping(ObjEFormBlatt);
}
catch (Exception ex)
{
throw;
}
return(ObjEFormBlatt);
}
/// <summary>
/// Code to save Cost type mapping with articles
/// </summary>
/// <param name="ObjEFormBlatt"></param>
/// <param name="_dt"></param>
/// <returns></returns>
public EFormBlatt Save_FormBlattArticles(EFormBlatt ObjEFormBlatt, DataTable _dt)
{
try
{
ObjEFormBlatt = ObjDFormBlatt.Save_FormBlattArticles(ObjEFormBlatt, _dt);
}
catch (Exception ex)
{
throw;
}
return(ObjEFormBlatt);
}
/// <summary>
/// Code to get Articles based on cost type mapping
/// </summary>
/// <param name="ObjEFormBlatt"></param>
/// <returns></returns>
public EFormBlatt Get_FormBlattArticles(EFormBlatt ObjEFormBlatt)
{
try
{
ObjEFormBlatt = ObjDFormBlatt.Get_FormBlattArticles(ObjEFormBlatt);
}
catch (Exception ex)
{
throw;
}
return(ObjEFormBlatt);
}
/// <summary>
/// Code to get Cost types
/// </summary>
/// <param name="ObjEFormBlatt"></param>
/// <returns></returns>
public EFormBlatt Get_FormBlattTypes(EFormBlatt ObjEFormBlatt)
{
try
{
ObjEFormBlatt = ObjDFormBlatt.GetFormBlatttype(ObjEFormBlatt);
}
catch (Exception ex)
{
throw;
}
return(ObjEFormBlatt);
}
/// <summary>
/// Code to get Formblatt 221 table 2 values
/// </summary>
/// <param name="ObjEFormBlatt"></param>
/// <returns></returns>
public EFormBlatt Get_tbl221_2(EFormBlatt ObjEFormBlatt)
{
try
{
ObjEFormBlatt = ObjDFormBlatt.Get_tbl221_2(ObjEFormBlatt);
}
catch (Exception ex)
{
throw;
}
return(ObjEFormBlatt);
}
/// <summary>
/// Code to get Articles based on cost type mapping
/// </summary>
/// <param name="ObjEFormBlatt"></param>
/// <returns></returns>
public EFormBlatt Get_FormBlattArticles(EFormBlatt ObjEFormBlatt)
{
DataSet dsFormBlattArticle = new DataSet();
try
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = SQLCon.Sqlconn();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[P_Get_ArticleForFormBlatt]";
cmd.Parameters.Add("@CostTypeID", ObjEFormBlatt.LookUpID);
cmd.Parameters.Add("@ProjectID", ObjEFormBlatt.ProjectID);
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(dsFormBlattArticle);
}
if (dsFormBlattArticle != null && dsFormBlattArticle.Tables.Count > 0)
{
ObjEFormBlatt.dtBlattArticles = dsFormBlattArticle.Tables[0];
}
}
}
catch (Exception ex)
{
if (System.Threading.Thread.CurrentThread.CurrentCulture.Name.ToString() == "de-DE")
{
throw new Exception("Ein Fehler ist aufgetreten beim Laden des Formulars (Artikel)");
}
else
{
throw new Exception("Error Occured While Retreiving FormBlatt Articles");
}
}
finally
{
SQLCon.Close();
}
return(ObjEFormBlatt);
}
/// <summary>
/// Code to get Formblatt 221 table 2 values
/// </summary>
/// <param name="ObjEFormBlatt"></param>
/// <returns></returns>
public EFormBlatt Get_tbl221_2(EFormBlatt ObjEFormBlatt)
{
try
{
DataSet ds = new DataSet();
ObjEFormBlatt.dtBlatt221_2 = new DataTable();
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = SQLCon.Sqlconn();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[P_Get_tbl221_2]";
cmd.Parameters.Add("@ProjectID", ObjEFormBlatt.ProjectID);
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds);
}
if (ds != null && ds.Tables.Count > 0)
{
ObjEFormBlatt.dtBlatt221_2 = ds.Tables[0];
}
}
}
catch (Exception ex)
{
if (System.Threading.Thread.CurrentThread.CurrentCulture.Name.ToString() == "de-DE")
{
// throw new Exception("Fehler beim Laden der Generellen Kosten");
}
else
{
throw new Exception("Error while retrieving form blatt");
}
}
finally
{
SQLCon.Close();
}
return(ObjEFormBlatt);
}
/// <summary>
/// Code to get Cost types
/// </summary>
/// <param name="ObjEFormBlatt"></param>
/// <returns></returns>
public EFormBlatt GetFormBlatttype(EFormBlatt ObjEFormBlatt)
{
DataSet dsFormBlatt = new DataSet();
try
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = SQLCon.Sqlconn();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[P_Get_FormBlattType]";
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(dsFormBlatt);
}
if (dsFormBlatt != null && dsFormBlatt.Tables.Count > 0)
{
ObjEFormBlatt.dtBlattTypes = dsFormBlatt.Tables[0];
}
}
}
catch (Exception ex)
{
if (System.Threading.Thread.CurrentThread.CurrentCulture.Name.ToString() == "de-DE")
{
throw new Exception("Ein Fehler ist aufgetreten beim Laden des Formulars (Kostentypen)");
}
else
{
throw new Exception("Error Occured While Retreiving Access FormBlatt Types");
}
}
finally
{
SQLCon.Close();
}
return(ObjEFormBlatt);
}
/// <summary>
/// Code to save Cost type mapping with articles
/// </summary>
/// <param name="ObjEFormBlatt"></param>
/// <param name="_dt"></param>
/// <returns></returns>
public EFormBlatt Save_FormBlattArticles(EFormBlatt ObjEFormBlatt, DataTable _dt)
{
DataSet dsFormBlattArticle = new DataSet();
try
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = SQLCon.Sqlconn();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[P_Ins_FormBlattarticles]";
cmd.Parameters.Add("@LookupID", ObjEFormBlatt.LookUpID);
cmd.Parameters.Add("@dtBlattArticles", _dt);
cmd.Parameters.Add("@ProjectID", ObjEFormBlatt.ProjectID);
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(dsFormBlattArticle);
}
}
}
catch (Exception ex)
{
if (System.Threading.Thread.CurrentThread.CurrentCulture.Name.ToString() == "de-DE")
{
throw new Exception("Ein Fehler ist aufgetreten beim Speichern des Formulars");
}
else
{
throw new Exception("Error Occured While Saving Titles Articles");
}
}
finally
{
SQLCon.Close();
}
return(ObjEFormBlatt);
}
private void cmbFormBlatttypes_SelectionChangeCommitted(object sender, EventArgs e)
{
try
{
if (ObjEFormBlatt == null)
{
ObjEFormBlatt = new EFormBlatt();
}
if (ObjBFormBlatt == null)
{
ObjBFormBlatt = new BFormBlatt();
}
if (cmbFormBlatttypes.Text != string.Empty)
{
if (int.TryParse(Convert.ToString(cmbFormBlatttypes.SelectedValue), out _FormBlattTyPeID))
{
if (_FormBlattTyPeID > 0)
{
gcFormBlattArticles.DataSource = null;
ObjEFormBlatt.LookUpID = _FormBlattTyPeID;
ObjEFormBlatt.ProjectID = ObjEPosition.ProjectID;
ObjBFormBlatt.Get_FormBlattArticles(ObjEFormBlatt);
if (ObjEFormBlatt.dtBlattArticles != null)
{
gcFormBlattArticles.DataSource = ObjEFormBlatt.dtBlattArticles;
gvFormBlattArticles.BestFitColumns();
}
}
}
}
}
catch (Exception ex)
{
Utility.ShowError(ex);
}
}
