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