//Thêm sinh viên public bool Add(DTOCaLam cl) { SqlParameter[] sqlP = new SqlParameter[2]; sqlP[0] = new SqlParameter("@MaCa", cl.MaCa); sqlP[1] = new SqlParameter("@TenCa", cl.TenCa); return(dalGeneric.execNonQuery("insertCaLam", sqlP)); }
//Thêm sinh viên public bool Add(DTOCongViec cv) { SqlParameter[] sqlP = new SqlParameter[2]; sqlP[0] = new SqlParameter("@MaCV", cv.MaCV); sqlP[1] = new SqlParameter("@TenCV", cv.TenCV); return(dalGeneric.execNonQuery("insertCongViec", sqlP)); }
//Thêm sinh viên public bool Add(DTONuocSX nsx) { SqlParameter[] sqlP = new SqlParameter[2]; sqlP[0] = new SqlParameter("@MaNSX", nsx.MaNSX); sqlP[1] = new SqlParameter("@TenNSX", nsx.TenNSX); return(dalGeneric.execNonQuery("insertNSX", sqlP)); }
//Thêm sinh viên public bool Add(DTOLoaiGa lg) { SqlParameter[] sqlP = new SqlParameter[2]; sqlP[0] = new SqlParameter("@MaLoai", lg.MaLoai); sqlP[1] = new SqlParameter("@TenLoai", lg.TenLoai); return(dalGeneric.execNonQuery("insertLoaiGa", sqlP)); }
//Thêm sinh viên public bool Add(DTOMau m) { SqlParameter[] sqlP = new SqlParameter[2]; sqlP[0] = new SqlParameter("@MaMau", m.MaMau); sqlP[1] = new SqlParameter("@TenMau", m.TenMau); return(dalGeneric.execNonQuery("insertMau", sqlP)); }
//Thêm sinh viên public bool Add(DTOKhoiLuong kl) { SqlParameter[] sqlP = new SqlParameter[1]; sqlP[0] = new SqlParameter("@MaKL", kl.MaKL); return(dalGeneric.execNonQuery("insertKhoiLuong", sqlP)); }
//Thêm sinh viên public bool Add(DTONhaCungCap ncc) { SqlParameter[] sqlP = new SqlParameter[4]; sqlP[0] = new SqlParameter("@MaNCC", ncc.MaNCC); sqlP[1] = new SqlParameter("@TenNCC", ncc.TenNCC); sqlP[2] = new SqlParameter("@DiaChi", ncc.DiaChi); sqlP[3] = new SqlParameter("@DienThoai", ncc.DienThoai); return(dalGeneric.execNonQuery("insertNCC", sqlP)); }
public bool Add(DTOKhachHang kh) { SqlParameter[] sqlP = new SqlParameter[4]; sqlP[0] = new SqlParameter("@MaKH", kh.MaKH); sqlP[1] = new SqlParameter("@TenKH", kh.TenKH); sqlP[2] = new SqlParameter("@DiaChi", kh.DiaChi); sqlP[3] = new SqlParameter("@DienThoai", kh.DienThoai); return(dalGeneric.execNonQuery("insertKH", sqlP)); }
//Thêm sinh viên public bool Add(DTOHDBan hdb) { SqlParameter[] sqlP = new SqlParameter[5]; sqlP[0] = new SqlParameter("@SoHDB", hdb.SoHDB); sqlP[1] = new SqlParameter("@MaNV", hdb.MaNV); sqlP[2] = new SqlParameter("@NgayBan", hdb.NgayBan); sqlP[3] = new SqlParameter("@MaKH", hdb.MaKH); sqlP[4] = new SqlParameter("@TongTien", hdb.TongTien); return(dalGeneric.execNonQuery("insertHDB", sqlP)); }
//Thêm sinh viên public bool Add(DTOChiTietHDB cthdb) { SqlParameter[] sqlP = new SqlParameter[5]; sqlP[0] = new SqlParameter("@SoHDB", cthdb.SoHDB); sqlP[1] = new SqlParameter("@MaBinh", cthdb.MaBinh); sqlP[2] = new SqlParameter("@SoLuong", cthdb.SoLuong); sqlP[3] = new SqlParameter("@GiamGia", cthdb.GiamGia); sqlP[4] = new SqlParameter("@ThanhTien", cthdb.ThanhTien); return(dalGeneric.execNonQuery("insertCTHDB", sqlP)); }
//Thêm sinh viên public bool Add(DTOHDNhap hdn) { SqlParameter[] sqlP = new SqlParameter[5]; sqlP[0] = new SqlParameter("@SoHDN", hdn.SoHDN); sqlP[1] = new SqlParameter("@MaNV", hdn.MaNV); sqlP[2] = new SqlParameter("@NgayNhap", hdn.NgayNhap); sqlP[3] = new SqlParameter("@MaNCC", hdn.MaNCC); sqlP[4] = new SqlParameter("@TongTien", hdn.TongTien); return(dalGeneric.execNonQuery("insertHDN", sqlP)); }
//Thêm sinh viên public bool Add(DTOChiTietHDN cthdn) { SqlParameter[] sqlP = new SqlParameter[6]; sqlP[0] = new SqlParameter("@SoHDN", cthdn.SoHDN); sqlP[1] = new SqlParameter("@MaBinh", cthdn.MaBinh); sqlP[2] = new SqlParameter("@SoLuong", cthdn.SoLuong); sqlP[3] = new SqlParameter("@DonGia", cthdn.DonGia); sqlP[4] = new SqlParameter("@GiamGia", cthdn.GiamGia); sqlP[5] = new SqlParameter("@ThanhTien", cthdn.ThanhTien); return(dalGeneric.execNonQuery("insertCTHDN", sqlP)); }
//Thêm sinh viên public bool Add(DTONhanVien nv) { SqlParameter[] sqlP = new SqlParameter[8]; sqlP[0] = new SqlParameter("@MaNV", nv.MaNV); sqlP[1] = new SqlParameter("@TenNV", nv.TenNV); sqlP[2] = new SqlParameter("@GioiTinh", nv.GioiTinh); sqlP[3] = new SqlParameter("@NgaySinh", nv.NgaySinh); sqlP[4] = new SqlParameter("@DiaChi", nv.DiaChi); sqlP[5] = new SqlParameter("@DienThoai", nv.DienThoai); sqlP[6] = new SqlParameter("@MaCa", nv.MaCa); sqlP[7] = new SqlParameter("@MaCV", nv.MaCV); return(dalGeneric.execNonQuery("insertNhanVien", sqlP)); }
//Thêm sinh viên public bool Add(DTOBinhGa bg) { SqlParameter[] sqlP = new SqlParameter[12]; sqlP[0] = new SqlParameter("@MaBinh", bg.MaBinh); sqlP[1] = new SqlParameter("@TenBinh", bg.TenBinh); sqlP[2] = new SqlParameter("@MaKL", bg.MaKL); sqlP[3] = new SqlParameter("@MaLoai", bg.MaLoai); sqlP[4] = new SqlParameter("@MaMau", bg.MaMau); sqlP[5] = new SqlParameter("@MaNSX", bg.MaNSX); sqlP[6] = new SqlParameter("@SoLuong", bg.SoLuong); if (bg.DonGiaNhap == 0) { sqlP[7] = new SqlParameter("@DonGiaNhap", SqlDbType.BigInt); sqlP[7].Value = DBNull.Value; } else { sqlP[7] = new SqlParameter("@DonGiaNhap", bg.DonGiaNhap); } if (bg.DonGiaNhap == 0) { sqlP[8] = new SqlParameter("@DonGiaBan", SqlDbType.BigInt); sqlP[8].Value = DBNull.Value; } else { sqlP[8] = new SqlParameter("@DonGiaBan", bg.DonGiaBan); } sqlP[9] = new SqlParameter("@ThoiGianBaoHanh", bg.ThoiGianBH); if (bg.Anh == null) { sqlP[10] = new SqlParameter("@Anh", SqlDbType.Image); sqlP[10].Value = DBNull.Value; } else { sqlP[10] = new SqlParameter("@Anh", bg.Anh); } if (bg.GhiChu == null) { sqlP[11] = new SqlParameter("@GhiChu", SqlDbType.NVarChar); sqlP[11].Value = DBNull.Value; } else { sqlP[11] = new SqlParameter("@GhiChu", bg.GhiChu); } return(dalGeneric.execNonQuery("insertBinhGa", sqlP)); }