//------------------------------------------
#endregion
#region --------------Update--------------
public bool Update(ItemsFilesEntity ItemsFiles)
{
using (SqlConnection myConnection = GetSqlConnection())
{
SqlCommand myCommand = new SqlCommand("ItemsFiles_Update", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
// Set the parameters
myCommand.Parameters.Add("@FileID", SqlDbType.Int, 4).Value = ItemsFiles.FileID;
myCommand.Parameters.Add("@FileExtension", SqlDbType.VarChar).Value = ItemsFiles.FileExtension;
myCommand.Parameters.Add("@FileType", SqlDbType.Int, 4).Value = (int)ItemsFiles.FileType;
//----------------------------------------------------------------------------------
myCommand.Parameters.Add("@LastUpdateUserName", SqlDbType.NVarChar, 64).Value = (string)ItemsFiles.LastUpdateUserName;
myCommand.Parameters.Add("@Title", SqlDbType.VarChar).Value = ItemsFiles.Title;
//----------------------------------------------------------------------------------------------
//OwnerID
myCommand.Parameters.Add("@OwnerID", SqlDbType.UniqueIdentifier).Value = ItemsFiles.OwnerID;
//----------------------------------------------------------------------------------------------
// Execute the command
bool status = false;
myConnection.Open();
if (myCommand.ExecuteNonQuery() > 0)
{
status = true;
}
myConnection.Close();
return(status);
}
}
//------------------------------------------
#endregion
#region --------------Create--------------
/// <summary>
/// Converts the ItemsFiles object properties to SQL paramters and executes the create ItemsFiles procedure
/// and updates the ItemsFiles object with the SQL data by reference.
/// <example>[Example]bool status=ItemsFilesSqlDataPrvider.Instance.Create(ItemsFiles);.</example>
/// </summary>
/// <param name="ItemsFiles">The ItemsFiles object.</param>
/// <returns>The status of create query.</returns>
public bool Create(ItemsFilesEntity ItemsFiles)
{
using (SqlConnection myConnection = GetSqlConnection())
{
SqlCommand myCommand = new SqlCommand("ItemsFiles_Create", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
// Set the parameters
myCommand.Parameters.Add("@FileID", SqlDbType.Int, 4).Direction = ParameterDirection.Output;
myCommand.Parameters.Add("@ItemID", SqlDbType.Int, 4).Value = ItemsFiles.ItemID;
myCommand.Parameters.Add("@FileExtension", SqlDbType.VarChar).Value = ItemsFiles.FileExtension;
myCommand.Parameters.Add("@FileType", SqlDbType.Int, 4).Value = (int)ItemsFiles.FileType;
myCommand.Parameters.Add("@ModuleTypeID", SqlDbType.Int, 4).Value = (int)ItemsFiles.ModuleTypeID;
//----------------------------------------------------------------------------------
myCommand.Parameters.Add("@InsertUserName", SqlDbType.NVarChar, 64).Value = (string)ItemsFiles.InsertUserName;
myCommand.Parameters.Add("@Title", SqlDbType.VarChar).Value = ItemsFiles.Title;
//----------------------------------------------------------------------------------------------
//OwnerID
myCommand.Parameters.Add("@OwnerID", SqlDbType.UniqueIdentifier).Value = ItemsFiles.OwnerID;
myCommand.Parameters.Add("@OwnerName", SqlDbType.VarChar).Value = ItemsFiles.OwnerName;
//----------------------------------------------------------------------------------------------
// Execute the command
bool status = false;
myConnection.Open();
if (myCommand.ExecuteNonQuery() > 0)
{
status = true;
//Get ID value from database and set it in object
ItemsFiles.FileID = (int)myCommand.Parameters["@FileID"].Value;
}
myConnection.Close();
return(status);
}
}
public ItemsFilesEntity GetObject(int FileID)
{
ItemsFilesEntity ItemsFiles = null;
using (SqlConnection myConnection = GetSqlConnection())
{
SqlCommand myCommand = new SqlCommand("ItemsFiles_GetOneByID", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
// Set the parameters
myCommand.Parameters.Add("@FileID", SqlDbType.Int, 4).Value = FileID;
//----------------------------------------------------------------------------------------------
//OwnerID
myCommand.Parameters.Add("@OwnerID", SqlDbType.UniqueIdentifier).Value = SitesHandler.GetOwnerIDAsGuid();
//----------------------------------------------------------------------------------------------
// Execute the command
myConnection.Open();
using (SqlDataReader dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection))
{
if (dr.Read())
{
ItemsFiles = PopulateItemsFilesEntityFromIDataReader(dr);
}
dr.Close();
}
myConnection.Close();
return(ItemsFiles);
}
}
//------------------------------------------
#endregion
#region --------------Delete--------------
/// <summary>
/// Deletes single ItemsFiles object .
/// <example>[Example]bool status=ItemsFilesFactory.Delete(photoID);.</example>
/// </summary>
/// <param name="photoID">The ItemsFiles id.</param>
/// <returns>Status of delete operation.</returns>
public static bool Delete(int fileID)
{
ItemsFilesEntity itemFile = GetObject(fileID);
bool status = ItemsFilesSqlDataPrvider.Instance.Delete(fileID);
if (status)
{
DeleteFiles(itemFile);
}
return(status);
}
/// <summary>
/// Creates ItemsFiles object by calling ItemsFiles data provider create method.
/// <example>[Example]bool status=ItemsFilesFactory.Create(ItemsFiles);.</example>
/// </summary>
/// <param name="ItemsFiles">The ItemsFiles object.</param>
/// <returns>Status of create operation.</returns>
public static bool Create(ItemsFilesEntity itemFile)
{
//Insert user name------------------------------------------
string username = "";
if (HttpContext.Current.User.Identity.IsAuthenticated)
{
username = HttpContext.Current.User.Identity.Name;
itemFile.InsertUserName = username;
}
//----------------------------------------------------------
return(ItemsFilesSqlDataPrvider.Instance.Create(itemFile));
}
//------------------------------------------
#endregion
public static void DeleteFiles(ItemsFilesEntity itemFile)
{
HttpContext context = HttpContext.Current;
//ItemsEntity item = ItemsFactory.GetObject(itemFile.ItemID,
//-----------------------------
if (!string.IsNullOrEmpty(itemFile.FileExtension))
{
if (itemFile.FileType == ItemFileTypes.Photo)
{
//Delete old Thumbnails
File.Delete(DCServer.MapPath(DCSiteUrls.GetPath_ItemsFiles(itemFile.OwnerName, itemFile.ModuleTypeID, itemFile.CategoryID, itemFile.ItemID)) + itemFile.GetPhotoName(PhotoTypes.Thumb));
}
File.Delete(DCServer.MapPath(DCSiteUrls.GetPath_ItemsFiles(itemFile.OwnerName, itemFile.ModuleTypeID, itemFile.CategoryID, itemFile.ItemID)) + itemFile.GetPhotoName(PhotoTypes.Big));
//------------------------------------------------
}
//Delete old original photo
File.Delete(DCServer.MapPath(DCSiteUrls.GetPath_ItemsFiles(itemFile.OwnerName, itemFile.ModuleTypeID, itemFile.CategoryID, itemFile.ItemID)) + itemFile.File);
}
//------------------------------------------
#endregion
#region --------------PopulateItemsFilesEntityFromIDataReader--------------
private ItemsFilesEntity PopulateItemsFilesEntityFromIDataReader(IDataReader reader)
{
//Create a new ItemsFiles object
ItemsFilesEntity ItemsFiles = new ItemsFilesEntity();
//Fill the object with data
//FileID
if (reader["FileID"] != DBNull.Value)
{
ItemsFiles.FileID = (int)reader["FileID"];
}
//ItemID
if (reader["ItemID"] != DBNull.Value)
{
ItemsFiles.ItemID = (int)reader["ItemID"];
}
//FileExtension
if (reader["FileExtension"] != DBNull.Value)
{
ItemsFiles.FileExtension = (string)reader["FileExtension"];
}
//FileType
if (reader["FileType"] != DBNull.Value)
{
ItemsFiles.FileType = (ItemFileTypes)reader["FileType"];
}
//------------------------------------------------------------------
//InsertUserName
if (reader["InsertUserName"] != DBNull.Value)
{
ItemsFiles.InsertUserName = (string)reader["InsertUserName"];
}
//------------------------------------------------------------------
//ModuleTypeID
if (reader["ModuleTypeID"] != DBNull.Value)
{
ItemsFiles.ModuleTypeID = (int)reader["ModuleTypeID"];
}
//------------------------------------------------------------------
//LastUpdateUserName
if (reader["LastUpdateUserName"] != DBNull.Value)
{
ItemsFiles.LastUpdateUserName = (string)reader["LastUpdateUserName"];
}
//------------------------------------------------------------------
//Title
if (reader["Title"] != DBNull.Value)
{
ItemsFiles.Title = (string)reader["Title"];
}
//------------------------------------------------------------------
//OwnerID
if (reader["OwnerID"] != DBNull.Value)
{
ItemsFiles.OwnerID = (Guid)reader["OwnerID"];
}
//------------------------------------------------------------------
//OwnerName
if (reader["OwnerName"] != DBNull.Value)
{
ItemsFiles.OwnerName = (string)reader["OwnerName"];
}
//------------------------------------------------------------------
//CategoryID
if (reader["CategoryID"] != DBNull.Value)
{
ItemsFiles.CategoryID = (int)reader["CategoryID"];
}
//------------------------------------------------------------------
//Return the populated object
return(ItemsFiles);
}
