protected override object GetDataFromDataRow(DataTable dt, int i)
{
ChiTietDichVu chitiet_dulieu = new ChiTietDichVu();
chitiet_dulieu.ma_dulieu = (int)dt.Rows[i]["MaDuLieu"];
chitiet_dulieu.ma_chitiet = (int)dt.Rows[i]["MaChiTiet"];
chitiet_dulieu.ten = dt.Rows[i]["Ten"].ToString();
chitiet_dulieu.gia_tien = (int)dt.Rows[i]["GiaTien"];
chitiet_dulieu.chu_thich = dt.Rows[i]["ChuThich"].ToString();
return((object)chitiet_dulieu);
}
public bool update_ChiTiet_DichVu(ChiTietDichVu dv)
{
try
{
connect();
string deleteCommand = string.Format("UPDATE CHITIET_DULIEU SET MaChiTiet = {0} WHERE MaDuLieu = {1}", dv.ma_chitiet, dv.ma_dulieu);
executeNonQuery(deleteCommand);
disconnect();
return(true);
}
catch (Exception e)
{
return(false);
}
}
public bool delete_ChiTiet_DichVu(ChiTietDichVu dv)
{
try
{
connect();
string deleteCommand = string.Format("DELETE FROM CHITIET_DULIEU WHERE MaDuLieu = {0} and MaChiTiet = {1}", dv.ma_dulieu, dv.ma_chitiet);
executeNonQuery(deleteCommand);
disconnect();
return(true);
}
catch (Exception e)
{
return(false);
}
}
public bool insert_ChiTiet_DichVu(ChiTietDichVu dichvu)
{
connect();
try
{
string insertCommand = string.Format(" insert into CHITIET_DULIEU(MaDuLieu, MaChiTiet) values ({0},{1})", dichvu.ma_dulieu, dichvu.ma_chitiet);
executeNonQuery(insertCommand);
disconnect();
return(true);
}
catch (Exception e)
{
return(false);
}
}
