/// <summary> /// 使用使用者模型物件,新增使用者 /// </summary> /// <param name="userModel">使用者模型物件</param> /// <returns>新增結果</returns> public PoResult CreateUser(UserCreateVm userModel) { try { var isEmailExit = this.Database.Users.Any(o => o.Email == userModel.Email); if (isEmailExit) { return(PoResult.Fail("電子郵件重複")); } var isUserNameExit = this.Database.Users.Any(o => o.UserName == userModel.UserName); if (isUserNameExit) { return(PoResult.Fail("使用者名稱重複重複")); } this.Database.Users.Add(new User { Id = Ci.Sequential.Guid.Create(), Email = userModel.Email, UserName = userModel.UserName, Password = PasswordHash(userModel.Password), CreateTime = DateTime.Now, HeadPortraitPath = userModel.ImagePath }); this.Database.SaveChanges(); return(PoResult.PoSuccess()); } catch (Exception e) { return(PoResult.Exception(e)); } }
/// <summary> /// 使用清單名稱、帳號,新增清單 /// </summary> /// <param name="listName">清單名稱</param> /// <param name="account">帳號</param> /// <returns>新增結果</returns> public PoResult <ToDoList> CreateList(string listName, string account) { try { var user = this.Database.Users.FirstOrDefault(o => o.Account == account); if (user == null) { return(PoResult <ToDoList> .DbNotFound()); } var toDoList = this.Database.ToDoLists.Add(new ToDoList { Id = Guid.Create(), Name = listName, UserId = user.Id, Sort = user.ToDoLists.Count }); this.Database.SaveChanges(); return(PoResult <ToDoList> .PoSuccess(toDoList)); } catch (Exception e) { return(PoResult <ToDoList> .Exception(e)); } }
/// <summary> /// 使用帳號,取得使用者物件 /// </summary> /// <param name="account">帳號</param> /// <returns>使用者物件</returns> public PoResult <User> GetUser(string account) { try { var user = this.Database.Users.FirstOrDefault(o => o.Account == account); return(user == null ? PoResult <User> .DbNotFound() : PoResult <User> .PoSuccess(user)); } catch (Exception e) { return(PoResult <User> .Exception(e)); } }
/// <summary> /// 使用信箱,取得使用者 /// </summary> /// <param name="email">使用者的信箱</param> /// <returns>取得結果</returns> public PoResult <User> GetUserByEmail(string email) { try { var user = this.Database.Users.FirstOrDefault(o => o.Email == email); return(user == null ? PoResult <User> .DbNotFound() : PoResult <User> .PoSuccess(user)); } catch (Exception e) { return(PoResult <User> .Exception(e)); } }
/// <summary> /// 使用Id,取得使用者 /// </summary> /// <param name="userId">使用者Id</param> /// <returns>取得結果</returns> public PoResult <User> GetUser(Guid userId) { try { var user = this.Database.Users.Find(userId); return(user == null ? PoResult <User> .DbNotFound() : PoResult <User> .PoSuccess(user)); } catch (Exception e) { return(PoResult <User> .Exception(e)); } }
/// <summary> /// 使用使用者帳號,取得使用者的待辦清單 /// </summary> /// <param name="userAccount">使用者帳號</param> /// <returns>使用者的待辦清單</returns> public PoResult <List <ToDoList> > GetUserToDoLists(string userAccount) { try { var toDoLists = this.Database.ToDoLists.Where(o => o.User.Account == userAccount).Include(o => o.Folder).OrderBy(o => o.Sort).ToList(); return(PoResult <List <ToDoList> > .PoSuccess(toDoLists)); } catch (Exception e) { return(PoResult <List <ToDoList> > .Exception(e)); } }
/// <summary> /// 使用帳號、密碼,驗證使用者 /// </summary> /// <param name="account">帳號</param> /// <param name="password">密碼</param> /// <returns>驗證結果</returns> public PoResult VerifyUser(string account, string password) { try { var userResult = this.GetUser(account); if (!userResult.Success) { return(PoResult.Fail("帳號不存在")); } return(userResult.Data.Password == PasswordHash(password) ? PoResult.PoSuccess() : PoResult.Fail("密碼錯誤")); } catch (Exception e) { return(PoResult.Exception(e)); } }
/// <summary> /// 使用待辦清單Id陣列、使用者帳號,更新待辦清單的排序 /// </summary> /// <param name="listIds">待辦清單Id陣列</param> /// <param name="userAccount">使用者帳號</param> /// <returns>更新結果</returns> public PoResult UpdateListSort(System.Guid[] listIds, string userAccount) { try { var index = 0; foreach (var listId in listIds) { var toDoList = this.Database.ToDoLists.FirstOrDefault(o => o.Id == listId && o.User.Account == userAccount); if (toDoList == null) { return(PoResult.DbNotFound()); } toDoList.Sort = index++; } this.Database.SaveChanges(); return(PoResult.PoSuccess()); } catch (Exception e) { return(PoResult.Exception(e)); } }
/// <summary> /// 使用使用者物件,新增使用者 /// </summary> /// <param name="userModel">使用者物件</param> /// <returns>新增結果</returns> public PoResult CreateUser(UserCreateVm userModel) { try { var isUserExist = this.Database.Users.Any(o => o.Account == userModel.Account); if (isUserExist) { return(PoResult.Fail("帳號重複")); } this.Database.Users.Add(new User { Id = Ci.Sequential.Guid.Create(), Account = userModel.Account, Password = PasswordHash(userModel.Password), CreateTime = DateTime.Now }); this.Database.SaveChanges(); return(PoResult.PoSuccess()); } catch (Exception e) { return(PoResult.Exception(e)); } }
public ActionResult SendMessage(string messageContext, HttpPostedFileBase[] images, Guid?parentMessageId = null) { // 驗證 if (messageContext.Length > 300) { return(this.Json(PoResult.Fail("訊息內容超出限制,最多為300字"))); } // 驗證 if (messageContext.Length == 0 && images == null) { return(this.Json(PoResult.Fail("沒有可以儲存的訊息內容"))); } // 組裝model var messageCreateModel = new MessageCreateModel { UserId = this.CurrentUser.Id, Context = messageContext, ParentMessageId = parentMessageId }; if (images != null) { foreach (var image in images) { if (image == null || image.ContentLength == 0) { continue; } if (image.ContentLength > 1024 * 1024) { return(this.Json(PoResult.Fail($"檔案「{image.FileName}」大小超出限制,最大1MB"))); } try { using (new System.Drawing.Bitmap(image.InputStream)) { // ignore } } catch (Exception) { return(this.Json(PoResult.Fail($"檔案「{image.FileName}」格式錯誤,請確定上傳的是圖片"))); } image.InputStream.Position = 0; } foreach (var image in images) { var fileResult = image.SaveAsLocal("AttachmentImages"); messageCreateModel.Images.Add(($"{fileResult.OriName}{fileResult.Extension}", fileResult.VirtualPath)); } } var saveResult = this.messageService.SaveMessage(messageCreateModel); if (saveResult.Success) { var messageListVmResult = this.messageService.GetMessageListVm(saveResult.Data.Id); if (messageListVmResult.Success) { if (saveResult.Data.ParentMessageId == null) { // not reply this.hub.Clients.All.updateMessage(messageListVmResult.Data.MessageId, "newMessage", messageListVmResult.Data); } else { // is reply this.hub.Clients.All.updateMessage(saveResult.Data.ParentMessageId, "newReply", messageListVmResult.Data); } } } else { if (images != null) { foreach (var image in messageCreateModel.Images) { var mapPath = this.Server.MapPath(image.Path); if (System.IO.File.Exists(mapPath)) { System.IO.File.Delete(mapPath); } } } } return(this.Json(new PoResult { Success = saveResult.Success, Message = saveResult.Message })); }
public ActionResult UpdateMessage(Guid messageId, string context, Guid[] deleteImages, HttpPostedFileBase[] images) { // 驗證 if (context.Length > 300) { return(this.Json(PoResult.Fail("訊息內容超出限制,最多為300字"))); } // 驗證 if (context.Length == 0 && images == null && deleteImages == null) { return(this.Json(PoResult.Fail("沒有可以儲存的訊息內容"))); } // 組裝model var messageUpdateModel = new MessageUpdateModel() { MessageId = messageId, Context = context, DeleteAttachmentIds = deleteImages?.ToList() ?? new List <Guid>() }; if (images != null) { foreach (var image in images) { if (image == null || image.ContentLength == 0) { continue; } if (image.ContentLength > 1024 * 1024) { return(this.Json(PoResult.Fail($"檔案「{image.FileName}」大小超出限制,最大1MB"))); } try { using (new System.Drawing.Bitmap(image.InputStream)) { // ignore } } catch (Exception) { return(this.Json(PoResult.Fail($"檔案「{image.FileName}」格式錯誤,請確定上傳的是圖片"))); } image.InputStream.Position = 0; } foreach (var image in images) { var fileResult = image.SaveAsLocal("AttachmentImages"); messageUpdateModel.NewAttachments.Add(($"{fileResult.OriName}{fileResult.Extension}", fileResult.VirtualPath)); } } var updateResult = this.messageService.UpdateMessage(this.CurrentUser.Id, messageUpdateModel); if (updateResult.Success) { var messageListVmResult = this.messageService.GetMessageListVm(updateResult.Data.Id); if (messageListVmResult.Success) { this.hub.Clients.All.updateMessage(messageListVmResult.Data.MessageId, "updateMessage", messageListVmResult.Data); } } else { if (images != null) { foreach (var image in messageUpdateModel.NewAttachments) { var mapPath = this.Server.MapPath(image.Path); if (System.IO.File.Exists(mapPath)) { System.IO.File.Delete(mapPath); } } } } return(this.Json(new PoResult { Success = updateResult.Success, Message = updateResult.Message })); }