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