protected void grv_mathang_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
TextBox txttenmh = (TextBox)grv_mathang.Rows[e.RowIndex].Cells[2].Controls[0];
TextBox txtgiaban = (TextBox)grv_mathang.Rows[e.RowIndex].Cells[4].Controls[0];
TextBox txtgiagiam = (TextBox)grv_mathang.Rows[e.RowIndex].Cells[5].Controls[0];
string mamh = grv_mathang.DataKeys[e.RowIndex].Value.ToString();
Mathang mh = new Mathang();
mh.Mamh = mamh;
mh.Tenmh = txttenmh.Text;
mh.Giaban = decimal.Parse(txtgiaban.Text);
mh.Giagiam = decimal.Parse(txtgiagiam.Text);
try
{
MathangBUS.Mathang_Update(mh);
Response.Write("<script>alert('Cập nhật mặt hàng thành công')</script>");
Response.Redirect(Request.Url.AbsoluteUri);
}
catch (Exception ex)
{
Response.Write("<script>alert('" + ex.Message + "')</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
string keyword = Request.QueryString["keyword"].ToString();
try
{
if (keyword != null)
{
DataTable dt = new DataTable();
dt = MathangBUS.Mathang_SearchText(keyword);
if (dt.Rows.Count == 0)
{
dt = MathangBUS.Mathang_SearchNum(decimal.Parse(keyword));
}
dtl_timkiem.DataSource = dt;
dtl_timkiem.DataBind();
lbl_search.Text = "Có " + dt.Rows.Count.ToString() + " mặt hàng với từ khóa " + keyword;
}
else
{
Response.Redirect("~/trang-chu.aspx");
}
}
catch (Exception)
{
Response.Redirect("~/trang-chu.aspx");
}
}
public void Laymamathang()
{
DataTable dt = new DataTable();
string madanhmuc = ddl_danhmuc.SelectedValue.ToString();
dt = MathangBUS.Mathang_GetbyDMTop1(madanhmuc);
if (dt.Rows.Count != 0)
{
int macuoi = int.Parse(dt.Rows[0][0].ToString().Substring(2, 4));
if (macuoi < 10)
{
txt_mamh.Text = madanhmuc + "000" + (macuoi + 1);
}
else if (macuoi < 100)
{
txt_mamh.Text = madanhmuc + "00" + (macuoi + 1);
}
else if (macuoi.ToString().Length == 3)
{
txt_mamh.Text = madanhmuc + "0" + (macuoi + 1);
}
else
{
txt_mamh.Text = madanhmuc + (macuoi + 1);
}
}
else
{
txt_mamh.Text = madanhmuc + "0001";
}
}
protected void btn_chovaogiohang_Click(object sender, EventArgs e)
{
if (Session["login"].ToString() == "member")
{
try
{
string mamh = Request.QueryString["pro"].ToString();
DataTable dt_mathang = new DataTable();
dt_mathang = MathangBUS.Mathang_GetbyId(mamh);//lấy các thông tin của mặt hàng
string hinhdd, tenmh, size;
hinhdd = dt_mathang.Rows[0]["hinhdd"].ToString();
tenmh = dt_mathang.Rows[0]["tenmh"].ToString();
//madm = dt_mathang.Rows[0]["madm"].ToString();
size = ddl_muangay_size.SelectedValue;
double khuyenmai = double.Parse(dt_mathang.Rows[0]["khuyenmai"].ToString());
ThemVaoGioHang(hinhdd, mamh, tenmh, size, khuyenmai);
Response.Redirect("gio-hang.aspx");
}
catch (Exception)
{
}
}
else
{
Response.Redirect("dang-nhap.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
dtl_saletop6.DataSource = MathangBUS.Mathang_GetSaleTop6();
dtl_saletop6.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
ddl_giaydep.DataSource = MathangBUS.Mathang_GetbyDM("GD");
ddl_giaydep.DataBind();
}
catch (Exception)
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
dtl_hangmoi.DataSource = MathangBUS.Mathang_GetSale();
dtl_hangmoi.DataBind();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
string mamh = Request.QueryString["pro"].ToString();
string madm = mamh.Substring(0, 2).ToString();
DataTable dt_mathang = new DataTable();//lấy các thông tin của mặt hàng
dt_mathang = MathangBUS.Mathang_GetbyId(mamh);
DataTable dt_size = null;
if (!IsPostBack)
{
dt_size = SizeBUS.Size_GetbyId(mamh);//lấy size tương ứng với mặt hàng
}
if (dt_mathang.Rows.Count != 0)
{
dtl_chitiet_anh.DataSource = dt_mathang;
dtl_chitiet_anh.DataBind();
dtl_chitiet_tenmh.DataSource = dt_mathang;
dtl_chitiet_tenmh.DataBind();
ddl_muangay_size.DataSource = dt_size;
ddl_muangay_size.DataTextField = "loaisize";
ddl_muangay_size.DataValueField = "loaisize";
ddl_muangay_size.DataBind();
dtl_chitiet_baiviet.DataSource = dt_mathang;
dtl_chitiet_baiviet.DataBind();
dtl_khacloai.DataSource = MathangBUS.Mathang_GetbyNotSameCategory(madm);
dtl_khacloai.DataBind();
dtl_cungloai.DataSource = MathangBUS.Mathang_GetbySameCategory(madm, mamh);
dtl_cungloai.DataBind();
}
else
{
Response.Redirect("~/trang-chu.aspx");
}
}
catch (Exception)
{
Response.Redirect("~/trang-chu.aspx");
}
}
protected void btn_themmathang_Click(object sender, EventArgs e)
{
Mathang mh = new Mathang();
mh.Mamh = txt_mamh.Text;
mh.Tenmh = txt_tenmh.Text;
mh.Hinhdd = mh.Mamh + ".jpg";
mh.Madm = ddl_danhmuc.SelectedValue.ToString();
mh.Mota = cke_mota.Text;
mh.Giaban = decimal.Parse(txt_giaban.Text + "000");
mh.Giagiam = decimal.Parse(txt_giagiam.Text + "000");
if (ful_anhdaidien.HasFile && txt_tenmh.Text != "" && txt_giaban.Text != "" && txt_giagiam.Text != "" && cke_mota.Text != "")
{
FileInfo info = new FileInfo(ful_anhdaidien.FileName);
if (info.Extension == ".jpg")
{
ful_anhdaidien.SaveAs(Server.MapPath("~/images/mat-hang/") + ful_anhdaidien.FileName);
try
{
File.Move(Server.MapPath("~/images/mat-hang/") + info.Name, Server.MapPath("~/images/mat-hang/") + mh.Hinhdd);
}
catch (Exception)
{
}
try
{
MathangBUS.Mathang_Insert(mh);
List <string> ds_size = new List <string>();
if (ddl_danhmuc.SelectedValue == "AO")
{
if (size_S.Checked == true)
{
ds_size.Add("S");
}
if (size_M.Checked == true)
{
ds_size.Add("M");
}
if (size_L.Checked == true)
{
ds_size.Add("L");
}
if (size_XL.Checked == true)
{
ds_size.Add("XL");
}
}
else if (ddl_danhmuc.SelectedValue == "QU")
{
if (size_30.Checked == true)
{
ds_size.Add("30");
}
if (size_31.Checked == true)
{
ds_size.Add("31");
}
if (size_32.Checked == true)
{
ds_size.Add("32");
}
if (size_33.Checked == true)
{
ds_size.Add("33");
}
if (size_34.Checked == true)
{
ds_size.Add("34");
}
}
else if (ddl_danhmuc.SelectedValue == "GD")
{
if (size_40.Checked == true)
{
ds_size.Add("40");
}
if (size_41.Checked == true)
{
ds_size.Add("41");
}
if (size_42.Checked == true)
{
ds_size.Add("42");
}
if (size_43.Checked == true)
{
ds_size.Add("43");
}
if (size_44.Checked == true)
{
ds_size.Add("44");
}
}
else
{
}
foreach (string i in ds_size)
{
SizeBUS.Size_Insert(mh.Mamh, i);
}
Response.Redirect(Request.Url.AbsoluteUri);
Response.Write("<script>alert('Thêm mặt hàng thành công')</script>");
Mathang_Show();
}
catch (Exception ex)
{
Response.Write("<script>alert('" + ex.Message + "')</script>");
}
}
else
{
Response.Write("<script>alert('Định dạng ảnh phải là JPEG(*.jpg)')</script>");
}
}
else
{
Response.Write("<script>alert('Bạn chưa nhập đầy đủ thông tin')</script>");
}
}
public void Mathang_Show()
{
grv_mathang.DataSource = MathangBUS.Mathang_Get();
grv_mathang.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
ddl_balotuixach.DataSource = MathangBUS.Mathang_GetbyDM("BT");
ddl_balotuixach.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
ddl_quan.DataSource = MathangBUS.Mathang_GetbyDM("QU");
ddl_quan.DataBind();
}
