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);
}
