private Domain.UploadedFile PopulateFromDB(Npgsql.NpgsqlDataReader dr)
{
Domain.UploadedFile file = new Domain.UploadedFile();
file.UploadedFileId = Helper.ConvertFromDBVal <int>(dr[UploadedfileTable.uploadedfileid]);
file.FileName = Helper.ConvertFromDBVal <string>(dr[UploadedfileTable.filename]);
file.FilePath = Helper.ConvertFromDBVal <string>(dr[UploadedfileTable.filepath]);
file.FileType = Helper.ConvertFromDBVal <string>(dr[UploadedfileTable.filetype]);
file.accountID = Helper.ConvertFromDBVal <int>(dr[UploadedfileTable.accountid]);
file.leadID = Helper.ConvertFromDBVal <int>(dr[UploadedfileTable.leadid]);
return(file);
}
public List <Domain.UploadedFile> GetFileByAccountId(int accountId)
{
Domain.UploadedFile upFile = null;
using (Npgsql.NpgsqlConnection conn = new Npgsql.NpgsqlConnection(Infrastructure.ConfigReader.ConnectionString.ToString()))
{
conn.Open();
using (Npgsql.NpgsqlCommand command = new Npgsql.NpgsqlCommand(UploadedfileTable.SelectByAccountIdQuery, conn))
{
command.Parameters.AddWithValue(UploadedfileTable.accountid, accountId);
using (Npgsql.NpgsqlDataReader dr = command.ExecuteReader())
{
while (dr.Read())
{
upFile = PopulateFromDB(dr);
_files.Add(upFile);
}
}
}
}
return(_files);
}
