public bool ChangelikeStateForComment(int commentId, string UserName) { try { int CurrenUser = 0; using (var db = new UserDAL()) { CurrenUser = db.GetUserByUserNameOrEmail(UserName).UserID; } using (var db = new Ws_DataContext()) { //Check current like status. LikeCommentThread current = ( from p in db.LikeCommentThreads where p.CommentId == commentId && p.UserId == CurrenUser select p ).SingleOrDefault(); if (current != null) { current.Status = !current.Status; db.SaveChanges(); } else { db.LikeCommentThreads.Add(new LikeCommentThread() { CommentId = commentId, UserId = CurrenUser, Status = true }); db.SaveChanges(); } return(true); } } catch (Exception) { return(false); } }
public Thread UpdateThread(CreateThreadInfo thread, string UserName) { int CurrenUser = 0; using (var db = new UserDAL()) { CurrenUser = db.GetUserByUserNameOrEmail(UserName).UserID; } using (var db = new Ws_DataContext()) { //Get current Thread To Edit var currentThread = db.Threads.Where(x => x.ThreadId == thread.ThreadId).SingleOrDefault(); currentThread.Title = thread.Title; currentThread.Content = thread.Content; currentThread.ShortDescription = thread.ShortDescription; currentThread.UpdatedDate = DateTime.Now; if (CurrenUser != currentThread.UserId) { return(null); } else { db.Threads.AddOrUpdate(currentThread); db.SaveChanges(); } return(currentThread); } }
/// <summary> /// Change status of report to false /// </summary> /// <param name="isReportId"></param> /// <param name="reportType"></param> /// <returns></returns> public bool ChangeStatusOfReport(int isReportId, string reportType) { try { using (var db = new Ws_DataContext()) { List <Report> reports = db.Reports.Where(x => x.ReportTo == isReportId && x.Type == reportType && x.Status == true).ToList(); foreach (var report in reports) { report.Status = false; db.Reports.AddOrUpdate(report); } db.SaveChanges(); //change success return(true); } } catch (Exception) { //change false return(false); //throw; } }
public Organization AddNewOrganization(CreateOrganization organizationBasic, string UserName) { int CurrenUser = 0; using (var db = new UserDAL()) { CurrenUser = db.GetUserByUserNameOrEmail(UserName).UserID; } var newOrg = CreatEmptyOrganization(); newOrg.OrganizationId = CurrenUser; newOrg.OrganizationName = organizationBasic.OrganizationName; newOrg.EOrganizationName = ConvertToUnSign.Convert(organizationBasic.OrganizationName); newOrg.Introduction = organizationBasic.Introduction; newOrg.LogoUrl = organizationBasic.LogoUrl; newOrg.Phone = organizationBasic.Phone; newOrg.Email = organizationBasic.Email; newOrg.Address = organizationBasic.Address; newOrg.IsVerify = false; newOrg.IsActive = true; newOrg.Point = 0; newOrg.CreatedDate = DateTime.Now; using (var db = new Ws_DataContext()) { db.Organizations.Add(newOrg); db.SaveChanges(); return(GetOrganizationById(newOrg.OrganizationId)); } }
public Event AddNewEvent(CreateEventInfo eventInfo, string UserName) { int CurrenUser = 0; using (var db = new UserDAL()) { CurrenUser = db.GetUserByUserNameOrEmail(UserName).UserID; } var newEvent = CreateEmptyEvent(); newEvent.CreatorID = GetOrganizationById(CurrenUser).OrganizationId; newEvent.EventType = eventInfo.EventType; newEvent.EventName = eventInfo.EventName; newEvent.EEventName = ConvertToUnSign.Convert(newEvent.EventName); if (eventInfo.StartDate != "") { newEvent.Start_Date = DateTime.Parse(eventInfo.StartDate); } if (eventInfo.FinishDate != "") { newEvent.Finish_Date = DateTime.Parse(eventInfo.FinishDate); } newEvent.ShortDescription = eventInfo.ShortDescription; newEvent.Location = eventInfo.Location; newEvent.ExpectedMoney = eventInfo.ExpectedMoney; newEvent.Description = eventInfo.Content; newEvent.Contact = eventInfo.Contact; newEvent.VideoUrl = eventInfo.VideoUrl; using (var db = new Ws_DataContext()) { db.Events.Add(newEvent); db.SaveChanges(); return(GetEventById(newEvent.EventID)); } }
public Organization EditOrganization(CreateOrganization organizationBasic, string UserName) { try { int CurrenUser = 0; using (var db = new UserDAL()) { CurrenUser = db.GetUserByUserNameOrEmail(UserName).UserID; } using (var db = new Ws_DataContext()) { var currentOrg = db.Organizations.Find(CurrenUser); currentOrg.OrganizationName = organizationBasic.OrganizationName; currentOrg.OrganizationName = organizationBasic.OrganizationName; currentOrg.Introduction = organizationBasic.Introduction; if (organizationBasic.LogoUrl != "" && organizationBasic.LogoUrl != null) { currentOrg.LogoUrl = organizationBasic.LogoUrl; } currentOrg.Phone = organizationBasic.Phone; currentOrg.Address = organizationBasic.Address; db.SaveChanges(); return(GetOrganizationById(currentOrg.OrganizationId)); } } catch (Exception) { return(null); //throw; } }
public void UpdateTime(Conversation currentConservation) { using (var db = new Ws_DataContext()) { db.Conversation.AddOrUpdate(currentConservation); db.SaveChanges(); } }
public void UpdateEvent(Event eventUpdate) { using (var db = new Ws_DataContext()) { db.Events.AddOrUpdate(eventUpdate); db.SaveChanges(); } }
public CommentThread AddNewComment(CommentThread comment) { using (var db = new Ws_DataContext()) { var newComment = db.CommentThreads.Add(comment); db.SaveChanges(); return(newComment); } }
public Message AddNewMessage(Message newMessage) { using (var db = new Ws_DataContext()) { var returnedMessage = db.Message.Add(newMessage); db.SaveChanges(); return(returnedMessage); } }
public Conversation AddNewConservation(Conversation newConservation) { using (var db = new Ws_DataContext()) { var returnedConservation = db.Conversation.Add(newConservation); db.SaveChanges(); return(returnedConservation); } }
public Ws_User AddNewUser(Ws_User newUser) { using (var db = new Ws_DataContext()) { db.Ws_User.Add(newUser); db.SaveChanges(); return(GetUserByUserNameOrEmail(newUser.Email)); } }
public Report AddNewReport(Report newReport) { using (var db = new Ws_DataContext()) { var currentReport = db.Reports.Add(newReport); db.SaveChanges(); return(currentReport); } }
public SubCommentThread AddNewSubComment(SubCommentThread subComment) { using (var db = new Ws_DataContext()) { var newComment = db.SubCommentThread.Add(subComment); db.SaveChanges(); return(newComment); } }
public Ws_User UpdateUser(Ws_User User) { using (var db = new Ws_DataContext()) { db.Ws_User.AddOrUpdate(User); db.SaveChanges(); return(GetUserByUserNameOrEmail(User.UserName)); } }
public EventType UpdateEventType(EventType type) { using (var db = new Ws_DataContext()) { db.EventTypes.AddOrUpdate(type); db.SaveChanges(); return(GetEventTypeById(type.EventTypeID)); } }
public List <MessageBasicInfoDTO> GetAllMessageByConservationId(int id, string userName) { List <MessageBasicInfoDTO> messageList = new List <MessageBasicInfoDTO>(); int UserId = 0; using (var db = new UserDAL()) { UserId = db.GetUserByUserNameOrEmail(userName).UserID; } using (var db = new Ws_DataContext()) { var list = db.Message.Where(x => x.ConservationId == id).ToList(); foreach (var item in list) { MessageBasicInfoDTO current = new MessageBasicInfoDTO(); //Set time if (DateTime.Now.Subtract(item.CreatedDate).TotalHours <= 24 && DateTime.Now.Subtract(item.CreatedDate).TotalHours >= 1) { current.CreatedDate = Math.Round(DateTime.Now.Subtract(item.CreatedDate).TotalHours, 0) + " Tiếng cách đây"; } else if (DateTime.Now.Subtract(item.CreatedDate).TotalHours > 24) { current.CreatedDate = item.CreatedDate.ToString("H:mm:ss dd/MM/yy"); } else if (DateTime.Now.Subtract(item.CreatedDate).Minutes == 0) { current.CreatedDate = "Vừa xong"; } else { current.CreatedDate = DateTime.Now.Subtract(item.CreatedDate).Minutes + " Phút cách đây"; } //Set other atributes current.CreatorImage = item.User.User_Information.ProfileImage; current.CreatorName = item.User.UserName; current.Content = item.Content; messageList.Add(current); } //Update Is Read for message. var currentConversation = db.Conversation.Where(x => x.ConservationId == id).SingleOrDefault(); if (UserId == currentConversation.CreatorId) { currentConversation.IsCreatorRead = true; } if (UserId == currentConversation.ReceiverId) { currentConversation.IsReceiverRead = true; } db.Conversation.AddOrUpdate(currentConversation); db.SaveChanges(); } return(messageList); }
/// <summary> /// Add Event Album /// </summary> /// <param name="album"></param> /// <returns>eventAlbum</returns> public EventAlbumImage AddEventAlbum(EventAlbumImageDTO album) { var eventAlbum = CreateEmptyEventAlbum(); eventAlbum.EventId = album.EventId; eventAlbum.ImageUrl = album.ImageUrl; using (var db = new Ws_DataContext()) { db.EventAlbum.Add(eventAlbum); db.SaveChanges(); return(eventAlbum); } }
/// <summary> /// Add New Album /// </summary> /// <param name="album"></param> /// <returns>ThreadAlbumImage</returns> public ThreadAlbumImage AddNewAlbum(ThreadAlbumImageDTO album) { var emptyAlbum = CreateEmptyThreadAlbum(); emptyAlbum.ThreadId = album.ThreadId; emptyAlbum.ImageUrl = album.ImageUrl; using (var db = new Ws_DataContext()) { db.ThreadAlbum.Add(emptyAlbum); db.SaveChanges(); return(emptyAlbum); } }
public bool UpdateUserInfo(UserBasicInfoDTO UserInfo, string userName) { try { using (var db = new Ws_DataContext()) { var newInformation = db.User_Information.Where(x => x.Ws_User.UserName == userName).SingleOrDefault(); if (UserInfo.FullName != null) { newInformation.FullName = UserInfo.FullName; newInformation.EFullName = ConvertToUnSign.Convert(UserInfo.FullName); } if (UserInfo.Phone != null) { newInformation.Phone = UserInfo.Phone; } if (UserInfo.Address != null) { newInformation.UserAddress = UserInfo.Address; newInformation.EUserAddress = ConvertToUnSign.Convert(UserInfo.Address); } if (UserInfo.Country != null) { newInformation.Country = UserInfo.Country; } if (UserInfo.Gender != null) { newInformation.Gender = UserInfo.Gender; } if (UserInfo.DOB != "") { newInformation.DoB = Convert.ToDateTime(UserInfo.DOB); } if (UserInfo.FacebookUri != null) { newInformation.FacebookUrl = UserInfo.FacebookUri; } if (UserInfo.UserSignature != null) { newInformation.UserSignature = UserInfo.UserSignature; } db.User_Information.AddOrUpdate(newInformation); db.SaveChanges(); return(true); } } catch (Exception) { return(false); } }
// Update Organization public Organization UpdateOrganization(Organization organ) { try { using (var db = new Ws_DataContext()) { db.Organizations.AddOrUpdate(organ); db.SaveChanges(); } } catch (Exception) { //throw; } return(organ); }
// Update Thread public Thread UpdateThread(Thread thread) { try { using (var db = new Ws_DataContext()) { db.Threads.AddOrUpdate(thread); db.SaveChanges(); } } catch (Exception) { //throw; } return(thread); }
public bool AddNewDonation(DonationDTO donationInfo) { using (var db = new Ws_DataContext()) { var newDonate = db.Donations.Create(); newDonate.UserId = donationInfo.UserId; newDonate.EventId = donationInfo.EventId; newDonate.TradeCode = donationInfo.TradeCode; newDonate.DonatedMoney = donationInfo.DonatedMoney; newDonate.Content = donationInfo.Content; newDonate.IsPublic = donationInfo.IsPublic; newDonate.DonatedDate = DateTime.Now;; db.Donations.Add(newDonate); db.SaveChanges(); return(true); } }
public bool CreateEventType(EventType type) { try { using (var db = new Ws_DataContext()) { db.EventTypes.Add(type); db.SaveChanges(); return(true); } } catch (Exception) { return(false); //throw; } }
public bool DeleteSubComment(int SubCommentId, string UserName) { using (var db = new Ws_DataContext()) { var currentComment = (from p in db.SubCommentThread where p.SubCommentThreadId == SubCommentId && p.Ws_User.UserName.Equals(UserName) select p).FirstOrDefault(); if (currentComment != null) { db.SubCommentThread.Remove(currentComment); db.SaveChanges(); return(true); } else { return(false); } } }
public bool DeleteComment(int CommentId, string UserName) { using (var db = new Ws_DataContext()) { var currentComment = (from p in db.CommentThreads where p.CommentThreadId == CommentId && p.Ws_User.UserName.Equals(UserName) select p).FirstOrDefault(); if (currentComment != null) { var subCommentInComment = (from p in db.SubCommentThread where p.CommentThreadId == currentComment.CommentThreadId select p).ToList(); if (subCommentInComment != null) { foreach (var item in subCommentInComment) { //Delete All SubComment First db.SubCommentThread.Remove(item); } } var LikeInComment = (from p in db.LikeCommentThreads where p.CommentId == CommentId select p).ToList(); if (LikeInComment != null) { foreach (var item in LikeInComment) { //Delete All SubComment First db.LikeCommentThreads.Remove(item); } } db.CommentThreads.Remove(currentComment); db.SaveChanges(); return(true); } else { return(false); } } }
public void AddNewEventTimeLine(CreateEventSchedule eventInfo, int eventId) { var newEventSchedule = CreateEmptyEventTimeLine(); newEventSchedule.EventId = eventId; newEventSchedule.Content = eventInfo.Description; //newEventSchedule.FromDate = DateTime.ParseExact(eventInfo.FromDate, "yyyy-MM-dd HH:mm:ss,fff",System.Globalization.CultureInfo.InvariantCulture); //newEventSchedule.ToDate = DateTime.ParseExact(eventInfo.ToDate, "yyyy-MM-dd HH:mm:ss,fff",System.Globalization.CultureInfo.InvariantCulture); if (eventInfo.FromDate != "") { newEventSchedule.FromDate = DateTime.Parse(eventInfo.FromDate); } if (eventInfo.ToDate != "") { newEventSchedule.ToDate = DateTime.Parse(eventInfo.ToDate); } using (var db = new Ws_DataContext()) { db.ETimeLine.Add(newEventSchedule); db.SaveChanges(); } }
public Thread AddNewThread(CreateThreadInfo thread, string UserName) { int CurrenUser = 0; using (var db = new UserDAL()) { CurrenUser = db.GetUserByUserNameOrEmail(UserName).UserID; } var newThread = CreateEmptyThread(); newThread.UserId = CurrenUser; newThread.Title = thread.Title; newThread.Etitle = ConvertToUnSign.Convert(thread.Title); newThread.Content = thread.Content; newThread.ShortDescription = thread.ShortDescription; using (var db = new Ws_DataContext()) { db.Threads.Add(newThread); db.SaveChanges(); return(GetThreadById(newThread.ThreadId)); } }
/// <summary> /// Delete orgaization with id /// </summary> /// <param name="orgId"></param> /// <returns></returns> public bool DeleteOrganization(int orgId) { try { using (var db = new Ws_DataContext()) { Organization organization = db.Organizations.FirstOrDefault(x => x.OrganizationId == orgId); if (organization != null) { db.Organizations.Remove(organization); db.SaveChanges(); return(true); } return(false); } } catch (Exception) { return(false); //throw; } }