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