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