//cap nhat dich vu
public void capNhatDV(DSDichVu dSDichVu)
{
conn.Open();
SqlCommand cmd = new SqlCommand("update dichvu set TenDichVu=N'" + dSDichVu.TenDichVu + "', Gia=" + dSDichVu.Gia + ", danhmuc=" + dSDichVu.danhmuc
+ ",MoTa=N'" + dSDichVu.MoTa + "' where MaDichVu=" + dSDichVu.MaDichVu + "", conn);
cmd.ExecuteNonQuery();
conn.Close();
}
//them dich vu
public void themDichVu(DSDichVu dSDichVu)
{
conn.Open();
SqlCommand cmd = new SqlCommand("insert into dichvu values(@TenDichVu,@Gia,@danhmuc,@mota)", conn);
cmd.Parameters.AddWithValue("@TenDichVu", dSDichVu.TenDichVu);
cmd.Parameters.AddWithValue("@Gia", dSDichVu.Gia);
cmd.Parameters.AddWithValue("@danhmuc", dSDichVu.danhmuc);
cmd.Parameters.AddWithValue("@mota", dSDichVu.MoTa);
cmd.ExecuteNonQuery();
conn.Close();
}
//lay ra 1 dich vu
public DSDichVu layra1dv(int MaDichVu)
{
conn.Open();
SqlCommand cmd = new SqlCommand("select * from dichvu where dichvu.madichvu=" + MaDichVu + "", conn);
DSDichVu dSDichVu = null;
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
dSDichVu = new DSDichVu();
dSDichVu.MaDichVu = (int)reader["MaDichVu"];
dSDichVu.TenDichVu = (string)reader["TenDichVu"];
dSDichVu.Gia = (double)reader["Gia"];
dSDichVu.danhmuc = (int)reader["danhmuc"];
dSDichVu.MoTa = (string)reader["MoTa"];
}
conn.Close();
return(dSDichVu);
}
// lay DSDichVu theo cat_id
public List <DSDichVu> getServices(int danhmuc)
{
List <DSDichVu> li = new List <DSDichVu>();
conn.Open();
SqlCommand cmd = new SqlCommand("select * from dichvu,danh_muc where dichvu.danhmuc=danh_muc.danhmuc and dichvu.danhmuc='" + danhmuc + "'", conn);
SqlDataReader rd = cmd.ExecuteReader();
while (rd.Read())
{
DSDichVu svc = new DSDichVu();
svc.MaDichVu = (int)rd["MaDichVu"];
svc.TenDichVu = (string)rd["TenDichVu"];
svc.Gia = (double)rd["Gia"];
svc.danhmuc = (int)rd["danhmuc"];
svc.MoTa = (string)rd["MoTa"];
li.Add(svc);
}
conn.Close();
return(li);
}
public List <DSDichVu> getAllDichVu()
{
List <DSDichVu> sudungDV = new List <DSDichVu>();
conn.Open();
string sql = "select * from dichvu";
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
DSDichVu dSDichVu = new DSDichVu();
dSDichVu.MaDichVu = (int)reader["MaDichVu"];
dSDichVu.TenDichVu = (string)reader["TenDichVu"];
dSDichVu.Gia = (double)reader["Gia"];
dSDichVu.danhmuc = (int)reader["danhmuc"];
dSDichVu.MoTa = (string)reader["MoTa"];
sudungDV.Add(dSDichVu);
}
conn.Close();
return(sudungDV);
}
