public static List <FoundationDataFileState.FileInfo> RetrieveAllSharedInfo(int foundationId)
{
var parameters = new ParameterSet();
parameters.Add(DbType.Int32, "FOUNDATION_ID", foundationId);
var command = new Command
{
SqlStatementId = "SELECT_ALL_SHARED_INFO",
ParameterCollection = parameters
};
var access = new DataAccess();
var requestSupporitngFiles = new List <FoundationDataFileState.FileInfo>();
using (MySqlDataReader reader = access.GetReader(command))
{
while (reader.Read())
{
if (!reader.IsDBNull(0))
{
var fileIds = new FoundationDataFileState.FileInfo
{
DocumentId = reader.IsDBNull(0) ? Guid.Empty : reader.GetGuid(0),
FileName = reader.IsDBNull(1) ? "" : reader.GetString(1)
};
fileIds.FilePath = "\\Shared_Documents\\" + fileIds.FileName;
requestSupporitngFiles.Add(fileIds);
}
}
}
return(requestSupporitngFiles);
}
public static List <FoundationDataFileState.FileInfo> RetrieveAllMergeTemplateInfoByFoundation(int foundationId)
{
var parameters = new ParameterSet();
parameters.Add(DbType.Int32, "FOUNDATION_ID", foundationId);
var command = new Command
{
SqlStatementId = "SELECT_ALL_MERGE_TEMPLATE_INFO_BY_FOUNDATION",
ParameterCollection = parameters
};
var access = new DataAccess();
var requestSupportingFiles = new List <FoundationDataFileState.FileInfo>();
using (MySqlDataReader reader = access.GetReader(command))
{
while (reader.Read())
{
if (!reader.IsDBNull(0))
{
var fileIds = new FoundationDataFileState.FileInfo
{
MergeTemplateId = reader.IsDBNull(0) ? -1 : reader.GetInt32(0),
FileName = reader.IsDBNull(1) ? "" : reader.GetString(1)
};
fileIds.FilePath = "\\Merge_Templates\\" + fileIds.MergeTemplateId + "_" + fileIds.FileName;
requestSupportingFiles.Add(fileIds);
}
}
}
return(requestSupportingFiles);
}
public static List <FoundationDataFileState.FileInfo> RetrieveAllRequestInfo(int foundationId)
{
var parameters = new ParameterSet();
parameters.Add(DbType.Int32, "FOUNDATION_ID", foundationId);
var command = new Command
{
SqlStatementId = "SELECT_ALL_REQUEST_INFO",
ParameterCollection = parameters
};
var access = new DataAccess();
var requestSupporitngFiles = new List <FoundationDataFileState.FileInfo>();
using (MySqlDataReader reader = access.GetReader(command))
{
while (reader.Read())
{
if (!reader.IsDBNull(0))
{
var fileIds = new FoundationDataFileState.FileInfo
{
AnswerId = reader.GetGuid(0),
SubmissionId = reader.IsDBNull(1) ? -1 : reader.GetInt32(1),
RequestId = reader.IsDBNull(2) ? -1 : reader.GetInt32(2),
FileName = reader.IsDBNull(3)
? ""
: reader.GetString(3)
.Split(new [] { "[:|:]" }, StringSplitOptions.None)[0],
Question = reader.IsDBNull(5) ? "" : reader.GetString(5),
ProcessId = reader.IsDBNull(7) ? -1 : reader.GetInt32(7),
RequestGuid = reader.IsDBNull(8) ? Guid.Empty : reader.GetGuid(8)
};
fileIds.FilePath = "Requests\\Submissions\\" + fileIds.RequestId + "_" + fileIds.SubmissionId + "_"
+ fileIds.FileName;
requestSupporitngFiles.Add(fileIds);
}
}
}
return(requestSupporitngFiles);
}
public static List <FoundationDataFileState.FileInfo> RetrieveAllOrganizationSupportingInfo(int foundationId)
{
var parameters = new ParameterSet();
parameters.Add(DbType.Int32, "FOUNDATION_ID", foundationId);
var command = new Command
{
SqlStatementId = "SELECT_ALL_ORGANIZATION_SUPPORTING_INFO",
ParameterCollection = parameters
};
var access = new DataAccess();
var requestSupporitngFiles = new List <FoundationDataFileState.FileInfo>();
using (MySqlDataReader reader = access.GetReader(command))
{
while (reader.Read())
{
if (!reader.IsDBNull(0))
{
var fileIds = new FoundationDataFileState.FileInfo
{
OrganizationId = reader.IsDBNull(0) ? Guid.Empty : reader.GetGuid(0),
DocumentId = reader.IsDBNull(1) ? Guid.Empty : reader.GetGuid(1),
FileName = reader.IsDBNull(2) ? "" : reader.GetString(2),
OrganizationName = reader.IsDBNull(4) ? "" : reader.GetString(4),
OrganizationTaxId = reader.IsDBNull(5) ? "" : reader.GetString(5),
};
fileIds.FilePath = "\\Organizations\\" + fileIds.OrganizationId + "_OS_" + fileIds.FileName;
requestSupporitngFiles.Add(fileIds);
}
}
}
return(requestSupporitngFiles);
}
public static List <FoundationDataFileState.FileInfo> RetrieveRequestSupportingInfo(int foundationProcess)
{
var parameters = new ParameterSet();
parameters.Add(DbType.Int32, "FOUNDATION_PROCESS", foundationProcess);
var command = new Command
{
SqlStatementId = "SELECT_REQUEST_SUPPORTING_INFO",
ParameterCollection = parameters
};
var access = new DataAccess();
var requestSupporitngFiles = new List <FoundationDataFileState.FileInfo>();
using (MySqlDataReader reader = access.GetReader(command))
{
while (reader.Read())
{
if (!reader.IsDBNull(0))
{
var fileIds = new FoundationDataFileState.FileInfo
{
RequestId = reader.GetInt32(0),
DocumentId = reader.IsDBNull(1) ? Guid.Empty : reader.GetGuid(1),
FileName = reader.IsDBNull(2) ? "" : reader.GetString(2),
RequestGuid = reader.IsDBNull(4) ? Guid.Empty : reader.GetGuid(4),
};
fileIds.FilePath = "\\Requests\\Supporting\\" + fileIds.RequestId + "_RS_" + fileIds.FileName;
requestSupporitngFiles.Add(fileIds);
}
}
}
return(requestSupporitngFiles);
}
