public static void ExecDODUNG_UpdIntoDataView(XPDataView dataView, Session session, int IdDD, string TenDD, decimal ChiPhiDD)
{
DevExpress.Xpo.DB.SelectedData sprocData = session.ExecuteSproc("DODUNG_Upd", new OperandValue(IdDD), new OperandValue(TenDD), new OperandValue(ChiPhiDD));
dataView.PopulateProperties(session.GetClassInfo(typeof(DODUNG_UpdResult1)));
dataView.LoadData(sprocData);
}
public static void ExecHR_GetEmployeeClassificationsIntoDataView(XPDataView dataView, Session session, int EmployeeClassificationKey)
{
DevExpress.Xpo.DB.SelectedData sprocData = session.ExecuteSproc("HR.GetEmployeeClassifications", new OperandValue(EmployeeClassificationKey));
dataView.PopulateProperties(session.GetClassInfo(typeof(GetEmployeeClassificationsResult)));
dataView.LoadData(sprocData);
}
public static void ExecDICHVU_UpdIntoDataView(XPDataView dataView, Session session, int IdDV, string TenDV, decimal DonGiaDV, string GhiChu)
{
DevExpress.Xpo.DB.SelectedData sprocData = session.ExecuteSproc("DICHVU_Upd", new OperandValue(IdDV), new OperandValue(TenDV), new OperandValue(DonGiaDV), new OperandValue(GhiChu));
dataView.PopulateProperties(session.GetClassInfo(typeof(DICHVU_UpdResult2)));
dataView.LoadData(sprocData);
}
public static void ExecBOPHAN_UpdIntoDataView(XPDataView dataView, Session session, int IdBP, string TenBP, string GhiChu)
{
DevExpress.Xpo.DB.SelectedData sprocData = session.ExecuteSproc("BOPHAN_Upd", new OperandValue(IdBP), new OperandValue(TenBP), new OperandValue(GhiChu));
dataView.PopulateProperties(session.GetClassInfo(typeof(BOPHAN_UpdResult2)));
dataView.LoadData(sprocData);
}
public static void ExecSalesByCategoryIntoDataView(XPDataView dataView, Session session, string CategoryName, string OrdYear)
{
DevExpress.Xpo.DB.SelectedData sprocData = session.ExecuteSproc("SalesByCategory", new OperandValue(CategoryName), new OperandValue(OrdYear));
dataView.PopulateProperties(session.GetClassInfo(typeof(SalesByCategoryResult)));
dataView.LoadData(sprocData);
}
public static void ExecMANHINH_UpdIntoDataView(XPDataView dataView, Session session, int IdMH, string TenMH)
{
DevExpress.Xpo.DB.SelectedData sprocData = session.ExecuteSproc("MANHINH_Upd", new OperandValue(IdMH), new OperandValue(TenMH));
dataView.PopulateProperties(session.GetClassInfo(typeof(MANHINH_UpdResult1)));
dataView.LoadData(sprocData);
}
public static void ExecNHANVIEN_ByIdIntoDataView(XPDataView dataView, Session session, int IdNV)
{
DevExpress.Xpo.DB.SelectedData sprocData = session.ExecuteSproc("NHANVIEN_ById", new OperandValue(IdNV));
dataView.PopulateProperties(session.GetClassInfo(typeof(NHANVIEN_ByIdResult)));
dataView.LoadData(sprocData);
}
public static void ExecVehicleNotRacedByPeriodeIntoDataView(XPDataView dataView, Session session, DateTime Date)
{
DevExpress.Xpo.DB.SelectedData sprocData = session.ExecuteSproc("VehicleNotRacedByPeriode", new OperandValue(Date));
dataView.PopulateProperties(session.GetClassInfo(typeof(VehicleNotRacedByPeriodeResult)));
dataView.LoadData(sprocData);
}
public static void Execsp_helpdiagramsIntoDataView(XPDataView dataView, Session session, string diagramname, int owner_id)
{
DevExpress.Xpo.DB.SelectedData sprocData = session.ExecuteSproc("sp_helpdiagrams", new OperandValue(diagramname), new OperandValue(owner_id));
dataView.PopulateProperties(session.GetClassInfo(typeof(sp_helpdiagramsResult)));
dataView.LoadData(sprocData);
}
public static void Execsp_helpdiagramsIntoDataView(XPDataView dataView, Session session, string diagramname, int owner_id)
{
DevExpress.Xpo.DB.SelectedData sprocData = session.ExecuteSproc("sp_helpdiagrams", new OperandValue(diagramname), new OperandValue(owner_id));
dataView.PopulateProperties(session.GetClassInfo(typeof(sp_helpdiagramsResult)));
dataView.LoadData(sprocData);
}
public static void ExecTurnOverCustomerAscendingIntoDataView(XPDataView dataView, Session session)
{
DevExpress.Xpo.DB.SelectedData sprocData = session.ExecuteSproc("TurnOverCustomerAscending");
dataView.PopulateProperties(session.GetClassInfo(typeof(TurnOverCustomerAscendingResult)));
dataView.LoadData(sprocData);
}
public static void ExecVehicleNotRacedByPeriodeIntoDataView(XPDataView dataView, Session session, DateTime Date)
{
DevExpress.Xpo.DB.SelectedData sprocData = session.ExecuteSproc("VehicleNotRacedByPeriode", new OperandValue(Date));
dataView.PopulateProperties(session.GetClassInfo(typeof(VehicleNotRacedByPeriodeResult)));
dataView.LoadData(sprocData);
}
public static void ExecCustOrdersOrdersIntoDataView(XPDataView dataView, Session session, string CustomerID)
{
DevExpress.Xpo.DB.SelectedData sprocData = session.ExecuteSproc("CustOrdersOrders", new OperandValue(CustomerID));
dataView.PopulateProperties(session.GetClassInfo(typeof(CustOrdersOrdersResult)));
dataView.LoadData(sprocData);
}
public static void ExecTenMostExpensiveProductsIntoDataView(XPDataView dataView, Session session)
{
DevExpress.Xpo.DB.SelectedData sprocData = session.ExecuteSproc("Ten Most Expensive Products");
dataView.PopulateProperties(session.GetClassInfo(typeof(TenMostExpensiveProductsResult)));
dataView.LoadData(sprocData);
}
public static void ExecDOUONG_InsIntoDataView(XPDataView dataView, Session session, string TenDU, string DVT, decimal DonGia, decimal DonGia_PS, string GhiChu)
{
DevExpress.Xpo.DB.SelectedData sprocData = session.ExecuteSproc("DOUONG_Ins", new OperandValue(TenDU), new OperandValue(DVT), new OperandValue(DonGia), new OperandValue(DonGia_PS), new OperandValue(GhiChu));
dataView.PopulateProperties(session.GetClassInfo(typeof(DOUONG_InsResult1)));
dataView.LoadData(sprocData);
}
public static void ExecTurnOverCustomerAscendingIntoDataView(XPDataView dataView, Session session)
{
DevExpress.Xpo.DB.SelectedData sprocData = session.ExecuteSproc("TurnOverCustomerAscending");
dataView.PopulateProperties(session.GetClassInfo(typeof(TurnOverCustomerAscendingResult)));
dataView.LoadData(sprocData);
}
public static void ExecLOAITIEC_InsIntoDataView(XPDataView dataView, Session session, string TenLT)
{
DevExpress.Xpo.DB.SelectedData sprocData = session.ExecuteSproc("LOAITIEC_Ins", new OperandValue(TenLT));
dataView.PopulateProperties(session.GetClassInfo(typeof(LOAITIEC_InsResult1)));
dataView.LoadData(sprocData);
}
public static void ExecGetIndexUebersichtIntoDataView(XPDataView dataView, Session session)
{
DevExpress.Xpo.DB.SelectedData sprocData = session.ExecuteSproc("GetIndexUebersicht");
dataView.PopulateProperties(session.GetClassInfo(typeof(GetIndexUebersichtResult)));
dataView.LoadData(sprocData);
}
public static void ExecMONAN_DelIntoDataView(XPDataView dataView, Session session, int IdMA)
{
DevExpress.Xpo.DB.SelectedData sprocData = session.ExecuteSproc("MONAN_Del", new OperandValue(IdMA));
dataView.PopulateProperties(session.GetClassInfo(typeof(MONAN_DelResult1)));
dataView.LoadData(sprocData);
}
public static void ExecHR_CountEmployeesByClassificationIntoDataView(XPDataView dataView, Session session)
{
DevExpress.Xpo.DB.SelectedData sprocData = session.ExecuteSproc("HR.CountEmployeesByClassification");
dataView.PopulateProperties(session.GetClassInfo(typeof(CountEmployeesByClassificationResult)));
dataView.LoadData(sprocData);
}
public static void ExecKHACHHANG_GetAllIntoDataView(XPDataView dataView, Session session)
{
DevExpress.Xpo.DB.SelectedData sprocData = session.ExecuteSproc("KHACHHANG_GetAll");
dataView.PopulateProperties(session.GetClassInfo(typeof(KHACHHANG_GetAllResult)));
dataView.LoadData(sprocData);
}
public static void ExecHR_CreateEmployeeClassificationIntoDataView(XPDataView dataView, Session session, string EmployeeClassificationName, bool IsExempt, bool IsEmployee)
{
DevExpress.Xpo.DB.SelectedData sprocData = session.ExecuteSproc("HR.CreateEmployeeClassification", new OperandValue(EmployeeClassificationName), new OperandValue(IsExempt), new OperandValue(IsEmployee));
dataView.PopulateProperties(session.GetClassInfo(typeof(CreateEmployeeClassificationResult)));
dataView.LoadData(sprocData);
}
public static void ExecDANGNHAPIntoDataView(XPDataView dataView, Session session, string TenDangNhap, string MatKhau)
{
DevExpress.Xpo.DB.SelectedData sprocData = session.ExecuteSproc("DANGNHAP", new OperandValue(TenDangNhap), new OperandValue(MatKhau));
dataView.PopulateProperties(session.GetClassInfo(typeof(DANGNHAPResult)));
dataView.LoadData(sprocData);
}
public static void ExecSalesbyYearIntoDataView(XPDataView dataView, Session session, DateTime Beginning_Date, DateTime Ending_Date)
{
DevExpress.Xpo.DB.SelectedData sprocData = session.ExecuteSproc("Sales by Year", new OperandValue(Beginning_Date), new OperandValue(Ending_Date));
dataView.PopulateProperties(session.GetClassInfo(typeof(SalesbyYearResult)));
dataView.LoadData(sprocData);
}
