protected void ButtonInsertSummitClick(object sender, EventArgs e) { if (CheckInputInsert()) { Users users = new Users(); users.UserId = txtInsertUserNames.Text; if (!UserDao.CheckUserIdExists(users)) { users.UserId = txtInsertUserNames.Text; users.Pass = txtInsertPassword.Text; users.Address = txtInsertAddress.Text; users.Birthday = txtInsertBirthday.Text; users.Email = txtInsertEmail.Text; users.FullName = txtInsertFullName.Text; users.Phone = txtInsertPhone.Text; UserBU.InsertUser(users); labelInsertErrorUserName.Text = ""; Display(); } else { labelInsertErrorUserName.Text = "User is exists"; } } }
protected void ButtonLogOnClick(object sender, EventArgs e) { Users users = new Users(); if (CheckInput()) { if (CheckLogOn(users)) { Session["Username"] = txtId.Text; Response.Redirect(Session["URLReferrer"].ToString()); } else { labelCheckId.Text = "Wrong ID or Pass"; } } }
public static bool CheckUserExists(Users users) { SqlCommand sqlcmd; SqlConnection sqlconnecnt = Common.SqlProvider.SelectGetConnection(); try { sqlconnecnt.Open(); sqlcmd = new SqlCommand("sp_checkIdAndPass", sqlconnecnt); sqlcmd.Parameters.Add("id", SqlDbType.VarChar).Value = users.UserId; sqlcmd.Parameters.Add("pass", SqlDbType.VarChar).Value = users.Pass; sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.ExecuteNonQuery(); var dr = sqlcmd.ExecuteReader(); if (dr.HasRows) while (dr.Read()) { return true; } else { return false; } return true; } catch(SqlException) { sqlconnecnt.Close(); return false; } finally { sqlconnecnt.Close(); } }
public static bool UpdateUser(Users users) { return UserDao.UpdateUsers(users); }
public static bool InsertUser(Users users) { return UserDao.InsertUser((users)); }
public static bool DeleteUser(Users users) { return UserDao.DeleteUser(users); }
public static bool CheckUser(Users users) { return UserDao.CheckUserExists(users); }
public static bool DeleteUser(Users users) { SqlCommand sqlcmd; SqlConnection sqlconnecnt = Common.SqlProvider.SelectGetConnection(); try { sqlconnecnt.Open(); sqlcmd = new SqlCommand("sp_DeleteUser", sqlconnecnt); sqlcmd.Parameters.Add("userid", SqlDbType.VarChar).Value = users.UserId; sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.ExecuteNonQuery(); return true; } catch(SqlException) { sqlconnecnt.Close(); return false; } finally { sqlconnecnt.Close(); } }
public static bool UpdateUsers(Users users) { SqlCommand sqlcmd; SqlConnection sqlconnecnt = Common.SqlProvider.SelectGetConnection(); try { sqlconnecnt.Open(); sqlcmd = new SqlCommand("sp_updateUser", sqlconnecnt); sqlcmd.Parameters.Add("Userid", SqlDbType.VarChar).Value = users.UserId; sqlcmd.Parameters.Add("pass", SqlDbType.VarChar).Value = users.Pass; sqlcmd.Parameters.Add("fullname", SqlDbType.NVarChar).Value = users.FullName; sqlcmd.Parameters.Add("birthday", SqlDbType.VarChar).Value = users.Birthday; sqlcmd.Parameters.Add("email", SqlDbType.VarChar).Value = users.Email; sqlcmd.Parameters.Add("phone", SqlDbType.VarChar).Value = users.Phone; sqlcmd.Parameters.Add("address", SqlDbType.NVarChar).Value = users.Address; sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.ExecuteNonQuery(); return true; } catch(SqlException) { sqlconnecnt.Close(); return false; } finally { sqlconnecnt.Close(); } }
public static Users SelectUserById(string user) { SqlCommand sqlcmd; SqlConnection sqlconnecnt = Common.SqlProvider.SelectGetConnection(); Users users = new Users(); try { sqlconnecnt.Open(); sqlcmd = new SqlCommand("sp_getUserByID", sqlconnecnt); sqlcmd.Parameters.Add("id", SqlDbType.VarChar).Value = user; sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.ExecuteNonQuery(); SqlDataReader dr = sqlcmd.ExecuteReader(); if (dr.Read()) { users.UserId = (string)dr["UserID"]; users.Pass = (string)dr["password"]; users.FullName = (string)dr["fullname"]; users.Birthday = (string)dr["birthday"]; users.Email = (string)dr["email"]; users.Phone = (string)dr["phone"]; users.Address = (string)dr["address"]; } return users; } catch(SqlException) { sqlconnecnt.Close(); return users; } finally { sqlconnecnt.Close(); } }
public bool CheckLogOn(Users user) { user.UserId = txtId.Text; user.Pass = txtPassword.Text; return UserBU.CheckUser((user)); }
protected void DeleteCommand1(object sender, CommandEventArgs e) { Users users = new Users(); string id = e.CommandArgument.ToString(); users.UserId = id; UserBU.DeleteUser(users); panelUpdateUser.Visible = false; panelInsertUser.Visible = false; panelShowAllData.Visible = true; Display(); }
protected void ButtonUpdateSummitClick(object sender, EventArgs e) { if (CheckInputUpdateNews()) { Users users = new Users(); users.UserId = txtUpdateUserId.Text; users.Pass = txtUpdatePassword.Text; users.Address = txtUpdateAddress.Text; users.Birthday = txtUpdateBirthday.Text; users.Email = txtUpdateEmail.Text; users.FullName = txtUpdateFullName.Text; users.Phone = txtUpdatePhone.Text; UserBU.UpdateUser((users)); Display(); } }