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); }
private void orderToolStripMenuItem_Click(object sender, EventArgs e) { ListViewItem item = listviewitem.SelectedItems[0]; cId = int.Parse(item.SubItems[0].Text); Bill bill = new Bill(); bill.ComputerId = cId; billBLL.GetBillId(bill); Order order = new Order(); order.lblBillID.Text = StaticClass.BillID.ToString(); using (var con = SQLfunctions.GetConnection()) { using (var cmd = SQLfunctions.Command(con, cmdText: "GetProduct", cmdType: CommandType.StoredProcedure)) { using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { order.cmbProduct.Items.Add(dr[0]); } } } } order.ShowDialog(); }
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 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); } }
// Navn Vej Postnr fødselsdato //ALTER PROCEDURE [vicjos1_sysadm].[Co2Db_Medarbejder_SelectMedarbejderGlobal] // @mgCompanyID int = -1, // @navn nvarchar(50) = '' , // @vej nvarchar(50) = '' , // @postnr nvarchar(50) = '' , // @birthday datetime = null , // @Search nvarchar(250) = '' public static DataSet SearchMedarbejderGlobal(int mgCompanyID, string search, string navn, string vej, string postnr, string birthday) { string[] arr = search.Split(' '); DataSet ds = new DataSet(); DataSet dsTemp = new DataSet(); bool flag = false; DBAccess db = new DBAccess(); foreach (string s in arr) { db.AddParameter("@mgCompanyID", mgCompanyID); db.AddParameter("@navn", SQLfunctions.SQLstr(navn)); db.AddParameter("@vej", SQLfunctions.SQLstr(vej)); db.AddParameter("@postnr", SQLfunctions.SQLstr(postnr)); db.AddParameter("@birthday", SQLfunctions.SQLdate(birthday)); db.AddParameter("@Search", SQLfunctions.SQLstr(s)); dsTemp = db.ExecuteDataSet("Co2Db_Medarbejder_SelectMedarbejderGlobal"); db.Parameters.Clear(); ds.Merge(dsTemp); if (flag == false) { DataColumn[] pk = new DataColumn[2]; pk[0] = ds.Tables[0].Columns["medID"]; ds.Tables[0].PrimaryKey = pk; flag = true; } } return(ds); }
public static int Insert(Combobox c) { DBAccess db = new DBAccess(); if (SQLfunctions.SQLstr(c.Field).Trim() == "") { return(System.Convert.ToInt32(false)); } AddParms(ref db, c); SqlParameter pID = new SqlParameter("@ID", 0); pID.Direction = ParameterDirection.Output; db.AddParameter(pID); //Return db.ExecuteNonQuery(_SQLInsert) int retval = db.ExecuteNonQuery(_SQLInsert); if (retval == 1) { c.ID = int.Parse(pID.Value.ToString()); return(c.ID); //Integer.Parse(pID.Value.ToString) } else { return(-1); } }
public bool login(string pEmail, string pPassword) { bool success; SqlDataReader reader = null; string sql = "SELECT userID, firstName, lastName, address, city, state, zipcode FROM Users WHERE email='" + pEmail + "' AND password='******'"; SQLfunctions sf = new SQLfunctions(); reader = sf.selectSQL(sql); success = reader.HasRows; if (success) { UserInfo user = new UserInfo(); while (reader.Read()) { user.userID = reader.GetInt32(0); user.firstName = reader["firstName"].ToString(); user.lastName = reader["lastName"].ToString(); user.address = reader["address"].ToString(); user.city = reader["city"].ToString(); user.state = reader["state"].ToString(); user.zipcode = reader["zipcode"].ToString(); } HttpContext.Current.Session.Add("pl_user", user); } return(success); }
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 SysParmDelete(string Param) { DBAccess db = new DBAccess(); db.AddParameter("@ApplicationName", SQLfunctions.SQLstr(Roles.ApplicationName)); db.AddParameter("@Title", Param); return(db.ExecuteNonQuery("Co2Db_SysParm_Delete")); }
public void create() { string sql = "INSERT INTO Users(email, password, firstName, lastName, address, city, state, zipcode) VALUES('" + email + "', '" + CreateMD5Hash(password) + "', '" + firstName + "', '" + lastName + "', '" + address + "', '" + city + "', '" + state + "', '" + zipcode + "')"; SQLfunctions sf = new SQLfunctions(); sf.executeSQL(sql); }
public static void set_SysParm(string Param, string value) { DBAccess db = new DBAccess(); db.AddParameter("@ApplicationName", SQLfunctions.SQLstr(Roles.ApplicationName)); db.AddParameter("@Title", SQLfunctions.SQLstr(Param)); db.AddParameter("@Value", SQLfunctions.SQLstr(value)); db.ExecuteNonQuery("Co2Db_Sysparm_Update"); }
public bool emailExists(string pEmail) { SqlDataReader reader = null; string sql = "SELECT 1 FROM Users WHERE email='" + pEmail + "'"; SQLfunctions sf = new SQLfunctions(); reader = sf.selectSQL(sql); return(reader.HasRows); }
public void addLoan() { UserInfo user = (UserInfo)HttpContext.Current.Session["pl_user"]; string sql = "INSERT INTO Loan(userID, b_email, b_firstName, b_lastName, loanDate, amount, rate, term, loanNumber) VALUES(" + user.userID + ", '" + b_Email + "', '" + b_firstName + "', '" + b_lastName + "', '" + loanDate + "', " + amount + ", " + rate + ", " + term + ", '" + loanNumber + "')"; SQLfunctions sf = new SQLfunctions(); sf.executeSQL(sql); }
protected void BindData() { UserInfo user = (UserInfo)HttpContext.Current.Session["pl_user"]; string sql = "SELECT loanID, loanNumber, b_firstName + ' ' + b_lastName AS name, CONVERT(VARCHAR(10), loanDate, 101) AS loanDate, CONVERT(varchar(12), amount, 1) AS amount FROM Loan NOLOCK WHERE userID=" + user.userID.ToString() + " ORDER BY loanDate"; SQLfunctions sf = new SQLfunctions(); DataSet ds = sf.selectSQLDataSet(sql); grdLoans.DataSource = ds; grdLoans.DataBind(); }
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 void BindData() { using (var con = SQLfunctions.GetConnection()) { using (var cmd = SQLfunctions.Command(con, cmdText: "GetClient", cmdType: CommandType.StoredProcedure)) { using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { cmbClientID.Items.Add(dr[0]); } } } } }
public static int Insert(Korrespondance k) { DBAccess db = new DBAccess(); SqlParameter ID = new SqlParameter("@ID", 0); ID.Direction = ParameterDirection.Output; 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) 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_Korrespondance_Insert"); if (retval == 1) { k.ID = int.Parse(ID.Value.ToString()); AddLog(Status: "Korrespondance", Logtext: string.Format("Create Korrespondance: ID:{0}", k.ID), Metode: "Insert"); return(k.ID); //Integer.Parse(ID.Value.ToString) } else { AddLog(Status: "Korrespondance", Logtext: string.Format("Failure to Create Korrespondance:"), logtype: LogTypeEnum.Error, Metode: "Insert"); return(-1); } }
public static int Update(Noter 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("@Tekst", SQLfunctions.SQLstr(n.Tekst))); db.Parameters.Add(new SqlParameter("@RettetAf", SQLfunctions.SQLstr(CurrentUserName))); db.Parameters.Add(new SqlParameter("@RettetIP", SQLfunctions.SQLstr(CurrentUserIP))); int retval = db.ExecuteNonQuery("Co2Db_Noter_Update"); AddLog(Status: "Noter", Logtext: string.Format("Update Noter: ID:{0}", n.ID), Metode: "Update"); return(retval); }
public static string get_SysParm(string Param) { DBAccess db = new DBAccess(); SqlParameter value = new SqlParameter("@Value", 0); string res = ""; value.Direction = ParameterDirection.Output; value.SqlDbType = SqlDbType.NVarChar; value.Size = 250; db.AddParameter("@ApplicationName", SQLfunctions.SQLstr(Roles.ApplicationName)); db.AddParameter("@Title", SQLfunctions.SQLstr(Param)); db.AddParameter(value); db.ExecuteNonQuery("Co2Db_Sysparm_GetOut"); res = Funktioner.ToDbString(value.Value); return(res.Trim()); //If Not (res.Trim = "") Then // Return res 'ToDbString(value.Value) //Else // Return "" 'Nothing //End If }
//Public Shared Function Insert(ByVal CompanyID As Integer, ByVal Navn As String, ByVal Brugernavn As String, ByVal Kodeord As String, ByVal IP As String, ByVal Dato As Date) As Integer // Dim mg As Medarbejder = New Medarbejder(CompanyID, Navn, Brugernavn, Kodeord, IP, Dato) // Return Insert(mg) //End Function public static int Update(Medarbejder mg) { DBAccess db = new DBAccess(); db.Parameters.Add(new SqlParameter("@ID", mg.ID)); 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))) db.Parameters.Add(new SqlParameter("@Cprnr", SQLfunctions.SQLstr(mg.Cprnr))); db.Parameters.Add(new SqlParameter("@Birthday", SQLfunctions.SQLdate(mg.Birthday))); 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))); int retval = db.ExecuteNonQuery("Co2Db_Medarbejder_Update"); return(retval); }
public void selectLoan(int loanID) { string sql = "SELECT userID, b_email, b_firstName, b_lastName, loanDate, amount, rate, term, loanNumber " + "FROM Loan WHERE loanID=" + loanID.ToString(); SQLfunctions sf = new SQLfunctions(); SqlDataReader reader = sf.selectSQL(sql); while (reader.Read()) { userID = int.Parse(reader["userID"].ToString()); b_Email = reader["b_email"].ToString(); b_firstName = reader["b_firstName"].ToString(); b_lastName = reader["b_lastName"].ToString(); loanDate = DateTime.Parse(reader["loanDate"].ToString()); amount = double.Parse(reader["amount"].ToString()); rate = double.Parse(reader["rate"].ToString()); term = int.Parse(reader["term"].ToString()); loanNumber = reader["loanNumber"].ToString(); //grade; //active; } }
public static int Update(MedarbejderGruppe mg) { DBAccess db = new DBAccess(); db.Parameters.Add(new SqlParameter("@ID", mg.ID)); db.Parameters.Add(new SqlParameter("@Aktiv", Funktioner.ToBool(mg.Aktiv))); 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))); int retval = db.ExecuteNonQuery("Co2Db_MedarbejderGruppe_Update"); return(retval); }