public static int InsertDataFile(byte[] data, string filetype, int filesize, string filename, string extention)
{
int i;
using (var conn = DbConnections.GetSqlConnection())
{
var myCommand = new SqlCommand("cp_InsertDataFile", conn)
{
CommandType = CommandType.StoredProcedure
};
myCommand.Parameters.AddWithValue("@Data", data);
myCommand.Parameters.AddWithValue("@FileType", filetype);
myCommand.Parameters.AddWithValue("@FileSize", filesize);
myCommand.Parameters.AddWithValue("@FileName", filename);
myCommand.Parameters.AddWithValue("@Extention", extention);
conn.Open();
var returnValue = new SqlParameter("returnVal", SqlDbType.Int)
{
Direction = ParameterDirection.ReturnValue
};
myCommand.Parameters.Add(returnValue);
myCommand.ExecuteNonQuery();
i = Convert.ToInt32(returnValue.Value);
myCommand.Dispose();
conn.Close();
conn.Dispose();
}
return(i);
}
public static List <DataFile> SelectDataFileList()
{
var myDataFileList = new List <DataFile>();
using (var conn = DbConnections.GetSqlConnection())
{
var myCommand = new SqlCommand("cp_SelectDataFile", conn)
{
CommandType = CommandType.StoredProcedure
};
conn.Open();
var dbReader = myCommand.ExecuteReader();
while (dbReader.Read())
{
myDataFileList.Add(new DataFile(
dbReader.GetInt32(0),
(byte[])dbReader.GetValue(1),
dbReader.GetString(2),
dbReader.GetInt32(3),
dbReader.GetString(4),
dbReader.GetString(5)));
}
dbReader.Close();
dbReader.Dispose();
myCommand.Dispose();
conn.Close();
conn.Dispose();
}
return(myDataFileList);
}
