protected void btnOK_Click(object sender, EventArgs e) { if (imgUpload.HasFile) { string allowEx = ".jpg .png .gif .tiff .bmp"; string extension = Path.GetExtension(imgUpload.FileName); if (allowEx.Contains(extension)) { string filePath = Server.MapPath("../img/SanPham/" + imgUpload.FileName); imgUpload.SaveAs(filePath); object[] param = new object[] { grv1.SelectedDataKey.Value, txtTenMyPham.Text, txtGia.Text, ddLoaiMyPham.SelectedValue, ddHangMyPham.SelectedValue, ddGioiTinh.SelectedValue, txtMoTa.Text, imgUpload.FileName }; List <string> paramList = new List <string> { "@iID", "@sTenMyPham", "@fGia", "@iMaLoaiMyPham", "@iHangMyPham", "@bGioiTinh", "@sMoTa", "@sLinkImg" }; int kq = kn.ExecuteNonQuery("UpdateSanPhamAdmin", param, paramList); if (kq != 0) { Response.Write("<script>alert('Cập nhật thành công');</script>"); Response.AddHeader("REFRESH", "0.1;URL=" + Request.RawUrl); } else { Response.Write("<script>alert('Lỗi');</script>"); } } else { Response.Write("<script>alert('Mởi bạn tải lên file ảnh *.jpg, png, gif, tiff, bmp');</script>"); } } else { string sLinkImg = kn.lay1giatri("Select sLinkImg from tblMyPham where iID ='" + grv1.SelectedDataKey.Value + "'"); object[] param = new object[] { grv1.SelectedDataKey.Value, txtTenMyPham.Text, txtGia.Text, ddLoaiMyPham.SelectedValue, ddHangMyPham.SelectedValue, ddGioiTinh.SelectedValue, txtMoTa.Text, sLinkImg }; List <string> paramList = new List <string> { "@iID", "@sTenMyPham", "@fGia", "@iMaLoaiMyPham", "@iHangMyPham", "@bGioiTinh", "@sMoTa", "@sLinkImg" }; int kq = kn.ExecuteNonQuery("UpdateSanPhamAdmin", param, paramList); if (kq != 0) { Response.Write("<script>alert('Cập nhật thành công');</script>"); Response.AddHeader("REFRESH", "0.1;URL=" + Request.RawUrl); } else { Response.Write("<script>alert('Lỗi');</script>"); } } }
protected void btnOK_Click(object sender, EventArgs e) { int kq = kn.ExecuteNonQuery("UpdateHangMyPhamAdmin", new object[] { grvHangMyPham.SelectedDataKey.Value, txtHang.Text, txtDiaChi.Text }, new List <string> { "@iHangMyPham", "@sTenHang", "@sDiaChi" }); if (kq != 0) { Response.Write("<script>alert('Update thành công');</script>"); Response.AddHeader("REFRESH", "0.1;URL=" + Request.RawUrl); } else { Response.Write("<script>alert('Lỗi');</script>"); } }
protected void btnOK_Click(object sender, EventArgs e) { int kq = kn.ExecuteNonQuery("UpdateGiongLoaiAdmin", new object[] { grvGiongLoai.SelectedDataKey.Value, txtGiongLoai.Text }, new List <string> { "@iMaLoai", "@sTenLoai" }); if (kq != 0) { Response.Write("<script>alert('Cập nhật thành công');</script>"); Response.AddHeader("REFRESH", "0.1;URL=" + Request.RawUrl); } else { Response.Write("<script>alert('Lỗi');</script>"); } }
protected void btnOK_Click(object sender, EventArgs e) { int kq = kn.ExecuteNonQuery("UpdateKhachHangAdmin", new object[] { grvUser.SelectedDataKey.Value, txtUsername.Text, txtHoTen.Text, txtDiaChi.Text, txtSDT.Text }, new List <string> { "@iID", "@sUsername", "@sTenKH", "@sDiaChi", "@sSDT" }); if (kq != 0) { Response.Write("<script>alert('Update thành công');</script>"); Response.AddHeader("REFRESH", "0.1;URL=" + Request.RawUrl); } else { Response.Write("<script>alert('Lỗi');</script>"); } }