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