protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { try { GridView gv = (GridView)sender; GridViewRow row = GridView1.Rows[e.RowIndex]; string sID = gv.DataKeys[e.RowIndex]["MaNSX"].ToString(); string sName = ((TextBox)(row.Cells[1].Controls[0])).Text; string sLogo = ((TextBox)(row.Cells[2].Controls[0])).Text; manufacturerDTO mDTO = new manufacturerDTO(); mDTO.MaNSX = sID; mDTO.TenNSX = sName; mDTO.LogoNSX = sLogo; manufacturerBUS.SuaThongTin(mDTO); GridView1.EditIndex = -1; BindItemsList(); } catch (Exception ex) { Response.Write("<script type='text/javascript'>" + "alert('Có lỗi xảy ra. Vui Lòng điền đúng kiểu dữ liệu yêu cầu !!!');" + "</script>"); } }
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { GridView gv = (GridView)sender; GridViewRow row = GridView1.Rows[e.RowIndex]; string sID = gv.DataKeys[e.RowIndex]["MaNSX"].ToString(); manufacturerDTO mDTO = new manufacturerDTO(); mDTO.MaNSX = sID; if (gv.Rows.Count == 1) { CurrentPage--; } string sLogo = row.Cells[2].Text; try { FileInfo file = new FileInfo(Server.MapPath(sLogo)); if (file.Exists) { File.Delete(Server.MapPath(sLogo)); } } catch { } manufacturerBUS.XoaNSX(mDTO); BindItemsList(); }
public static void ThemNSX(manufacturerDTO mDTO) { string sQuery = "insert into NhaSanXuat(MaNSX,TenNSX,Logo) values('" + mDTO.MaNSX + "','" + mDTO.TenNSX + "','" + mDTO.LogoNSX + "')"; OleDbConnection con = DataProvider.TaoKetNoi(); DataProvider.ExecuteNonQuery(sQuery, con); DataProvider.DongKetNoi(con); }
public static void SuaThongTin(manufacturerDTO mDTO) { string sQuery = "update NhaSanXuat set TenNSX = '" + mDTO.TenNSX + "',Logo ='" + mDTO.LogoNSX + "' where MaNSX = '" + mDTO.MaNSX + "'"; OleDbConnection con = DataProvider.TaoKetNoi(); DataProvider.ExecuteNonQuery(sQuery, con); DataProvider.DongKetNoi(con); }
public static void XoaNSX(manufacturerDTO mDTO) { string sQuery = "delete from NhaSanXuat where MaNSX ='" + mDTO.MaNSX + "'"; OleDbConnection con = DataProvider.TaoKetNoi(); DataProvider.ExecuteNonQuery(sQuery, con); DataProvider.DongKetNoi(con); }
public static bool ktraTonTai(manufacturerDTO mDTO) { string sQuery = "select * from NhaSanXuat where MaNSX='" + mDTO.MaNSX + "'"; OleDbConnection con = DataProvider.TaoKetNoi(); DataTable dt = DataProvider.LayDataTable(sQuery, con); DataProvider.DongKetNoi(con); if (dt.Rows.Count > 0) { return(true); } return(false); }
protected void btnSubmit_Click(object sender, EventArgs e) { try { manufacturerDTO mDTO = new manufacturerDTO(); mDTO.MaNSX = txtID.Text; mDTO.TenNSX = txtName.Text; mDTO.LogoNSX = "~/NguoiDung/images/NSX/" + FileUploadAvatar.FileName; if (manufacturerBUS.KTTonTai(mDTO) == false) { manufacturerBUS.ThemNSX(mDTO); UpAnh(); lblThongBao.Text = "Thêm thành công"; } else { lblThongBao.Text = "Thêm thất bại"; } } catch (Exception ex) { } }
public static void ThemNSX(manufacturerDTO mDTO) { manufacturerDAO.ThemNSX(mDTO); }
public static bool KTTonTai(manufacturerDTO mDTO) { return(manufacturerDAO.ktraTonTai(mDTO)); }
public static void XoaNSX(manufacturerDTO mDTO) { manufacturerDAO.XoaNSX(mDTO); }
public static void SuaThongTin(manufacturerDTO mDTO) { manufacturerDAO.SuaThongTin(mDTO); }