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