public DataTable timphong(loadroom_DTO room)
{
string query = "SELECT * FROM t_phong WHERE ID like N'" + room.Key + "' or Tenphong like N'" + room.Key + "' ";
DataTable result = new DataTable();
result = processdata.Instance.ExecuteQuery(query);
return(result);
}
public bool xoaphong(loadroom_DTO room)
{
string query = "DELETE FROM t_phong WHERE ID ='" + room.Id + "'";
if (processdata.Instance.ExecuteNonQuery(query))
{
return(true);
}
else
{
return(false);
}
}
public bool suaphong(loadroom_DTO room)
{
string query = "UPDATE t_phong SET ID=N'" + room.Id + "',Tenphong=N'" + room.Name + "',Idloai=N'" + room.Type + "',Idtinhtrang=N'" + room.Status + "'where ID='" + room.Temp + "'";
if (processdata.Instance.ExecuteNonQuery(query))
{
return(true);
}
else
{
return(false);
}
}
public bool addphong(loadroom_DTO room)
{
string query = "INSERT INTO t_phong VALUES(N'" + room.Id + "',N'" + room.Name + "'," + room.Type + "," + room.Status + ")";
if (processdata.Instance.ExecuteNonQuery(query))
{
return(true);
}
else
{
return(false);
}
}
public DataTable timphong(loadroom_DTO room)
{
return(loadroom_DAO.Instance.timphong(room));
}
public bool xoaphong(loadroom_DTO room)
{
return(loadroom_DAO.Instance.xoaphong(room));
}
public bool addroom(loadroom_DTO room)
{
return(loadroom_DAO.Instance.addphong(room));
}
