/// <summary> /// Code to distribute special cost to all positions based on business logiv /// </summary> /// <param name="ObjEUmlage"></param> /// <returns></returns> public EUmlage UpdateSpecialCost(EUmlage ObjEUmlage) { try { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = SQLCon.Sqlconn(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[P_Upd_SpecialCost]"; cmd.Parameters.Add("@ProjectID", ObjEUmlage.ProjectID); cmd.Parameters.Add("@dt", ObjEUmlage.dtSpecialCost); cmd.Parameters.Add("@UmlageMode", ObjEUmlage.UmlageMode); Object Objreturn = cmd.ExecuteScalar(); } } catch (Exception ex) { if (System.Threading.Thread.CurrentThread.CurrentCulture.Name.ToString() == "de-DE") { throw new Exception("Fehler bei der Verteilung der Generellen Kosten"); } else { throw new Exception("Error while distributing special cost"); } } finally { SQLCon.Close(); } return(ObjEUmlage); }
/// <summary> /// Code to calculate estimated special cost /// </summary> /// <param name="ObjEUmlage"></param> /// <returns></returns> public EUmlage ShowUmlage(EUmlage ObjEUmlage) { try { ObjEUmlage.dtUmlage = new DataTable(); using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = SQLCon.Sqlconn(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[P_Get_ShowUmlage]"; cmd.Parameters.Add("@ProjectId", ObjEUmlage.ProjectID); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(ObjEUmlage.dtUmlage); } } } catch (Exception ex) { if (System.Threading.Thread.CurrentThread.CurrentCulture.Name.ToString() == "de-DE") { throw new Exception("Fehler beim Laden der Umlage"); } else { throw new Exception("Error while retrieving umlage"); } } finally { SQLCon.Close(); } return(ObjEUmlage); }
/// <summary> /// Code to save special cost on database /// </summary> /// <param name="ObjEUmlage"></param> /// <returns></returns> public EUmlage SaveSpecialCost(EUmlage ObjEUmlage) { try { ObjEUmlage = ObjDUmlage.SaveSpecialCost(ObjEUmlage); } catch (Exception ex) { throw; } return(ObjEUmlage); }
/// <summary> /// Code to calculate estimated special cost /// </summary> /// <param name="ObjEUmlage"></param> /// <returns></returns> public EUmlage ShowUmlage(EUmlage ObjEUmlage) { try { ObjEUmlage = ObjDUmlage.ShowUmlage(ObjEUmlage); } catch (Exception ex) { throw; } return(ObjEUmlage); }
/// <summary> /// Code to save special cost in database /// </summary> /// <param name="ObjEUmlage"></param> /// <returns></returns> public EUmlage SaveSpecialCost(EUmlage ObjEUmlage) { try { DataTable dt = new DataTable(); using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = SQLCon.Sqlconn(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[P_Ins_SpecialCost]"; cmd.Parameters.Add("@ProjectID", ObjEUmlage.ProjectID); cmd.Parameters.Add("@dt", ObjEUmlage.dtSpecialCost); cmd.Parameters.Add("@UmlageMode", ObjEUmlage.UmlageMode); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) da.Fill(dt); if (dt != null && dt.Rows.Count > 0) { decimal DValue = 0; if (decimal.TryParse(Convert.ToString(dt.Rows[0]["UmlageFactor"]), out DValue)) { ObjEUmlage.UmlageFactor = DValue; } if (decimal.TryParse(Convert.ToString(dt.Rows[0]["UmlageValue"]), out DValue)) { ObjEUmlage.UmlageValue = DValue; } } } } catch (Exception ex) { if (System.Threading.Thread.CurrentThread.CurrentCulture.Name.ToString() == "de-DE") { throw new Exception("Fehler beim Speichern der Generalkosten"); } else { throw new Exception("Error while saving special cost"); } } finally { SQLCon.Close(); } return(ObjEUmlage); }
/// <summary> /// Code to fetch special cost of a project /// </summary> /// <param name="ObjEUmlage"></param> /// <returns></returns> public EUmlage GetSpecialCost(EUmlage ObjEUmlage) { try { ObjEUmlage.dtSpecialCost = new DataTable(); DataSet ds = new DataSet(); using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = SQLCon.Sqlconn(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[P_Get_SpecialCost]"; cmd.Parameters.Add("@ProjectID", ObjEUmlage.ProjectID); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(ds); } if (ds != null && ds.Tables.Count > 0) { ObjEUmlage.dtSpecialCost = ds.Tables[0]; if (ds.Tables.Count > 1 && ds.Tables[1].Rows.Count > 0) { int.TryParse(Convert.ToString(ds.Tables[1].Rows[0][0]), out ObjEUmlage.UmlageMode); } } } } 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 special cost"); } } finally { SQLCon.Close(); } return(ObjEUmlage); }