Beispiel #1
0
 private static void DeleteFile(Guid? resourceId)
 {
     ResourceManager resMgr = new ResourceManager();
     resMgr.DeleteResource(resourceId);
 }
Beispiel #2
0
        /// <summary>
        /// Adds as new user  
        /// </summary>
        /// <param name="info"></param>
        /// <param name="resourceInfo"></param>
        /// <returns></returns>
        public string AddUser(UserInfo info, ResourceInfo resourceInfo)
        {
            string directory = String.Empty;
            Guid? resourceId = null;
            bool hasImage = false;
            bool hasDirectory = false;
            try
            {
                // Create Directory
                DirectoryManager dirMgr = new DirectoryManager();
                directory = dirMgr.CreateDirectory();

                if (!String.IsNullOrWhiteSpace(directory))
                    hasDirectory = true;

                hasImage = resourceInfo.Data != null;

                if (hasImage)
                {
                    // Add Resource to that directory
                    ResourceManager mgr = new ResourceManager();
                    resourceId = mgr.AddResource(resourceInfo, directory, EnumPostType.Picture);
                }

                using (SqlDataAdapter adapter = new SqlDataAdapter("[user].[AddUserInfo]", AppConfigManager.ConnectionString))
                {
                    adapter.SelectCommand.CommandType = CommandType.StoredProcedure;

                    adapter.SelectCommand.Parameters.AddWithValue("@UserName", info.UserName);
                    adapter.SelectCommand.Parameters.AddWithValue("@DisplayName", info.DisplayName);
                    adapter.SelectCommand.Parameters.AddWithValue("@OwnNumber", info.OwnNumber);
                    adapter.SelectCommand.Parameters.AddWithValue("@GenderId", info.GenderId);
                    adapter.SelectCommand.Parameters.AddWithValue("@AgeRangeId", info.AgeRangeId);
                    adapter.SelectCommand.Parameters.AddWithValue("@Status", info.Status);
                    adapter.SelectCommand.Parameters.AddWithValue("@ImageIdf", resourceId);

                    var nodeParam = adapter.SelectCommand.Parameters.Add("@FolderPath", SqlDbType.Udt);
                    nodeParam.Value = SqlHierarchyId.Parse(directory);
                    nodeParam.UdtTypeName = "HierarchyId";

                    adapter.SelectCommand.Parameters.AddWithValue("@TerritoryId", info.TerritoryId);

                    DataTable dt = new DataTable();

                    // Gets UserId of Inserted User
                    adapter.Fill(dt);

                    if (dt != null && dt.Rows.Count > 0)
                    {
                        var userIdf = dt.Rows[0][CodeHelper.Idf];
                        var userFolderPath = dt.Rows[0][CodeHelper.FolderPath];
                        if (userIdf != null && userFolderPath != null)
                            return JsonWebToken.Encode(new TokenInfo() { Idf = Guid.Parse(userIdf.ToString()), FolderPath = userFolderPath.ToString(), TerritoryId = info.TerritoryId }, CodeHelper.SecretAccessKey, HvHashAlgorithm.RS256);

                    }

                    if (resourceId != null)
                        DeleteFile(resourceId);
                    // Delete directory and file
                    if (hasDirectory)
                        DeleteDirectory(directory);

                    throw new Exception(CodeHelper.UnableToAddUser);
                }
            }
            catch (Exception ex)
            {
                string msg = ex.Message;

                if (resourceId != null)
                    DeleteFile(resourceId);
                // Delete directory and file
                if (hasDirectory)
                    DeleteDirectory(directory);
                throw new Exception(CodeHelper.UnableToAddUser);
            }
        }
Beispiel #3
0
        /// <summary>
        /// Change profile picture
        /// </summary>
        /// <param name="userIdf"></param>
        /// <param name="name"></param>
        /// <returns></returns>
        public string ChangeProfilePicture(Guid userIdf, string folderPath, byte[] data)
        {
            Guid? oldImage = null;
            Guid resourceId = Guid.Empty;
            try
            {
                using (SqlDataAdapter adapter = new SqlDataAdapter("[user].[GetPicture]", AppConfigManager.ConnectionString))
                {
                    adapter.SelectCommand.CommandType = CommandType.StoredProcedure;
                    adapter.SelectCommand.Parameters.AddWithValue("@UserIdf", userIdf);

                    DataTable dt = new DataTable();
                    adapter.Fill(dt);

                    if (dt != null && dt.Rows.Count > 0)
                    {
                        object obj = dt.Rows[0][0];
                        if (obj != null && !String.IsNullOrWhiteSpace(obj.ToString()))
                            oldImage = Guid.Parse(Convert.ToString(obj));

                        ResourceManager mgr = new ResourceManager();
                        resourceId = mgr.AddResource(new ResourceInfo() { Data = data, FileExtension = CodeHelper.CustomPicFileExtension }, folderPath, EnumPostType.Picture);

                        if (resourceId != Guid.Empty)
                        {
                            adapter.SelectCommand.CommandText = "[user].[ChangePicture]";
                            adapter.SelectCommand.Parameters.AddWithValue("@ResoureId", resourceId);

                            adapter.SelectCommand.Connection.Open();
                            int results = adapter.SelectCommand.ExecuteNonQuery();
                            adapter.SelectCommand.Connection.Close();
                            if (results > 0)
                            {
                                // if file was added and ImageIdf was updated, delete old file
                                if (oldImage != null)
                                    DeleteFile(oldImage);
                                return true.ToString();
                            }
                            else
                            {
                                // if image was added but ImageIdf was not updated remove newly added file
                                if (resourceId != Guid.Empty)
                                    DeleteFile(resourceId);
                            }
                        }

                    }

                    throw new Exception(CodeHelper.UnableToUpdateProfilePicture);
                }
            }
            catch (Exception ex)
            {
                if (resourceId != Guid.Empty)
                    DeleteFile(resourceId);

                string msg = ex.Message;
                throw new Exception(CodeHelper.UnableToUpdateProfilePicture);
            }
        }
Beispiel #4
0
        public Guid?[] AddPostImages(ResourceInfo resourceInfo1, ResourceInfo resourceInfo2, string hierarchyId, EnumPostType postType)
        {
            try
            {
                ResourceManager mgr = new ResourceManager();
                Guid resourceId1 = mgr.AddResource(resourceInfo1, hierarchyId, postType);
                Guid? resourceId2 = null;
                if (resourceInfo2 != null && !String.IsNullOrWhiteSpace(resourceInfo2.DataUrl))
                    resourceId2 = mgr.AddResource(resourceInfo2, hierarchyId, postType);

                return new Guid?[] { resourceId1, resourceId2 };
            }
            catch (Exception ex)
            {
                string message = ex.Message;
                throw new Exception(CodeHelper.UnableToAddFile);
            }
        }