protected override object GetDataFromDataRow(DataTable dt, int i)
{
LoaiPhongDTO lpDTO = new LoaiPhongDTO();
lpDTO.DonGia = int.Parse(dt.Rows[i]["DonGia"].ToString());
lpDTO.MaLoaiPhong = dt.Rows[i]["MaLoaiPhong"].ToString();
lpDTO.TenLoaiPhong = dt.Rows[i]["TenLoaiPhong"].ToString();
return (object)lpDTO;
}
public System.Data.DataTable ConvertLoaiPhongDTOToDataTable(LoaiPhongDTO[] lpDTOArr)
{
System.Data.DataTable dt = new System.Data.DataTable();
int row = lpDTOArr.Length;
dt.Columns.Add("MaLoaiPhong", typeof(string));
dt.Columns.Add("TenLoaiPhong", typeof(string));
dt.Columns.Add("DonGia", typeof(int));
for (int i = 0; i < row; i++)
{
dt.Rows.Add(lpDTOArr[i].MaLoaiPhong, lpDTOArr[i].TenLoaiPhong, lpDTOArr[i].DonGia);
}
return dt;
}
public LoaiPhongDTO[] getListLoaiPhong()
{
string strSQL = "SELECT * FROM LOAIPHONG";
DataTable dt = ExecuteQuery(strSQL);
LoaiPhongDTO[] lpDTOArr = new LoaiPhongDTO[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
object lpDTO = GetDataFromDataRow(dt, i);
lpDTOArr[i] = (LoaiPhongDTO)lpDTO;
}
return lpDTOArr;
}
public int update(LoaiPhongDTO dtoLP)
{
string sql = "update LOAIPHONG set LOAIPHONG.TenLoaiPhong='" + dtoLP.TenLoaiPhong + "',LOAIPHONG.DonGia='" + dtoLP.DonGia + "' where LOAIPHONG.MaLoaiPhong='" + dtoLP.MaLoaiPhong + "'";
return ExecuteNonQuery(sql,"isReturnInt");
}
public int KiemTra_MaLP(LoaiPhongDTO dtoLP)
{
string sql = "select * from LOAIPHONG where LOAIPHONG.MaLoaiPhong='" + dtoLP.MaLoaiPhong + "'";
return ExecuteReader(sql,"isReturnInt");
}
public int insertLoaiPhong(LoaiPhongDTO dtoLP)
{
string sql = "insert into LOAIPHONG(MaLoaiPhong,TenLoaiPhong,DonGia) values('" + dtoLP.MaLoaiPhong + "','" + dtoLP.TenLoaiPhong + "','" + dtoLP.DonGia + "')";
return ExecuteNonQuery(sql,"isReturInt");
}
public int UpdateLoaiPhong(LoaiPhongDTO dtoLP)
{
return lpDAO.update(dtoLP);
}
public int KiemTra_MaLP(LoaiPhongDTO dtoLP)
{
return lpDAO.KiemTra_MaLP(dtoLP);
}
public int insertLoaiPhong(LoaiPhongDTO dtoLP)
{
return lpDAO.insertLoaiPhong(dtoLP);
}
