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