public void createUser(string userName, string password)
{
db = new LinqToSQLDatacontext(connectionString);
user newUser = new user();
newUser.name = userName;
newUser.password = password;
// Create User
db.users.InsertOnSubmit(newUser);
db.SubmitChanges();
}
/// <summary>
/// Create a new user object.
/// </summary>
/// <param name="id">Initial value of the Id property.</param>
/// <param name="name">Initial value of the Name property.</param>
/// <param name="pKey">Initial value of the PKey property.</param>
/// <param name="userType">Initial value of the UserType property.</param>
/// <param name="needsReset">Initial value of the NeedsReset property.</param>
public static user Createuser(global::System.String id, global::System.String name, global::System.Int64 pKey, global::System.Int64 userType, global::System.Boolean needsReset)
{
user user = new user();
user.Id = id;
user.Name = name;
user.PKey = pKey;
user.UserType = userType;
user.NeedsReset = needsReset;
return user;
}
/// <summary>
/// Deprecated Method for adding a new object to the users EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddTousers(user user)
{
base.AddObject("users", user);
}
public void editUsername(string userName, string newName)
{
db = new LinqToSQLDatacontext(connectionString);
try
{
//Get cardbinder to edit
var binderQuery =
from b in db.cardbinders
where b.userid == userName
select b;
foreach (cardbinder b in binderQuery)
{
// create new cardbinder to replace old
cardbinder binder = new cardbinder();
binder.id = b.id;
binder.cardid = b.cardid;
binder.userid = newName;
db.cardbinders.DeleteOnSubmit(b);
db.cardbinders.InsertOnSubmit(binder);
}
//Get user to edit
var query =
from u in db.users
where u.name == userName
select u;
foreach (user u in query)
{
// create new user and cardbinder to replace old
user uNew = new user();
uNew.name = newName;
uNew.password = u.password;
db.users.DeleteOnSubmit(u);
db.users.InsertOnSubmit(uNew);
}
// Save changes
db.SubmitChanges();
}
catch (Exception e)
{
Console.WriteLine(e); ;
}
}
partial void Deleteuser(user instance);
partial void Updateuser(user instance);
partial void Insertuser(user instance);
