public DataSet Save(DataSet ds, string phase, string year, string createdBy)
{
DACultureResources oDACultureRes = new DACultureResources();
Entities.SP_USP_ImportMysteryShopper objSP = new Entities.SP_USP_ImportMysteryShopper(createdBy, phase, year, ds.GetXml());
DataSet dsMysteryShopperHeader = oDACultureRes.ExecuteStoredProcedure(Entities.SP_USP_ImportMysteryShopper.SP_NAME, objSP.ParamsList);
return(dsMysteryShopperHeader);
}
public DataSet GetMysteryShopperById(string mysteryShopperId)
{
DACultureResources oDACultureRes = new DACultureResources();
Entities.SP_USP_GetMysteryShopperById usp = new Entities.SP_USP_GetMysteryShopperById(mysteryShopperId.ToString());
DataSet ds = oDACultureRes.ExecuteStoredProcedure(Entities.SP_USP_GetMysteryShopperById.SP_NAME, usp.ParamsList);
ds.Tables[0].TableName = Entities.MysteryShopperHeader.TABLE_NAME;
ds.Tables[1].TableName = Entities.MysteryShopperData.TABLE_NAME;
return(ds);
}
public DataSet GetDrivingAssessmentTestForDriver(string refNum)
{
DACultureResources oDA = new DACultureResources();
Entities.SP_USP_GetDrivingAssessmentTestForDriver usp = new Entities.SP_USP_GetDrivingAssessmentTestForDriver(refNum);
DataSet ds = oDA.ExecuteStoredProcedure(Entities.SP_USP_GetDrivingAssessmentTestForDriver.SP_NAME, usp.ParamsList);
if (ds != null)
{
if (!ds.Tables[0].Columns.Contains(Entities.SP_USP_GetDrivingAssessmentTestForDriver.MUTILPLE_PERSON) &&
!ds.Tables[0].Columns.Contains(Entities.SP_USP_GetDrivingAssessmentTestForDriver.NO_PERSON)
)
{
ds.Tables[0].TableName = Entities.Persons.TABLE_NAME;
ds.Tables[1].TableName = Entities.DrivingAssessmentTest.TABLE_NAME;
ds.Tables[2].TableName = Entities.DrivingAssessmentDetails.TABLE_NAME;
ds.Tables[3].TableName = Entities.DrivingAssessmentImages.TABLE_NAME;
}
}
return(ds);
}