private static void AddParms(ref DBAccess db, Korrespondance k) { var with_1 = k; db.Parameters.Add(new SqlParameter("@Type", Funktioner.ToInt(k.Type))); db.Parameters.Add(new SqlParameter("@CompanyID", Funktioner.ToInt(k.CompanyID))); db.Parameters.Add(new SqlParameter("@MedarbejderID", Funktioner.ToInt(k.MedarbejderID))); db.Parameters.Add(new SqlParameter("@Status", Funktioner.ToInt(k.Status))); db.Parameters.Add(new SqlParameter("@Overskrift", SQLfunctions.SQLstr(k.Overskrift))); db.Parameters.Add(new SqlParameter("@Ekstern", Funktioner.ToBool(k.Ekstern))); db.Parameters.Add(new SqlParameter("@Mime", SQLfunctions.SQLstr(k.Mime))); db.Parameters.Add(new SqlParameter("@Filename", SQLfunctions.SQLstr(k.Filename))); db.Parameters.Add(new SqlParameter("@Ext", SQLfunctions.SQLstr(k.Ext))); db.Parameters.Add(new SqlParameter("@Size", Funktioner.ToInt(k.Size))); SqlParameter pictureParameter = new SqlParameter("@Blob", SqlDbType.Image); pictureParameter.Value = k.Blob; db.Parameters.Add(pictureParameter); // db.AddParameter("@Blob", Blob) AddParmsStandard(db, k); }
public static int Update(Korrespondance n) { DBAccess db = new DBAccess(); db.Parameters.Add(new SqlParameter("@ID", n.ID)); db.Parameters.Add(new SqlParameter("@Type", Funktioner.ToInt(n.Type))); db.Parameters.Add(new SqlParameter("@CompanyID", Funktioner.ToInt(n.CompanyID))); db.Parameters.Add(new SqlParameter("@MedarbejderID", Funktioner.ToInt(n.MedarbejderID))); db.Parameters.Add(new SqlParameter("@Status", Funktioner.ToInt(n.Status))); db.Parameters.Add(new SqlParameter("@Overskrift", SQLfunctions.SQLstr(n.Overskrift))); db.Parameters.Add(new SqlParameter("@Extern", Funktioner.ToBool(n.Ekstern))); db.Parameters.Add(new SqlParameter("@Mime", SQLfunctions.SQLstr(n.Mime))); db.Parameters.Add(new SqlParameter("@Filename", SQLfunctions.SQLstr(n.Filename))); db.Parameters.Add(new SqlParameter("@Ext", SQLfunctions.SQLstr(n.Ext))); db.Parameters.Add(new SqlParameter("@Size", Funktioner.ToInt(n.Size))); //Dim pictureParameter As SqlParameter = New SqlParameter("@Blob", SqlDbType.Image) //pictureParameter.Value = n.Blob //db.Parameters.Add(pictureParameter) // db.AddParameter("@Blob", Blob) db.Parameters.Add(new SqlParameter("@RettetAf", SQLfunctions.SQLstr(CurrentUserName))); db.Parameters.Add(new SqlParameter("@RettetIP", SQLfunctions.SQLstr(CurrentUserIP))); int retval = db.ExecuteNonQuery("Co2Db_Korrespondance_Update"); AddLog(Status: "Noter", Logtext: string.Format("Update Noter: ID:{0}", n.ID), Metode: "Update"); return(retval); }
public static int Insert(KundeGrp_Pris c) { DBAccess db = new DBAccess(); c.Dato = DateTime.Now; if (c.Status <= (int)KundeGrpStatusEnum.Opret) { c.Status = KundeGrpStatusEnum.Aktiv; } AddParms(ref db, c); SqlParameter objParam = new SqlParameter("@ID", 0); objParam.Direction = ParameterDirection.Output; db.Parameters.Add(objParam); int retval = db.ExecuteNonQuery(_SQLInsert); if (retval == 1) { c.ID = Funktioner.ToInt(objParam.Value, -1); //Integer.Parse(objParam.Value.ToString) return(c.ID); //Integer.Parse(objParam.Value.ToString) } else { return(-1); } }
public static int Insert(MedarbejderGruppe mg) { DBAccess db = new DBAccess(); SqlParameter objParam = new SqlParameter("@ID", 0); objParam.Direction = ParameterDirection.Output; db.Parameters.Add(new SqlParameter("@CompanyID", mg.CompanyID)); db.Parameters.Add(new SqlParameter("@Navn", SQLfunctions.SQLstr(mg.Navn))); db.Parameters.Add(new SqlParameter("@Brugernavn", SQLfunctions.SQLstr(mg.Brugernavn))); db.Parameters.Add(new SqlParameter("@Kodeord", SQLfunctions.SQLstr(mg.Kodeord))); db.Parameters.Add(new SqlParameter("@Password", mg.Password)); db.Parameters.Add(new SqlParameter("@IP", SQLfunctions.SQLstr(mg.IP))); db.Parameters.Add(new SqlParameter("@Dato", SQLfunctions.SQLdate(mg.Dato))); db.Parameters.Add(new SqlParameter("@Informationssite", Funktioner.ToBool(mg.Informationssite))); db.Parameters.Add(new SqlParameter("@Administrationssite", Funktioner.ToBool(mg.Administrationssite))); db.Parameters.Add(new SqlParameter("@RettetAf", SQLfunctions.SQLstr(mg.CurUser))); db.Parameters.Add(new SqlParameter("@RettetIP", SQLfunctions.SQLstr(mg.CurIP))); db.Parameters.Add(objParam); int retval = db.ExecuteNonQuery("Co2Db_MedarbejderGruppe_Insert"); if (retval == 1) { return(int.Parse(objParam.Value.ToString())); } else { return(-1); } }
public static int Insert(PurchaseOrderItem rec) { DBAccess db = new DBAccess(); if (rec.Status <= (int)PurchaseOrderItem_StatusEnum.Create) { rec.Status = PurchaseOrderItem_StatusEnum.Active; } AddParms(ref db, rec); SqlParameter objParam = new SqlParameter("@ID", 0); objParam.Direction = ParameterDirection.Output; db.Parameters.Add(objParam); int retval = db.ExecuteNonQuery(_SQLInsert); if (retval == 1) { int res = -1; res = Funktioner.ToInteger(objParam.Value); AddLog(Status: "PurchaseOrderItem", Logtext: string.Format("Create PurchaseOrderItem: ID:{0}", rec.ID), Metode: "Insert"); return(res); } else { AddLog(Status: "PurchaseOrderItem", Logtext: string.Format("Failure to create PurchaseOrderItem:"), logtype: LogTypeEnum.Error, Metode: "Insert"); return(-1); } }
public static int Insert(AED_Redning R) { DBAccess db = new DBAccess(); AddParms(ref db, R); SqlParameter objParam = new SqlParameter("@ID", 0); objParam.Direction = ParameterDirection.Output; db.Parameters.Add(objParam); int retval = db.ExecuteNonQuery(_SQLInsert); if (retval == 1) { int res = Funktioner.ToInt(objParam.Value.ToString()); R.ID = res; AddLog(Status: "AED_Redning", Logtext: string.Format("Create AED_Redning: ID:{0}", R.ID), Metode: "Insert"); return(res); } else { AddLog(Status: "AED_Redning", Logtext: string.Format("Failure to Create AED_Redning:"), logtype: LogTypeEnum.Error, Metode: "Insert"); return(-1); } }
public static int Insert(KursusDeltager c) { DBAccess db = new DBAccess(); if (c.Status == KursusKursistStatusEnum.Initialize) { c.Status = KursusKursistStatusEnum.Aktiv; } AddParms(ref db, c); SqlParameter objParam = new SqlParameter("@ID", 0); objParam.Direction = ParameterDirection.Output; db.Parameters.Add(objParam); int retval = db.ExecuteNonQuery(_SQLInsert); if (retval == 1) { c.ID = Funktioner.ToInteger(objParam.Value.ToString(), -1); return(c.ID); } else { return(-1); } }
public static int Insert(Campaign rec) { DBAccess db = new DBAccess(); if (System.Convert.ToInt32(rec.Status) < (int)Campaign_StatusEnum.Active) { rec.Status = Campaign_StatusEnum.Active; } AddParms(ref db, rec); SqlParameter objParam = new SqlParameter("@ID", 0); objParam.Direction = ParameterDirection.Output; db.Parameters.Add(objParam); int retval = db.ExecuteNonQuery(_SQLInsert); if (retval == 1) { rec.ID = Funktioner.ToInt(objParam.Value, -1); AddLog(Status: "Campaign", Logtext: string.Format("Create Campaign: ID:{0}", rec.ID), Metode: "Insert"); return(rec.ID); } else { AddLog(Status: "Campaign", Logtext: string.Format("Failure to Create Campaign:"), logtype: LogTypeEnum.Error, Metode: "Insert"); return(-1); } }
public static int Insert(Invoiceline c) { DBAccess db = new DBAccess(); if (c.Status <= (int)Invoiceline_StatusEnum.Create) { c.Status = Invoiceline_StatusEnum.Active; } AddParms(ref db, c); SqlParameter objParam = new SqlParameter("@ID", 0); objParam.Direction = ParameterDirection.Output; db.Parameters.Add(objParam); int retval = db.ExecuteNonQuery(_SQLInsert); if (retval == 1) { int res = -1; res = Funktioner.ToInteger(objParam.Value); AddLog(Status: "Invoiceline", Logtext: string.Format("Create Invoiceline: ID:{0}", c.ID), Metode: "Insert"); return(res); } else { AddLog(Status: "Invoiceline", Logtext: string.Format("Failure to Invoiceline AED_Battery:"), logtype: LogTypeEnum.Error, Metode: "Insert"); return(-1); } }
public static DataSet Search_Incasso(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)); if (CompanyID != -1) { db.AddInt("CompanyID", CompanyID); } dsTemp = db.ExecuteDataSet(_SQLSelectByStatusCompany); 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 static DataSet Search_Campaign(string skills, int SupplierID = -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)); if (SupplierID == -1) { //db.AddParameter("@CompanyID", DBNull.Value) } else { db.AddInt("SupplierID", SupplierID); } dsTemp = db.ExecuteDataSet(_SQLSelectByStatusSupplier); //"Co2Db_Campaign_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 static int Insert(Noter n) { DBAccess db = new DBAccess(); SqlParameter ID = new SqlParameter("@ID", 0); ID.Direction = ParameterDirection.Output; db.Parameters.Add(new SqlParameter("@Type", Funktioner.ToInt(n.Type))); db.Parameters.Add(new SqlParameter("@CompanyID", Funktioner.ToInt(n.CompanyID))); db.Parameters.Add(new SqlParameter("@MedarbejderID", Funktioner.ToInt(n.MedarbejderID))); db.Parameters.Add(new SqlParameter("@Status", Funktioner.ToInt(n.Status))); db.Parameters.Add(new SqlParameter("@Overskrift", SQLfunctions.SQLstr(n.Overskrift))); db.Parameters.Add(new SqlParameter("@Tekst", SQLfunctions.SQLstr(n.Tekst))); db.Parameters.Add(new SqlParameter("@RettetAf", SQLfunctions.SQLstr(CurrentUserName))); db.Parameters.Add(new SqlParameter("@RettetIP", SQLfunctions.SQLstr(CurrentUserIP))); db.Parameters.Add(ID); int retval = db.ExecuteNonQuery("Co2Db_Noter_Insert"); if (retval == 1) { n.ID = int.Parse(ID.Value.ToString()); AddLog(Status: "Noter", Logtext: string.Format("Create Noter: ID:{0}", n.ID), Metode: "Insert"); return(n.ID); //Integer.Parse(ID.Value.ToString) } else { AddLog(Status: "Noter", Logtext: string.Format("Failure to Create Noter:"), logtype: LogTypeEnum.Error, Metode: "Insert"); return(-1); } }
public static int GetKursusPolicyCountByCompany(int CompanyID) { int res = 0; DBAccess db = new DBAccess(); db.AddInt("CompanyID", CompanyID); res = Funktioner.ToInt(db.ExecuteScalar(_SQLCountByCompany)); return(res); }
public static int GetCompanyIncassoCount(int CompanyID) { DBAccess db = new DBAccess(); db.AddInt("CompanyID", CompanyID); int res = 0; res = Funktioner.ToInt(db.ExecuteScalar(_SQLSelectByCompanyCount), -1); return(res); }
public static int GetIndexByTitle(string Field, string Title) { DBAccess db = new DBAccess(); db.AddParameter("@Field", Field); db.AddParameter("@Title", Title); int res = Funktioner.ToInt(db.ExecuteScalar(_SQLSelectGetIdxByTitle)); //"Co2Db_Combobox_GetIdxByTitle" return(res); }
public static DataSet GetNoterSet(int CompanyID = -1, int MedarbejderID = -1) { DBAccess db = new DBAccess(); db.Parameters.Add(new SqlParameter("@CompanyID", Funktioner.ToInt(CompanyID))); db.Parameters.Add(new SqlParameter("@MedarbejderID", Funktioner.ToInt(MedarbejderID))); DataSet ds = db.ExecuteDataSet("Co2Db_Noter_SelectAll"); 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); }
public static int Insert(Medarbejder mg) { DBAccess db = new DBAccess(); SqlParameter ID = new SqlParameter("@ID", 0); ID.Direction = ParameterDirection.Output; db.Parameters.Add(new SqlParameter("@mgID", mg.mgID)); db.Parameters.Add(new SqlParameter("@CompanyID", mg.CompanyID)); //db.Parameters.Add(New SqlParameter("@status", ToInt(mg.Status))) mg.Status = MedarbejderStatus.opret; db.Parameters.Add(new SqlParameter("@Cprnr", SQLfunctions.SQLstr(mg.Cprnr))); db.Parameters.Add(new SqlParameter("@Birthday", SQLfunctions.SQLdate(mg.Birthday))); //cmd.Parameters.Add("@Description", SqlDbType.NVarChar).Value = category.Description db.Parameters.Add(new SqlParameter("@Navn", SQLfunctions.SQLstr(mg.Navn))); db.Parameters.Add(new SqlParameter("@Adresse1", SQLfunctions.SQLstr(mg.Adresse1))); db.Parameters.Add(new SqlParameter("@Adresse2", SQLfunctions.SQLstr(mg.Adresse2))); db.Parameters.Add(new SqlParameter("@Postnr", SQLfunctions.SQLstr(mg.Postnr))); db.Parameters.Add(new SqlParameter("@Bynavn", SQLfunctions.SQLstr(mg.Bynavn))); db.Parameters.Add(new SqlParameter("@LandID", Funktioner.ToInt(mg.LandID))); db.Parameters.Add(new SqlParameter("@Telefon", SQLfunctions.SQLstr(mg.Telefon))); db.Parameters.Add(new SqlParameter("@Mobil", SQLfunctions.SQLstr(mg.Mobil))); db.Parameters.Add(new SqlParameter("@Fax", SQLfunctions.SQLstr(mg.Fax))); db.Parameters.Add(new SqlParameter("@Email", SQLfunctions.SQLstr(mg.Email))); db.Parameters.Add(new SqlParameter("@HospitalsforsikringIndmeldsDato", SQLfunctions.SQLdate(mg.HospitalsforsikringIndmeldsDato))); db.Parameters.Add(new SqlParameter("@AfkaldserklaringsDato", SQLfunctions.SQLdate(mg.AfkaldserklaringsDato))); db.Parameters.Add(new SqlParameter("@FratradelsesDato", SQLfunctions.SQLdate(mg.FratradelsesDato))); db.Parameters.Add(new SqlParameter("@OrlovStart", SQLfunctions.SQLdate(mg.OrlovStart))); db.Parameters.Add(new SqlParameter("@OrlovSlut", SQLfunctions.SQLdate(mg.OrlovSlut))); db.Parameters.Add(new SqlParameter("@RettetAf", SQLfunctions.SQLstr(CurrentUserName))); db.Parameters.Add(new SqlParameter("@RettetIP", SQLfunctions.SQLstr(CurrentUserIP))); db.Parameters.Add(ID); int retval = db.ExecuteNonQuery("Co2Db_Medarbejder_Insert"); if (retval == 1) { mg.ID = int.Parse(ID.Value.ToString()); return(mg.ID); //Integer.Parse(ID.Value.ToString) } else { return(-1); } }
public static string GetValueByTitle(string Field, string Title) { DBAccess db = new DBAccess(); db.AddParameter("@Field", Field); db.AddParameter("@Title", Title); string res = Funktioner.ToDbString(db.ExecuteScalar(_SQLSelectGetValueByTitle)); //"Co2Db_Combobox_GetValueByTitle" if (res.Trim().Length < 1) { res = " "; } return(res); }
public static string GetContent(string Field, int idx) { DBAccess db = new DBAccess(); db.AddParameter("@Field", Field); db.AddParameter("@Idx", idx); string res = Funktioner.ToDbString(db.ExecuteScalar(_SQLSelectGetContent)); //"Co2Db_Combobox_GetContent" if (res.Trim().Length < 1) { res = " "; } return(res); }
public static Combobox GetCombobox(string Field, int idx) { int ID = -1; DBAccess db = new DBAccess(); db.AddParameter("@Field", Field); db.AddParameter("@Idx", idx); string res = Funktioner.ToDbString(db.ExecuteScalar(_SQLSelectOne)); //"Co2Db_Combobox_SelectOne" if (Information.IsNumeric(res)) { ID = Funktioner.ToInt(res); } return(GetCombobox(ID)); }
public static int GetNoterCount(int CompanyID = -1, int MedarbejderID = -1) { DBAccess db = new DBAccess(); object res = null; int result = 0; db.Parameters.Add(new SqlParameter("@CompanyID", Funktioner.ToInt(CompanyID))); db.Parameters.Add(new SqlParameter("@MedarbejderID", Funktioner.ToInt(MedarbejderID))); res = db.ExecuteScalar("Co2Db_Noter_GetCount"); if ((!ReferenceEquals(res, null)) && Information.IsNumeric(res)) { result = System.Convert.ToInt32(res); } return(result); }
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 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 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 DateTime CprnrToDate(string cprnr) { DateTime res = default(DateTime); int dd = 1; int mm = 1; int yy = 0; int year = 1900; int lbnr = 0; if (cprnr.Length == 11) { dd = Funktioner.ToInt(cprnr.Substring(0, 2)); mm = Funktioner.ToInt(cprnr.Substring(2, 2)); yy = Funktioner.ToInt(cprnr.Substring(4, 2)); lbnr = Funktioner.ToInt(cprnr.Substring(7, 4)); if (lbnr <= 3999) { year = 1900; } else if (lbnr >= 5000 & lbnr <= 8999) { if (yy <= 57) { year = 2000; } else { year = 1800; } } else if ((lbnr >= 4000 & lbnr <= 4999) || (lbnr >= 9000 & lbnr <= 9999)) { if (yy <= 36) { year = 2000; } else { year = 1900; } } } res = DateAndTime.DateSerial(yy + year, mm, dd); return(res); }
public static int GetCompanyID(int InvoiceID) { DBAccess db = new DBAccess(); db.AddInt("InvoiceID", InvoiceID); int res = 0; try { object obj = db.ExecuteScalar(_SQLGetCompanyID); res = Funktioner.ToInteger(obj); } catch { 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 int GetSupplierID(int PurchaseOrderID) { DBAccess db = new DBAccess(); db.AddInt("PurchaseOrderID", PurchaseOrderID); int res = 0; try { object obj = db.ExecuteScalar(_SQLGetSupplierID); res = Funktioner.ToInteger(obj); } catch { res = 0; } return(res); }