public bool ThemLichTruc(string MaNV, string NgayDiTruc, string CongViecTruc) { return(da.executeNonQuery("spThemLichTruc", CommandType.StoredProcedure, new SqlParameter("@MaNV", MaNV), new SqlParameter("@NgayDiTruc", NgayDiTruc), new SqlParameter("@CongViecTruc", CongViecTruc))); }
public bool ThemLichTaiKham(string MaHD, string NgayTaiKham, string GhiChu) { return(da.executeNonQuery("spThemLichTaiKham", CommandType.StoredProcedure, new SqlParameter("@MaHoaDon", MaHD), new SqlParameter("@NgayTaiKham", NgayTaiKham), new SqlParameter("@GhiChu", GhiChu))); }
public bool CapNhatDapAn(string malanthi, int macauhoi, string dapanchon) { return(da.executeNonQuery("spCapNhatDapAnChon", CommandType.StoredProcedure, new SqlParameter("@malanthi", malanthi), new SqlParameter("@macauhoi", macauhoi), new SqlParameter("@dapanchon", dapanchon))); }
public bool ThemThuoc(string TenThuoc, string MaLT, string TinhTrang, string MoTa) { return(da.executeNonQuery("spThemThuoc", CommandType.StoredProcedure, new SqlParameter("@TenThuoc", TenThuoc), new SqlParameter("@MaLT", MaLT), new SqlParameter("@TinhTrang", TinhTrang), new SqlParameter("@MoTa", MoTa))); }
public bool ThemChiTietThuoc(string MaThuoc, double GiaBanLe, string MaDVT_le) { return(da.executeNonQuery("spThemChiTietThuoc", CommandType.StoredProcedure, new System.Data.SqlClient.SqlParameter("@MaThuoc", MaThuoc), new System.Data.SqlClient.SqlParameter("@GiaBanLe", GiaBanLe), new System.Data.SqlClient.SqlParameter("@MaDVT_le", MaDVT_le) )); }
public bool ThemChiTietHoaDon(string MaHoaDon, string MaThuoc, int SoLuong, string CachDung, int MaDonVi) { return(da.executeNonQuery("spThemChiTietHoaDon", CommandType.StoredProcedure, new SqlParameter("@MaHoaDon", MaHoaDon), new SqlParameter("@MaThuoc", MaThuoc), new SqlParameter("@SoLuong", SoLuong), new SqlParameter("@CachDung", CachDung), new SqlParameter("@MaDonVi", MaDonVi))); }
public bool ThemThongTu(string mathongtu, string tenthongtu, DateTime ngay, string noidung) { return(da.executeNonQuery("spThemThongTu", CommandType.StoredProcedure, new SqlParameter("@MaThongTu", mathongtu), new SqlParameter("@TenThongTu", tenthongtu), new SqlParameter("@Ngay", ngay), new SqlParameter("@NoiDung", noidung) )); }
public bool editProfile(string userName, string hoten, string quequan, DateTime ngaysinh) { return(da.executeNonQuery("spCapNhatProfile", CommandType.StoredProcedure, new System.Data.SqlClient.SqlParameter("@username", userName), new System.Data.SqlClient.SqlParameter("@hoten", hoten), new System.Data.SqlClient.SqlParameter("@quequan", quequan), new System.Data.SqlClient.SqlParameter("@ngaysinh", ngaysinh))); }
public bool ThemNhanVien(string HoTen, DateTime NgaySinh, string QueQuan, string TrinhDo, double Luong, string ChucVu, string Phai) { return(da.executeNonQuery("spThemNV", CommandType.StoredProcedure, new SqlParameter("@HoTen", HoTen), new SqlParameter("@NgaySinh", NgaySinh), new SqlParameter("@QueQuan", QueQuan), new SqlParameter("@TrinhDo", TrinhDo), new SqlParameter("@Luong", Luong), new SqlParameter("@ChucVu", ChucVu), new SqlParameter("@Phai", Phai))); }
public bool ThemHoaDon(float SoTien, string MaKhachHang, bool CoBaoHiem, string MaNV, DateTime NgayLapHoaDon) { return(da.executeNonQuery("spThemHoaDon", CommandType.StoredProcedure, new System.Data.SqlClient.SqlParameter("@SoTien", SoTien), new System.Data.SqlClient.SqlParameter("@MaKhachHang", MaKhachHang), new System.Data.SqlClient.SqlParameter("@CoBaoHiem", CoBaoHiem), new System.Data.SqlClient.SqlParameter("@MaNV", MaNV), new System.Data.SqlClient.SqlParameter("@NgayLapHoaDon", NgayLapHoaDon) )); }
public bool ThemBenhNhan(string TenKhachHang, string QueQuan, string CMND, DateTime NgaySinh, string SDT, string GioiTinh) { return(da.executeNonQuery("spThemBenhNhan", CommandType.StoredProcedure, new System.Data.SqlClient.SqlParameter("@TenKhachHang", TenKhachHang), new System.Data.SqlClient.SqlParameter("@QueQuan", QueQuan), new System.Data.SqlClient.SqlParameter("@CMND", CMND), new System.Data.SqlClient.SqlParameter("@NgaySinh", NgaySinh), new System.Data.SqlClient.SqlParameter("@SDT", SDT), new System.Data.SqlClient.SqlParameter("@GioiTinh", GioiTinh) )); }
public bool ThemDVT(string TenDVT) { return(da.executeNonQuery("spThemDVT", CommandType.StoredProcedure, new SqlParameter("@TenDVT", TenDVT))); }
public bool ThemLoaiThuoc(string TenLoaiThuoc) { return(da.executeNonQuery("spThemLoaiThuoc", CommandType.StoredProcedure, new SqlParameter("@TenLoaiThuoc", TenLoaiThuoc))); }
public bool Backup(string path) { return(dao.executeNonQuery("sp_Backup_Database", System.Data.CommandType.StoredProcedure, new System.Data.SqlClient.SqlParameter("@Location", path))); }
public bool XoaTaiKhoan(string username) { return(da.executeNonQuery("spXoaTaiKhoan", CommandType.StoredProcedure, new SqlParameter("@UserName", username))); }
public bool register(string userName, string password) { return(da.executeNonQuery("spDangKi", CommandType.StoredProcedure, new System.Data.SqlClient.SqlParameter("@username", userName), new System.Data.SqlClient.SqlParameter("@password", password))); }
public bool XoaNganHangCauHoi(int macau) { return(da.executeNonQuery("spXoaNganHangCauHoi", CommandType.StoredProcedure, new SqlParameter("@MaCauHoi", macau))); }
public bool ThemLoaiKinhNghiem(string TenKinhNghiem) { return(da.executeNonQuery("spThemLoaiKinhNghiem", CommandType.StoredProcedure, new System.Data.SqlClient.SqlParameter("@TenLoaiKN", TenKinhNghiem))); }