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