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