public static int Update(InvoiceHeader c)
{
DBAccess db = new DBAccess();
db.AddInt("ID", c.ID);
AddParms(ref db, c);
int retval = db.ExecuteNonQuery(_SQLUpdate);
AddLog(Status: "InvoiceHeader", Logtext: string.Format("Update InvoiceHeader: ID:{0}", c.ID), Metode: "Update");
return(retval);
}
public static int Update(tilbudHeader c)
{
DBAccess db = new DBAccess();
db.AddInt("ID", c.ID);
AddParms(ref db, c);
int retval = db.ExecuteNonQuery(_SQLUpdate);
AddLog(Status: "tilbudHeader", Logtext: string.Format("Update tilbudHeader: ID:{0} KontaktPerson:{1} ", c.ID, c.KontaktPerson), Metode: "Update");
return(retval);
}
public static int Update(KundeGrp_Pris c)
{
DBAccess db = new DBAccess();
c.Dato = DateTime.Now;
db.AddInt("ID", c.ID);
AddParms(ref db, c);
int retval = db.ExecuteNonQuery(_SQLUpdate);
return(retval);
}
public static KundeGrp_Pris GetKundeGrp_VarePris(int KundeGrpID, int VareID)
{
KundeGrp_Pris c = new KundeGrp_Pris();
DBAccess db = new DBAccess();
db.AddInt("KundeGrpID", KundeGrpID);
db.AddInt("VareID", VareID);
SqlDataReader dr = (SqlDataReader)(db.ExecuteReader(_SQLSelectByKundeGrpVareID));
if (dr.HasRows)
{
while (dr.Read())
{
Populate(dr, c);
}
}
dr.Close();
return(c);
}
private static void PopulateDBwithInfositePages(DBAccess db, Infosites po)
{
var with_1 = po;
db.AddBoolean("@Aktiv", with_1.Aktiv);
db.AddInt("Site_FK", with_1.Site_FK);
db.AddInt("Parent_ID", with_1.Parent_ID);
// db.AddInt("Sort", .Sort)
db.AddBoolean("@IncludeInMenu", with_1.IncludeInMenu);
db.AddBoolean("@Forside", with_1.Forside);
db.AddBoolean("@IsDisabled", with_1.IsDisabled);
db.AddBoolean("@IsDeleted", with_1.IsDeleted);
db.AddNVarChar("PageName", with_1.PageName, 50);
db.AddNVarChar("PageTitle", with_1.PageTitle, 50);
db.AddNVarChar("Description", with_1.Description, 250);
db.AddNVarChar("Keywords", with_1.Keywords, 250);
db.AddInt("Template_ID", with_1.Template_ID);
db.AddInt("Category_ID", with_1.Category_ID);
db.AddInt("LinkType_ID", with_1.LinkType_ID);
db.AddNVarChar("LinkUrl", with_1.LinkUrl, 250);
db.AddInt("LinkPage_ID", with_1.LinkPage_ID);
db.AddNVarChar("LinkTarget", with_1.LinkTarget, 50);
db.AddDateTime("OpenDate", with_1.OpenDate);
db.AddDateTime("ExpireDate", with_1.ExpireDate);
db.AddNVarChar("RettetAf", with_1.CurUser);
db.AddNVarChar("RettetIP", with_1.CurIP);
}
public static System.Collections.Generic.List <News> Search_NewsList(string search, NewsStatusEnum status, int NewsGrpID)
{
System.Collections.Generic.List <News> result = new System.Collections.Generic.List <News>();
int ID = -1;
DBAccess db = new DBAccess();
DataSet ds = new DataSet();
DataSet dsTemp = new DataSet();
bool flag = false;
db.AddInt("NewsGrpID", NewsGrpID);
string[] arr = search.Split(' ');
foreach (string s in arr)
{
db.AddNVarChar("Search", s, 250);
db.AddInt("Status", System.Convert.ToInt32(status));
db.AddInt("NewsGrpID", NewsGrpID);
dsTemp = db.ExecuteDataSet(_SQLSelectIDBySearch);
db.Parameters.Clear();
//If dsTemp.Tables.Count > 0 Then
ds.Merge(dsTemp);
if (flag == false)
{
DataColumn[] pk = new DataColumn[2];
pk[0] = ds.Tables[0].Columns["ID"];
ds.Tables[0].PrimaryKey = pk;
flag = true;
}
//End If
}
foreach (DataRow row in ds.Tables[0].Rows)
{
ID = System.Convert.ToInt32(row["ID"]);
result.Add(News.GetNews(ID));
}
return(result);
}
public static DataSet GetAEDbyCompany(int CompanyID)
{
DBAccess db = new DBAccess();
db.AddInt("CompanyID", CompanyID);
db.AddBoolean("IsAgent", AdgangsKontrol.IsAgent());
db.AddGuid("AgentID", CurrentUserID);
DataSet ds = db.ExecuteDataSet(_SQLSelectByCompany);
return(ds);
}
public static int Update(Vare c)
{
DBAccess db = new DBAccess();
db.AddInt("ID", c.ID);
AddParms(ref db, c);
int retval = db.ExecuteNonQuery("Co2Db_Vare_Update");
AddLog(Status: "Vare", Logtext: string.Format("Update Vare: ID:{0} No:{1} ", c.ID, c.VareNr), Metode: "Update");
return(retval);
}
public static DataSet GetEyeWash_DS(int ID)
{
DBAccess db = new DBAccess();
db.AddInt("ID", ID);
db.AddBoolean("IsAgent", AdgangsKontrol.IsAgent());
db.AddGuid("AgentID", CurrentUserID);
DataSet ds = db.ExecuteDataSet(_SQLSelectID);
return(ds);
}
public static DataSet GetAllTilbud(TilbudStatusEnum status)
{
DBAccess db = new DBAccess();
db.AddInt("status", System.Convert.ToInt32(status));
db.AddBoolean("IsAgent", AdgangsKontrol.IsAgent());
db.AddGuid("AgentID", CurrentUserID);
DataSet ds = db.ExecuteDataSet(_SQLSelectByStatus);
return(ds);
}
public static int GetEyeWashcountByCompany(int CompanyID)
{
int res = 0;
DBAccess db = new DBAccess();
db.AddInt("CompanyID", CompanyID);
db.AddBoolean("IsAgent", AdgangsKontrol.IsAgent());
db.AddGuid("AgentID", CurrentUserID);
res = Funktioner.ToInt(db.ExecuteScalar(_SQLCountByCompany));
return(res);
}
private static void AddParms(ref DBAccess db, AED_Trainer c)
{
var with_1 = c;
db.AddInt("Status", (System.Int32)with_1.Status);
db.AddInt("CompanyID", with_1.CompanyID);
db.AddInt("ModelID", with_1.ModelID);
db.AddNVarChar("SerialNo", with_1.SerialNo, 50);
db.AddNVarChar("FirmwareVersion", with_1.FirmwareVersion, 50);
db.AddNVarChar("FirmwareLanguage", with_1._FirmwareLanguage, 50);
db.AddDateTime("DeleveryDate", with_1.DeleveryDate);
db.AddDateTime("WarencyExpireDate", with_1.WarencyExpireDate);
db.AddDateTime("BatteryActivationDate", with_1.BatteryActivationDate);
db.AddDateTime("BatteryWarencyExpireDate", with_1.BatteryWarencyExpireDate);
db.AddInt("BilagStatus", (System.Int32)with_1.BilagStatus);
db.AddDateTime("BilagSendtDato", with_1.BilagSendtDato);
db.AddDateTime("BilagModtagetDato", with_1.BilagModtagetDato);
db.AddNVarChar("ResponsibleName", with_1.ResponsibleName, 50);
db.AddNVarChar("ResponsiblePhone", with_1.ResponsiblePhone, 16);
db.AddNVarChar("ResponsibleEmail", with_1.ResponsibleEmail, 250);
db.AddNVarChar("LocationAdresse", with_1.LocationAdresse, 50);
db.AddNVarChar("LocationPostnr", with_1.LocationPostnr, 16);
db.AddNVarChar("LocationBy", with_1.LocationBy, 50);
db.AddNVarChar("LocationState", with_1.LocationState, 50);
db.AddInt("LocationLandID", with_1.LocationLandID);
db.AddNVarChar("Location", with_1.Location, -1);
db.AddDateTime("RegisterretCSI", with_1.RegisterretCSI);
db.AddNVarChar("RegisterretAF", with_1.RegisterretAF, 50);
db.AddNVarChar("Note", with_1.Note, -1);
AddParmsStandard(db, c);
}
public static DataSet GetBottleByEYE(int EYE_FK)
{
DBAccess db = new DBAccess();
db.AddInt("EYE_FK", EYE_FK);
db.AddBoolean("IsAgent", AdgangsKontrol.IsAgent());
db.AddGuid("AgentID", CurrentUserID);
DataSet ds = db.ExecuteDataSet(_SQLSelectByEYE);
return(ds);
}
public static int Delete(Campaign rec)
{
//For Each POI As CampaignItem In rec.CampaignItems
// POI.Delete()
//Next
DBAccess db = new DBAccess();
db.AddInt("ID", rec.ID);
int retval = db.ExecuteNonQuery(_SQLDelete);
AddLog(Status: "Campaign", Logtext: string.Format("Delete Campaign: ID:{0}", rec.ID), Metode: "Delete");
return(retval);
}
public static DataSet GetKoncernEyeWash(int CompanyID)
{
DBAccess db = new DBAccess();
db.AddInt("CompanyID", CompanyID);
db.AddBoolean("IsAgent", AdgangsKontrol.IsAgent());
db.AddGuid("AgentID", CurrentUserID);
DataSet ds = db.ExecuteDataSet(_SQLSearchConcernEyeWash);
return(ds);
}
public static DataSet GetBatteryBySoonExpired(int CompanyID)
{
DBAccess db = new DBAccess();
db.AddInt("CompanyID", CompanyID);
db.AddBoolean("IsAgent", AdgangsKontrol.IsAgent());
db.AddGuid("AgentID", CurrentUserID);
DataSet ds = db.ExecuteDataSet(_SQLSelectAllSoonExpired);
return(ds);
}
public static DataSet GetBatteryByAED(int AED_FK)
{
DBAccess db = new DBAccess();
db.AddInt("AED_FK", AED_FK);
db.AddBoolean("IsAgent", AdgangsKontrol.IsAgent());
db.AddGuid("AgentID", CurrentUserID);
DataSet ds = db.ExecuteDataSet(_SQLSelectByAED);
return(ds);
}
public static int Delete(InvoiceHeader IH)
{
foreach (Invoiceline IL in IH.Invoiceslinier)
{
IL.Delete();
}
DBAccess db = new DBAccess();
db.AddInt("ID", IH.ID);
int retval = db.ExecuteNonQuery(_SQLDelete);
AddLog(Status: "InvoiceHeader", Logtext: string.Format("Delete InvoiceHeader: ID:{0}", IH.ID), Metode: "Delete");
return(retval);
}
public static int Delete(PurchaseOrder PO)
{
foreach (PurchaseOrderItem POI in PO.PurchaseOrderItems)
{
POI.Delete();
}
DBAccess db = new DBAccess();
db.AddInt("ID", PO.ID);
int retval = db.ExecuteNonQuery(_SQLDelete);
AddLog(Status: "PurchaseOrder", Logtext: string.Format("Delete PurchaseOrder: ID:{0}", PO.ID), Metode: "Delete");
return(retval);
}
private static void AddParms(ref DBAccess db, PurchaseOrderItem rec)
{
var with_1 = rec;
db.AddInt("PurchaseOrderID", with_1.PurchaseOrderID);
db.AddInt("Pos", with_1.Pos);
db.AddInt("Status", (System.Int32)with_1.Status);
db.AddInt("ItemID", with_1.ItemID);
db.AddNVarChar("ItemName", with_1.ItemName, 100);
db.AddNVarChar("SupplierItemID", with_1.SupplierItemID, 50);
db.AddNVarChar("SupplierItemName", with_1.SupplierItemName, 250);
db.AddDecimal("Quantity", with_1.Quantity);
db.AddMoney("ItemPrice", (double)with_1.ItemPrice);
db.AddMoney("LinePrice", (double)with_1.LinePrice);
db.AddDateTime("ExpectedReceiptDate", with_1.ExpectedReceiptDate);
db.AddDateTime("ReceiptDate", with_1.ReceiptDate);
AddParmsStandard(db, rec);
}
public static DataSet Search_Tilbud(string skills, int CompanyID = -1)
{
DataSet ds = new DataSet();
DataSet dsTemp = new DataSet();
bool flag = false;
DBAccess db = new DBAccess();
string[] arr = skills.Split(' ');
foreach (string s in arr)
{
db.AddInt("Status", Funktioner.ToInt(s));
db.AddBoolean("IsAgent", AdgangsKontrol.IsAgent());
db.AddGuid("AgentID", CurrentUserID);
if (CompanyID == -1)
{
//db.AddParameter("@CompanyID", DBNull.Value)
}
else
{
db.AddInt("CompanyID", CompanyID);
}
dsTemp = db.ExecuteDataSet("Co2Db_TilbudHeader_SelectByStatusCompany");
db.Parameters.Clear();
//If dsTemp.Tables.Count > 0 Then
ds.Merge(dsTemp);
if (flag == false)
{
DataColumn[] pk = new DataColumn[2];
pk[0] = ds.Tables[0].Columns["ID"];
ds.Tables[0].PrimaryKey = pk;
flag = true;
}
//End If
}
return(ds);
}
//Public Shared Function GetInfositePagesListe(Optional ByVal CompanyID As Integer = -1, Optional ByVal MedarbejderID As Integer = -1) As DataSet
// Dim db As DBAccess = New DBAccess
// db.AddInt("CompanyID", CompanyID)
// db.AddInt("MedarbejderID", MedarbejderID)
// 'db.Parameters.Add(New SqlParameter("@CompanyID", ToInt(CompanyID)))
// 'db.Parameters.Add(New SqlParameter("@MedarbejderID", ToInt(MedarbejderID)))
// Dim ds As DataSet = db.ExecuteDataSet("Co2Db_InfositePages_SelectAll")
// Return ds
//End Function
//Public Shared Function GetInfositePagesSet(Optional ByVal CompanyID As Integer = -1, Optional ByVal MedarbejderID As Integer = -1) As DataSet
// Dim db As DBAccess = New DBAccess
// db.Parameters.Add(New SqlParameter("@CompanyID", ToInt(CompanyID)))
// db.Parameters.Add(New SqlParameter("@MedarbejderID", ToInt(MedarbejderID)))
// Dim ds As DataSet = db.ExecuteDataSet("Co2Db_InfositePages_SelectAll")
// Return ds
//End Function
// EXEC @return_value = [vicjos1_sysadm].[Co2Db_InfositePages_ListPages]
// @Site_FK = 1,
// @Parent_ID = 2
// EXEC @return_value = [vicjos1_sysadm].[Co2Db_InfositePages_ListPages]
// @Site_FK = 1,
// @Parent_ID = 0
public static DataSet GetInfositePagesSet(int Site_FK, int Parent_ID, int SelfID, bool TopPage)
{
DBAccess db = new DBAccess();
if (Site_FK != 1)
{
db.AddInt("Site_FK", Site_FK);
}
if (Parent_ID != 0)
{
db.AddInt("Parent_ID", Parent_ID);
}
if (SelfID > 0)
{
db.AddInt("SelfID", SelfID);
}
if (TopPage)
{
db.AddInt("TopPage", 0);
}
DataSet ds = db.ExecuteDataSet("Co2Db_InfositePages_ListPages");
return(ds);
}
public static int Update(KundeGrp c)
{
DBAccess db = new DBAccess();
if (c.Status == KundeGrpStatusEnum.Opret)
{
c.Status = KundeGrpStatusEnum.Aktiv;
}
db.AddInt("ID", c.ID);
AddParms(ref db, c);
int retval = db.ExecuteNonQuery(_SQLUpdate);
return(retval);
}
public static int Update(CampaignCompany rec)
{
DBAccess db = new DBAccess();
db.AddInt("ID", rec.ID);
AddParms(ref db, rec);
int retval = 0;
//Try
retval = db.ExecuteNonQuery(_SQLUpdate);
//Catch
//End Try
AddLog(Status: "CampaignCompany", Logtext: string.Format("Update CampaignCompany: ID:{0}", rec.ID), Metode: "Update");
return(retval);
}
public static int GetCompanyInvoiceCount(int CompanyID)
{
DBAccess db = new DBAccess();
db.AddInt("CompanyID", CompanyID);
int res = 0;
try
{
res = Funktioner.ToInt(db.ExecuteScalar(_SQLSelectByCompanyCount));
}
catch (Exception)
{
res = 0;
}
return(res);
}
public static int Update(Combobox c)
{
DBAccess db = new DBAccess();
db.AddInt("ID", c.ID);
AddParms(ref db, c);
//db.AddParameter("@Field", SQLstr(c.Field))
//db.AddParameter("@Title", SQLstr(c.Title))
//db.AddParameter("@Value", SQLstr(c.Value))
//db.AddParameter("@Content", SQLstr(c.Contents))
//db.AddParameter("@Hidden", ToBool(c.Hidden))
//db.AddParameter("@Index", ToInt(c.Idx))
//db.AddParameter("@Valid", ToBool(c.Valid))
return(db.ExecuteNonQuery(_SQLUpdate));
}
public static int GetSupplierPurchaseOrderCount(int SupplierID)
{
DBAccess db = new DBAccess();
db.AddInt("SupplierID", SupplierID);
int res = 0;
try
{
res = Funktioner.ToInt(db.ExecuteScalar(_SQLSelectBySupplierCount));
}
catch (Exception)
{
res = 0;
}
return(res);
}
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);
}
private static void AddParms(ref DBAccess db, Campaign rec)
{
db.AddInt("Status", (System.Int32)rec.Status);
db.AddBit("Active", rec.Active);
db.AddNVarChar("CampaignNo", rec.CampaignNo, 50);
db.AddNVarChar("Name", rec.Name, 255);
db.AddNVarChar("Description", rec.Description);
db.AddDateTime("StartDate", rec.StartDate);
db.AddDateTime("EndDate", rec.EndDate);
db.AddMoney("ExpectedImediateSale", (double)rec.ExpectedImediateSale);
db.AddMoney("ExpectedFollowUpSale", (double)rec.ExpectedFollowUpSale);
AddParmsStandard(db, rec);
}
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);
}
