/// <summary> /// Inserts a row in the doc_FileSystem table. Returns rows affected count. /// </summary> /// <returns>int</returns> public static int Create(FileSystem item) { SqlParameterHelper sph = new SqlParameterHelper(ConnectionStringStatic.GetWriteConnectionString(), "doc_FileSystem_Insert", 10); sph.DefineSqlParameter("@FileSystemGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, item.FileSystemGuid); sph.DefineSqlParameter("@FileSystemID", SqlDbType.NVarChar, 25, ParameterDirection.Input, item.FileSystemID); sph.DefineSqlParameter("@FileType", SqlDbType.NVarChar, 25, ParameterDirection.Input, item.FileType); sph.DefineSqlParameter("@FileSize", SqlDbType.Decimal, ParameterDirection.Input, item.FileSize); sph.DefineSqlParameter("@ClientFileName", SqlDbType.NVarChar, 256, ParameterDirection.Input, item.ClientFileName); sph.DefineSqlParameter("@ServerFileName", SqlDbType.NVarChar, 256, ParameterDirection.Input, item.ServerFileName); sph.DefineSqlParameter("@TableName", SqlDbType.NVarChar, 256, ParameterDirection.Input, item.TableName); sph.DefineSqlParameter("@UpdatedDate", SqlDbType.DateTime, ParameterDirection.Input, item.UpdatedDate); sph.DefineSqlParameter("@UpdatedUser", SqlDbType.UniqueIdentifier, ParameterDirection.Input, item.UpdatedUser); sph.DefineSqlParameter("@ItemGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, item.ItemGuid); int rowsAffected = sph.ExecuteNonQuery(); return rowsAffected; }
private List<FileSystem> LoadListFromReader(IDataReader reader) { List<FileSystem> items = new List<FileSystem>(); try { while (reader.Read()) { FileSystem item = new FileSystem(); item.FileSystemGuid = new Guid(reader["FileSystemGuid"].ToString()); item.FileSystemID = reader["FileSystemID"].ToString(); item.FileType = reader["FileType"].ToString(); item.FileSize = Convert.ToDecimal(reader["FileSize"]); item.ClientFileName = reader["ClientFileName"].ToString(); item.ServerFileName = reader["ServerFileName"].ToString(); try { item.UpdatedDate = Convert.ToDateTime(reader["UpdatedDate"]); } catch (Exception) { } item.UpdatedUser = new Guid(reader["UpdatedUser"].ToString()); item.ItemGuid = new Guid(reader["ItemGuid"].ToString()); item.TableName = reader["TableName"].ToString(); try { item.MapPath = reader["MapPath"].ToString(); } catch { } items.Add(item); } } finally { reader.Close(); } return items; }
private Guid Create(FileSystem item) { item.FileSystemGuid = Guid.NewGuid(); int rowsAffected = FileSystemDAL.Create(item); return rowsAffected > 0 ? item.FileSystemGuid : Guid.Empty; }
// <summary> /// Saves this instance of FileSystem. Returns a new Guid on success. /// </summary> public Guid Save(FileSystem item) { if (item.FileSystemGuid == Guid.Empty) return Create(item); return Guid.Empty; }
private FileSystem PopulateFromReader(IDataReader reader) { FileSystem item = new FileSystem(); if (reader.Read()) { item.FileSystemGuid = new Guid(reader["FileSystemGuid"].ToString()); item.FileSystemID = reader["FileSystemID"].ToString(); item.FileType = reader["FileType"].ToString(); item.FileSize = Convert.ToDecimal(reader["FileSize"]); item.ClientFileName = reader["ClientFileName"].ToString(); item.ServerFileName = reader["ServerFileName"].ToString(); try { item.UpdatedDate = Convert.ToDateTime(reader["UpdatedDate"]); } catch (Exception) { } item.UpdatedUser = new Guid(reader["UpdatedUser"].ToString()); item.ItemGuid = new Guid(reader["ItemGuid"].ToString()); item.TableName = reader["TableName"].ToString(); try { item.MapPath = reader["MapPath"].ToString(); } catch { } } return item; }
private Guid Update(FileSystem item) { return FileSystemDAL.Update(item) ? item.FileSystemGuid : Guid.Empty; }