//delete
public static int DeleteUser(int id)
{
SqlCommand cmd = new SqlCommand("delete from Users where Id=@id");
cmd.Parameters.AddWithValue("id", id);
return(DBLayers.DML(cmd));
}
//delete
public static int DeleteCart(int id)
{
SqlCommand cmd = new SqlCommand("delete from Cart where CID=@id)");
cmd.Parameters.AddWithValue("id", id);
return(DBLayers.DML(cmd));
}
//insert
public static int InsertCategory(string name)
{
SqlCommand cmd = new SqlCommand("insert into Category values(@name)");
cmd.Parameters.AddWithValue("name", name);
return(DBLayers.DML(cmd));
}
public static int changePassword(int id, string newPassword)
{
SqlCommand cmd = new SqlCommand("update Users set Password=@password where Id=@id");
cmd.Parameters.AddWithValue("id", id);
cmd.Parameters.AddWithValue("password", newPassword);
return(DBLayers.DML(cmd));
}
//update
public static int UpdateCategory(int id, string name)
{
SqlCommand cmd = new SqlCommand("update Category set Id=@id,Name=@name)");
cmd.Parameters.AddWithValue("id", id);
cmd.Parameters.AddWithValue("name", name);
return(DBLayers.DML(cmd));
}
//update
public static int UpdateCart(int id, int user_id, int product_id, int amount, DateTime date_purchased)
{
SqlCommand cmd = new SqlCommand("Update Cart set UserId=@user_id,ProductId=@product_id,Amount=@amount,DatePurchased=@date_purchased)");
cmd.Parameters.AddWithValue("user_id", user_id);
cmd.Parameters.AddWithValue("product_id", product_id);
cmd.Parameters.AddWithValue("amount", amount);
cmd.Parameters.AddWithValue("date_purchased", date_purchased);
return(DBLayers.DML(cmd));
}
//insert
public static int InsertCart(int user_id, int product_id, int amount, DateTime date_purchased)
{
SqlCommand cmd = new SqlCommand("insert into Cart (UserId,ProductId,Amount,DatePurchased)values(@user_id,@product_id,@amount,@date_purchased)");
cmd.Parameters.AddWithValue("user_id", user_id);
cmd.Parameters.AddWithValue("product_id", product_id);
cmd.Parameters.AddWithValue("amount", amount);
cmd.Parameters.AddWithValue("date_purchased", date_purchased);
return(DBLayers.DML(cmd));
}
//update
public static int UpdateUser(int id, string name, int age, string password, string email, string gender, string image)
{
SqlCommand cmd = new SqlCommand("update Users set Name=@name ,Age=@age,Password=@password,Email=@email,Gender=@gender,Image=@image where Id=@id)");
cmd.Parameters.AddWithValue("id", id);
cmd.Parameters.AddWithValue("name", name);
cmd.Parameters.AddWithValue("age", age);
cmd.Parameters.AddWithValue("password", password);
cmd.Parameters.AddWithValue("email", email);
cmd.Parameters.AddWithValue("image", image);
return(DBLayers.DML(cmd));
}
//insert
public static int InsertUser(string name, int age, string password, string email, string gender, string image)
{
SqlCommand cmd = new SqlCommand("insert into Users(Name,Age,Password,Email,Gender,Image) values(@name,@age,@password,@email,@gender,@image)");
cmd.Parameters.AddWithValue("name", name);
cmd.Parameters.AddWithValue("age", age);
cmd.Parameters.AddWithValue("password", password);
cmd.Parameters.AddWithValue("email", email);
cmd.Parameters.AddWithValue("gender", gender);
cmd.Parameters.AddWithValue("image", image);
return(DBLayers.DML(cmd));
}
protected void btn_save_Click(object sender, EventArgs e)
{
try
{
string path = "~/attach/" + fu_img.FileName;
fu_img.SaveAs(Server.MapPath(path));
SqlCommand cmd = new SqlCommand("update Users set Name=@name, Age=@age, Gender=@gender, Email=@email, Image=@image where Id=@id");
cmd.Parameters.AddWithValue("id", int.Parse(Request.Cookies["user"].Values["id"]));
cmd.Parameters.AddWithValue("name", txt_name.Text);
cmd.Parameters.AddWithValue("age", int.Parse(txt_age.Text));
cmd.Parameters.AddWithValue("gender", txt_gender.Text);
cmd.Parameters.AddWithValue("email", txt_email.Text);
cmd.Parameters.AddWithValue("image", path);
DBLayers.DML(cmd);
//int x = DBLayers.DML(cmd);
//Response.Write(x);
Response.Redirect("~/Profile.aspx");
}
catch
{
string path = "~/attach/" + fu_img.FileName;
fu_img.SaveAs(Server.MapPath(path));
SqlCommand cmd = new SqlCommand("update Users set Name=@name, Age=@age, Gender=@gender, Email=@email, Image=@image where Id=@Sid");
cmd.Parameters.AddWithValue("Sid", int.Parse(Session["id"].ToString()));
//cmd.Parameters.AddWithValue("id", int.Parse(Request.Cookies["user"].Values["id"]));
cmd.Parameters.AddWithValue("name", txt_name.Text);
cmd.Parameters.AddWithValue("age", int.Parse(txt_age.Text));
cmd.Parameters.AddWithValue("gender", txt_gender.Text);
cmd.Parameters.AddWithValue("email", txt_email.Text);
cmd.Parameters.AddWithValue("image", path);
DBLayers.DML(cmd);
//int x=DBLayers.DML(cmd);
//Response.Write(x);
Response.Redirect("~/Profile.aspx");
}
}
