public DataTable GetAllMuaHangByMaNhaCungCap(MuaHangO mh)
{
SqlParameter param = new SqlParameter();
param.ParameterName = "@MaNhaCungCap";
param.Value = mh.MaNhaCungCap;
return(conn.executeSelectQuery("proGetMuaHang_NhaCC_Kho_IfMaNhaCungCap", param));
}
public DataTable getGiaoVienByName(GiaoVienVO gv)
{
string query = string.Format("select * from GiaoVien where TenGV = @TenGV");
SqlParameter[] sqlParameters = new SqlParameter[1];
sqlParameters[0] = new SqlParameter("@TenGV", SqlDbType.NVarChar);
sqlParameters[0].Value = Convert.ToString(gv.TenGV);
return(conn.executeSelectQuery(query, sqlParameters));
}
public DataTable getLopByName(LopVO L)
{
string query = string.Format("select * from Lop where TenLop = @TenLop");
SqlParameter[] sqlParameters = new SqlParameter[1];
sqlParameters[0] = new SqlParameter("@TenLop", SqlDbType.NVarChar);
sqlParameters[0].Value = Convert.ToString(L.TenLop);
return(conn.executeSelectQuery(query, sqlParameters));
}
public DataTable getMonHocByMa(String ma)
{
string query = string.Format("select * from MonHoc where MaMH = @MaMH");
SqlParameter[] sqlParameters = new SqlParameter[1];
sqlParameters[0] = new SqlParameter("@MaMH", SqlDbType.VarChar);
sqlParameters[0].Value = Convert.ToString(ma);
return(conn.executeSelectQuery(query, sqlParameters));
}
public DataTable GetAllChiTietPhieuBanHangByMaPhieuBan(ChiTietPhieuBanHangO ctpbh)
{
SqlParameter param = new SqlParameter();
param.ParameterName = "@MaPhieuBan";
param.Value = ctpbh.MaPhieuBan;
return(conn.executeSelectQuery("proGetChiTietPhieuBanHang_HangHoa_DonVi_IfMaPhieu", param));
}
public DataTable GetAllTonKhoByMaKho(TonKhoO tk)
{
SqlParameter param = new SqlParameter();
param.ParameterName = "@MaKho";
param.Value = tk.MaKho;
return(conn.executeSelectQuery("proGetTonKho_Kho_HangHoa_DonVi_NhomHang_IfMaKho", param));
}
public DataTable GetAllChiTietChuyenKhoByMaPhieuChuyen(ChiTietChuyenKhoO ctpck)
{
SqlParameter param = new SqlParameter();
param.ParameterName = "@MaPhieuChuyen";
param.Value = ctpck.MaPhieuChuyen;
return(conn.executeSelectQuery("proGetChiTietChuyenKho_HangHoa_DonVi_IfMaPhieuChuyen", param));
}
/*
* public DataTable GetAllBanHangByMaKhachHang(BanHangO bh)
* {
* SqlParameter param = new SqlParameter();
* param.ParameterName = "@MaKhachHang";
* param.Value = bh.MaKhachHang;
* return conn.executeSelectQuery("proGetBanHang_NhaCC_Kho_IfMaKH", param);/////
* }
*/
public DataTable GetAllBanHangByMaPhieuBan(BanHangO bh)
{
SqlParameter param = new SqlParameter();
param.ParameterName = "@MaPhieuBan";
param.Value = bh.MaPhieuBan;
return(conn.executeSelectQuery("proGetBanHang_KhachHang_Kho_IfMaPhieuBan", param));
}
public DataTable GetAllChiTietPhieuTraHangByMaPhieuTra(ChiTietTraHangO ctth)
{
SqlParameter param = new SqlParameter();
param.ParameterName = "@MaPhieuTra";
param.Value = ctth.MaPhieuTra;
return(conn.executeSelectQuery("proGetChiTietTraHang_HangHoa_DonVi_IfMaPhieuTra", param));//
}
public DataTable getLichDayTuongTu(LichDayVO lichDay)
{
DataTable dt = new DataTable();
string query = string.Format("select * from LichDayThucHanh where Tuan = @Tuan and Thu = @Thu and MaPhong = @MaPhong");
SqlParameter[] sqlParameters = new SqlParameter[3];
sqlParameters[0] = new SqlParameter("@Tuan", SqlDbType.Int);
sqlParameters[0].Value = lichDay.Tuan;
sqlParameters[1] = new SqlParameter("@Thu", SqlDbType.VarChar);
sqlParameters[1].Value = lichDay.Thu;
sqlParameters[2] = new SqlParameter("@MaPhong", SqlDbType.VarChar);
sqlParameters[2].Value = lichDay.MaPhong;
return(conn.executeSelectQuery(query, sqlParameters));
}
public DataTable getPhongByMa(String Ma)
{
string query = string.Format("select * from Phong where MaPhong = @MaPhong");
SqlParameter[] sqlParameters = new SqlParameter[1];
sqlParameters[0] = new SqlParameter("@MaPhong", SqlDbType.NVarChar);
sqlParameters[0].Value = Convert.ToString(Ma);
return(conn.executeSelectQuery(query, sqlParameters));
}
/// <method>
/// Get User Email By Firstname or Lastname and return DataTable
/// </method>
public DataTable searchByName(string tenDangNhap, string matKhau, int quyen)
{
String query = "";
if (quyen == 1)
{
query = string.Format("select * from Admin where TenDangNhap = @username and MatKhau=@MatKhau");
}
else
{
query = string.Format("select * from Account where TenDangNhap = @username and MatKhau=@MatKhau");
}
SqlParameter[] sqlParameters = new SqlParameter[2];
sqlParameters[0] = new SqlParameter("@username", SqlDbType.VarChar);
sqlParameters[0].Value = Convert.ToString(tenDangNhap);
sqlParameters[1] = new SqlParameter("@MatKhau", SqlDbType.VarChar);
sqlParameters[1].Value = Convert.ToString(matKhau);
return(conn.executeSelectQuery(query, sqlParameters));
}
