public DataTable load_dgv(dichvu_DTO dv)
{
string query = "SELECT t_sudungdichvu.ID,t_loaidichvu.Ten,t_dichvu.Ten,t_dichvu.Dongia,t_sudungdichvu.Soluong FROM t_loaidichvu,t_thuephong,t_dichvu,t_sudungdichvu WHERE t_thuephong.ID =t_sudungdichvu.Idthuephong and t_loaidichvu.ID = t_dichvu.Idloai and t_dichvu.ID = t_sudungdichvu.Iddichvu and t_thuephong.ID ='" + dv.Int_temp + "'";
DataTable result = new DataTable();
result = processdata.Instance.ExecuteQuery(query);
return(result);
}
public DataTable loaddv(dichvu_DTO dv)
{
string query = "SELECT * FROM t_dichvu WHERE Idloai = N'" + dv.Temp + "'";
DataTable result = new DataTable();
result = processdata.Instance.ExecuteQuery(query);
return(result);
}
public DataTable loadkh(dichvu_DTO dv)
{
string query = "SELECT * FROM t_thuephong WHERE Idphong = '" + dv.Temp + "'";
DataTable result = new DataTable();
result = processdata.Instance.ExecuteQuery(query);
return(result);
}
public bool suadichvu(dichvu_DTO dv)
{
string query = "UPDATE t_sudungdichvu SET Soluong=N'" + dv.Soluong + "',Iddichvu=N'" + dv.Iddichvu + "' WHERE ID = " + dv.Idthuephong + "";
if (processdata.Instance.ExecuteNonQuery(query))
{
return(true);
}
else
{
return(false);
}
}
public bool xoadichvu(dichvu_DTO dv)
{
string query = "DELETE FROM t_sudungdichvu WHERE ID= '" + dv.Int_temp + "'";
if (processdata.Instance.ExecuteNonQuery(query))
{
return(true);
}
else
{
return(false);
}
}
public bool themdichvu(dichvu_DTO dv)
{
string query = "INSERT INTO t_sudungdichvu VALUES('" + dv.Idthuephong + "','" + dv.Iddichvu + "','" + dv.Soluong + "')";
if (processdata.Instance.ExecuteNonQuery(query))
{
return(true);
}
else
{
return(false);
}
}
public bool suadichvu(dichvu_DTO dv)
{
return(dichvu_DAO.Instance.suadichvu(dv));
}
public bool themdichvu(dichvu_DTO dv)
{
return(dichvu_DAO.Instance.themdichvu(dv));
}
public DataTable load_dgv(dichvu_DTO dv)
{
return(dichvu_DAO.Instance.load_dgv(dv));
}