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