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