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