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