public DataSet GetCustomerPreAssessment2(int id, ElementReasonTypeEnum elementReasonType)
{
try
{
SqlParameter[] aParam = new SqlParameter[] {
ParametroSql.add("@ID", SqlDbType.Int, 4, id),
ParametroSql.add("@PreAssessment", SqlDbType.Int, 4, (int)elementReasonType)
};
DataSet ds = SqlHelper.ExecuteDataset("ObtenerCustomerPreAssessmentEntity", aParam);
if (ds.Tables.Count != 0)
{
int i = 0;
ds.Tables[i++].TableName = Administrative.Entities.TableNames.CustomerPreAssessmentTable;
ds.Tables[i++].TableName = Administrative.Entities.TableNames.CustomerPreAssessmentTypeRelTable;
ds.Tables[i++].TableName = Administrative.Entities.TableNames.CustomerPreAssessmentReasonRelTable;
ds.Tables[i++].TableName = BackOffice.Entities.TableNames.EpisodeReasonTypeTable;
ds.Tables[i++].TableName = Administrative.Entities.TableNames.EpisodeReasonTable;
ds.Tables[i++].TableName = BackOffice.Entities.TableNames.EpisodeReasonElementRelTable;
ds.Tables[i++].TableName = BackOffice.Entities.TableNames.PreAssessmentTypeTable;
ds.Tables[i++].TableName = BackOffice.Entities.TableNames.AssistanceDegreeTable;
ds.Tables[i++].TableName = Administrative.Entities.TableNames.CustomerPreAssessmentCustomerTemplateRelTable;
return(ds);
}
else
{
return(null);
}
}
catch (Exception ex)
{
if (ExceptionPolicy.HandleException(ex, ExceptionPolicies.DataAccess))
{
throw;
}
else
{
return(null);
}
}
}
public DataSet GetCustomerPreAssessment(int id, ElementReasonTypeEnum elementReasonType)
{
try
{
DataSet ds = this.Gateway.ExecuteStoredProcedureDataSet("ObtenerCustomerPreAssessmentEntity",
new StoredProcInParam("ID", DbType.Int32, id),
new StoredProcInParam("PreAssessment", DbType.Int32, (int)elementReasonType)
);
if (ds.Tables.Count != 0)
{
int i = 0;
ds.Tables[i++].TableName = Administrative.Entities.TableNames.CustomerPreAssessmentTable;
ds.Tables[i++].TableName = Administrative.Entities.TableNames.CustomerPreAssessmentTypeRelTable;
ds.Tables[i++].TableName = Administrative.Entities.TableNames.CustomerPreAssessmentReasonRelTable;
ds.Tables[i++].TableName = BackOffice.Entities.TableNames.EpisodeReasonTypeTable;
ds.Tables[i++].TableName = Administrative.Entities.TableNames.EpisodeReasonTable;
ds.Tables[i++].TableName = BackOffice.Entities.TableNames.EpisodeReasonElementRelTable;
ds.Tables[i++].TableName = BackOffice.Entities.TableNames.PreAssessmentTypeTable;
ds.Tables[i++].TableName = BackOffice.Entities.TableNames.AssistanceDegreeTable;
ds.Tables[i++].TableName = Administrative.Entities.TableNames.CustomerPreAssessmentCustomerTemplateRelTable;
return(ds);
}
else
{
return(null);
}
}
catch (Exception ex)
{
if (ExceptionPolicy.HandleException(ex, ExceptionPolicies.DataAccess))
{
throw;
}
else
{
return(null);
}
}
}
