public string GetResponseMessage(int requestApprovalId) { ResponseApprovalMessage responseMessage = db.ResponseApprovalMessage.Where(r => r.RequestApprovalMessageID == requestApprovalId).FirstOrDefault(); BaseMessage existingBaseMessage = db.BaseMessage.Where(b => b.BaseMessageID == responseMessage.BaseMessageID).FirstOrDefault(); return(existingBaseMessage.MessageText.ToString()); }
public ActionResult CreateResponseApprovalMessage(int requestApprovalMessageId, int senderId, int receiverId, string messageText, string response) { BaseMessage baseMessage = new BaseMessage(); baseMessage.SenderID = senderId; baseMessage.RecieverID = receiverId; baseMessage.MessageText = messageText; baseMessage.MessageSendDate = DateTime.Now; ResponseApprovalMessage responseMessage = new ResponseApprovalMessage(); responseMessage.RequestApprovalMessageID = requestApprovalMessageId; responseMessage.BaseMessage = baseMessage; responseMessage.Response = Convert.ToBoolean(response); db.ResponseApprovalMessage.Add(responseMessage); RequestApprovalMessage existingRequestMessage = db.RequestApprovalMessage.Find(requestApprovalMessageId); BaseMessage existingBaseMessage = db.BaseMessage.Where(b => b.BaseMessageID == existingRequestMessage.BaseMessageID).FirstOrDefault(); // BaseMessage existingRequestMessage = db.BaseMessage.Find(requestApprovalMessageId); existingBaseMessage.MessageReadDate = DateTime.Now; db.Entry(existingRequestMessage).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); }
private IEnumerable <ResponseApprovalMessage> GetResponseApprovalMessage(List <CourseTeacher> teachersCourse, CourseOccurrence courseOccurrence) { List <ResponseApprovalMessage> responseApprovalMessageList = new List <ResponseApprovalMessage>(); foreach (Teacher teacher in teachersCourse.Select(t => t.Teacher).ToList()) { ResponseApprovalMessage responseToAdd = (ResponseApprovalMessage)db.ResponseApprovalMessage.Where(x => x.BaseMessage.SenderID == teacher.TeacherId && x.RequestApprovalMessage.CourseOccurrence.CourseOccurrenceID == courseOccurrence.CourseOccurrenceID).ToList().LastOrDefault(); responseApprovalMessageList.Add(responseToAdd); } return(responseApprovalMessageList); }
public string GetResponseStatus(int requestApprovalId) { ResponseApprovalMessage responseMessage = db.ResponseApprovalMessage.Where(r => r.RequestApprovalMessageID == requestApprovalId).FirstOrDefault(); return(responseMessage.Response.ToString()); }