public int Remove(Ecommers.Entity.Users user)
{
int result = 0;
string sql = "delete from Users where UserID=@UserID";
SqlCommand cmd = new SqlCommand(sql, DBC.conn);
cmd.Parameters.AddWithValue("@UserID", user.UserID);
DBC.conn.Open();
result = cmd.ExecuteNonQuery();
DBC.conn.Close();
return(result);
}
public int Edit2(Ecommers.Entity.Users user)
{
int result = 0;
string sql = "update Users set Fullname=@Fullname, Username=@Username,Password=@Password,Phone=@Phone,Address=@Address,Email=@Email where UserID=@UserID";
SqlCommand cmd = new SqlCommand(sql, DBC.conn);
cmd.Parameters.AddWithValue("@Fullname", user.Fullname);
cmd.Parameters.AddWithValue("@Username", user.Username);
cmd.Parameters.AddWithValue("@Password", user.Password);
cmd.Parameters.AddWithValue("@Phone", user.Phone);
cmd.Parameters.AddWithValue("@Address", user.Address);
cmd.Parameters.AddWithValue("@Email", user.Email);
cmd.Parameters.AddWithValue("@UserID", user.UserID);
DBC.conn.Open();
result = cmd.ExecuteNonQuery();
DBC.conn.Close();
return(result);
}
public int Add(Ecommers.Entity.Users user)
{
int result = 0;
string sql = "insert into Users (Fullname,Username,Password,Phone,Address,Email,Gender,type,CreatedTime) values (@Fullname,@Username,@Password,@Phone,@Address,@Email,@Gender,@type,@CreatedTime) ";
SqlCommand cmd = new SqlCommand(sql, DBC.conn);
cmd.Parameters.AddWithValue("@Fullname", user.Fullname);
cmd.Parameters.AddWithValue("@Username", user.Username);
cmd.Parameters.AddWithValue("@Password", user.Password);
cmd.Parameters.AddWithValue("@Phone", user.Phone);
cmd.Parameters.AddWithValue("@Address", user.Address);
cmd.Parameters.AddWithValue("@Email", user.Email);
cmd.Parameters.AddWithValue("@Gender", user.Gender);
cmd.Parameters.AddWithValue("@type", user.Type);
cmd.Parameters.AddWithValue("@CreatedTime", user.CreatedTime);
DBC.conn.Open();
result = cmd.ExecuteNonQuery();
DBC.conn.Close();
return(result);
}
protected void btnSignup_Click(object sender, EventArgs e)
{
try
{
Ecommers.Entity.Users entity = new Ecommers.Entity.Users(txtFull.Text, txtuser.Text, txtpass.Text, txtPhone.Text, txtAddress.Text, false, txtEmial.Text, ddlGender.SelectedValue, int.Parse(ddlType.SelectedValue.ToString()), DateTime.Now);
if (new Ecommers.BL.Users().Add(entity) > 0)
{
//lblMess.Text = "Data Was Saved Successfully ..!";
//Response.Write("<script> alert('Data Was Saved Successfully'); window.location='SignIn.aspx'</script>");
//Response.Redirect("SignIn.aspx?un=" + System.Web.HttpUtility.UrlEncode(txtuser.Text) + "&pass="******"un"] = txtuser.Text;
Session["pass"] = txtpass.Text;
Response.Redirect("SignIn.aspx");
}
else
{
lblMess.Text = "Data Was Not Saved Successfully..!";
}
}
catch (Exception ex)
{
lblMess.Text = ex.Message;
}
}
