public static decimal GetCampaignTotalpris(int CampaignID) { DBAccess db = new DBAccess(); db.AddInt("ID", CampaignID); decimal res = 0; try { res = Funktioner.ToDecimal(db.ExecuteScalar(_SQLGetTotalpris)); } catch (Exception) { res = 0; } return(res); }
public static decimal GetTotalTilbudsSalgsPris(int TilbudID) { DBAccess db = new DBAccess(); db.AddInt("TilbudID", TilbudID); decimal res = 0; try { res = Funktioner.ToDecimal(db.ExecuteScalar(_SQLTotalTilbudsPris)); } catch (Exception) { res = 0; } return(res); }
public static decimal GetTotalInvoicesSalgsPris(int InvoiceID) { DBAccess db = new DBAccess(); db.AddInt("InvoiceID", InvoiceID); decimal res = 0; try { object obj = db.ExecuteScalar(_SQLTotalInvoicesPris); res = Funktioner.ToDecimal(obj); } catch { res = 0; } return(res); }
public static decimal GetPurchaseOrderTotalPrice(int PurchaseOrderID) { DBAccess db = new DBAccess(); db.AddInt("PurchaseOrderID", PurchaseOrderID); decimal res = 0; try { object obj = db.ExecuteScalar(_SQLPurchaseOrderTotalPris); res = Funktioner.ToDecimal(obj); } catch { res = 0; } return(res); }