/*USED IN THE USER CREATION PROCESS * FUNCTION :This method create a new user in the DB * RETURN :TRUE if the user is created, FALSE orthewise * MORE :Before calling this method, the "login" of the new user * will be previously validate with the method "VALIDATELOGIN(string login) above **/ public bool CreateNewUserCAD(UserClass user) { bool updated = false; DataSet bdvirtual = new DataSet(); try { SqlDataAdapter da = new SqlDataAdapter("select *from UserTable", c); da.Fill(bdvirtual, "UserTable"); DataTable tabla = new DataTable(); tabla = bdvirtual.Tables["UserTable"]; DataRow nuevaFila = tabla.NewRow(); nuevaFila[0] = 2; nuevaFila[1] = user.FirstName; nuevaFila[2] = user.LastName; nuevaFila[3] = user.DateOfBirth; nuevaFila[4] = user.UserName; nuevaFila[5] = user.Password; nuevaFila[6] = user.Email; nuevaFila[7] = user.Country; tabla.Rows.Add(nuevaFila); SqlCommandBuilder cbuilder = new SqlCommandBuilder(da); da.Update(bdvirtual, "UserTable"); updated = true; } catch (SqlException exp){updated = false;} finally{c.Close();} return updated; }
protected void CreateUserWizard1_CreatedUser(object sender, EventArgs e) { UserClass user = new UserClass(); /* user.FirstName = "Firmin"; user.LastName = "Firmino"; user.UserName = create*/ }
protected void ModifyData_Click(object sender, EventArgs e) { int userID = Convert.ToInt32(Session["idUser"].ToString().Trim()); UserClass user = new UserClass(userID); user.UserName=UserName.Text; user.FirstName=FirstName.Text; user.LastName=LastName.Text; user.Email = Email.Text; user.DateOfBirth=Convert.ToDateTime(DateOfBirth.Text); user.Country=Country.Text; user.updateUserInfo(); }
public UserClass(int newIdUser) { idUser = newIdUser; UserClass user = new UserClass(); user=getUserInformation(); UserName = user.UserName; FirstName = user.FirstName; LastName = user.LastName; Password = user.Password; Email = user.Email; DateOfBirth = user.DateOfBirth; Country = user.Country; }
protected void ChangeUserPassword_ChangedPassword(object sender, EventArgs e) { if(ChangeUserPassword.NewPassword==ChangeUserPassword.ConfirmNewPassword) { int userID = Convert.ToInt32(Session["idUser"].ToString().Trim()); UserClass user = new UserClass(userID); if (ChangeUserPassword.CurrentPassword == user.Password) { user.Password = ChangeUserPassword.NewPassword; user.updateUserInfo(); } } }
//Constructor of copy public UserClass(UserClass user) { userName = user.UserName; firstName = user.FirstName; lastName = user.LastName; password = user.Password; email = user.Email; dateOfBirth = user.DateOfBirth; country = user.Country; }
protected void RegisterButton_Click(object sender, EventArgs e) { UserClass tempUser = new UserClass(); String nick=UserName.Text; String password=Password.Text; String password2=ConfirmPassword.Text; String name=FirstName.Text; String subname=LastName.Text; String email=Email.Text; DateTime birth = Convert.ToDateTime(DateOfBirth.Text); String country=Country.Text; if (tempUser.ValidateLogin(nick)) { UserClass newUser = new UserClass(nick, subname, name, email, password, birth, country); newUser.CreateNewUser(); } }
private void showData() { int userID = Convert.ToInt32(Session["idUser"].ToString().Trim()); UserClass user = new UserClass(userID); FirstName.Text = user.FirstName; LastName.Text = user.LastName; Email.Text = user.Email; Country.Text = user.Country; user.getUserInformation(); UserName.Text=user.UserName; FirstName.Text=user.FirstName; LastName.Text=user.LastName; Email.Text=user.Email; DateTime dt = user.DateOfBirth; DateOfBirth.Text = String.Format("{0:dd/MM/yyyy}", dt); Country.Text=user.Country; }
/*USED WHEN A USER EDIT HIS INFORMATIONS * DETAILS :This function retrieve the informations of the user from the DB * and print them. * RETURN :An object UserClass with all the user information. * */ public UserClass getUserInformation() { UserCAD userBD = new UserCAD(); UserClass user = new UserClass(); user = userBD.getUserInformationCAD(IdUser); return user; }
/*USED IN THE MODIFICATION OF THE USER'S INFORMATIONS: * DETAILS : This function modify the user information in the DB. * The user already exist in the DB. * RETURN :TRUE if the information are updated, FALSE otherwise. * */ public bool updateUserInfoCAD(UserClass usuario) { bool updated = false; //UserClass user = usuario; DataSet bdvirtual = new DataSet(); try { SqlDataAdapter da = new SqlDataAdapter("Select * from UserTable where idUser =\'" + usuario.IdUser + "\'", c); da.Fill(bdvirtual, "UserTable"); DataTable t = new DataTable(); t = bdvirtual.Tables["UserTable"]; t.Rows[0]["userName"] = usuario.UserName; t.Rows[0]["firstName"] = usuario.FirstName; t.Rows[0]["lastName"] = usuario.LastName; t.Rows[0]["password"] = usuario.Password; t.Rows[0]["email"] = usuario.Email; t.Rows[0]["dateOfbirth"] = usuario.DateOfBirth; t.Rows[0]["country"] = usuario.Country; SqlCommandBuilder cbuilder = new SqlCommandBuilder(da); da.Update(bdvirtual, "UserTable"); updated = true; } catch (Exception ex){updated = false;} finally{c.Close();} return updated; }
/*USED WHEN A USER EDIT HIS INFORMATIONS * DETAILS :This function retrieve the informations of the user from the DB * and print them. * RETURN :An object UserClass with all the user information. * */ public UserClass getUserInformationCAD(int IDuser) { UserClass usuario = new UserClass(); try { c.Open(); SqlCommand com = new SqlCommand("Select * from userTable where idUser =\'" +IDuser+"\'", c); SqlDataReader dr = com.ExecuteReader(); dr.Read(); usuario.LastName = dr["lastName"].ToString(); usuario.FirstName = dr["firstName"].ToString(); usuario.DateOfBirth = (DateTime)dr["dateOfBirth"]; usuario.UserName = dr["userName"].ToString(); usuario.Email = dr["email"].ToString(); usuario.Password = dr["password"].ToString(); usuario.Country = dr["country"].ToString(); } catch (SqlException exp) { throw new Exception(exp.Message, exp); } finally { c.Close(); } return usuario; }