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