Example #1
0
        public ActionResult ViewInboxMessage(long MessageId)
        {
            StoPMessageHeaderModel M = new StoPMessageHeaderModel();

            try
            {
                var H = Connection.SMGT_getStoPMessageView(MessageId).SingleOrDefault();
                M.MessageId      = H.MessageId;
                M.Message        = H.Message.Replace("<br />", "\r\n");
                M.MessageType    = Convert.ToInt64(H.MessageType);
                M.MessageTypeDes = H.MessageTypeDescription;
                M.SchoolId       = H.SchoolId;
                M.SeqNo          = H.SeqNo;
                M.Subject        = H.Subject;
                M.Sender         = H.Sender;

                List <tblSchoolToParentMessageAttachment> AList = Connection.tblSchoolToParentMessageAttachments.Where(
                    x => x.MessageId == MessageId).ToList();
                M.AttachmentList = AList;
            }
            catch (Exception Ex)
            {
                Errorlog.ErrorManager.LogError("ActionResult ViewInboxMessage(long MessageId) @ PSMessageController", Ex);
            }
            return(PartialView("InboxMsgView", M));
        }
        public ActionResult NewMessage(StoPMessageHeaderModel Model)
        {
            string result = "Success";

            using (SchoolMGTEntitiesConnectionString Connection = new SchoolMGTEntitiesConnectionString())
            {
                using (var scope = new TransactionScope())
                {
                    try
                    {
                        tblSchoolToParentMessageHeader MsgHead = new tblSchoolToParentMessageHeader();
                        MsgHead.SchoolId    = _session.School_Id;
                        MsgHead.MessageId   = Model.MessageId;
                        MsgHead.Message     = Model.Message.Replace("\r\n", "<br />");
                        MsgHead.CreatedBy   = _session.User_Id;
                        MsgHead.CreatedDate = DateTime.Now;
                        MsgHead.MessageType = Model.MessageType;
                        MsgHead.IsActive    = "Y";
                        MsgHead.Sender      = Model.Sender;
                        MsgHead.Subject     = Model.Subject;
                        Connection.SaveChanges();
                        //MsgHead.Attachments = 0;
                        Connection.tblSchoolToParentMessageHeaders.Add(MsgHead);
                        if (Model.ParentId != -1)
                        {
                            for (int i = 0; i < Model.ParentIdArray.Length; i++)
                            {
                                tblSchoolToParentMessageDetail MsgDetail = new tblSchoolToParentMessageDetail();
                                MsgDetail.SchoolId    = _session.School_Id;
                                MsgDetail.MessageId   = Convert.ToInt64(Model.MessageId);;
                                MsgDetail.ParentId    = Model.ParentIdArray[i];
                                MsgDetail.IsActive    = "Y";
                                MsgDetail.Status      = "N";
                                MsgDetail.CreatedBy   = _session.User_Id;
                                MsgDetail.CreatedDate = DateTime.Now;
                                Connection.tblSchoolToParentMessageDetails.Add(MsgDetail);
                                Connection.SaveChanges();
                            }
                        }
                        else
                        {
                            tblSchoolToParentMessageDetail MsgDetail = new tblSchoolToParentMessageDetail();
                            MsgDetail.SchoolId    = _session.School_Id;
                            MsgDetail.MessageId   = Convert.ToInt64(Model.MessageId);;
                            MsgDetail.ParentId    = -1;
                            MsgDetail.IsActive    = "Y";
                            MsgDetail.Status      = "N";
                            MsgDetail.CreatedBy   = _session.User_Id;
                            MsgDetail.CreatedDate = DateTime.Now;
                            Connection.tblSchoolToParentMessageDetails.Add(MsgDetail);
                            Connection.SaveChanges();
                        }
                        result = "Success";
                        scope.Complete();
                    }
                    catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
                    {
                        Errorlog.ErrorManager.LogError("SendParenttoSchoolMsg(PtoSMessageHeaderModel Model) @PSMessageController", dbEx);
                        result = "Validation";
                    }
                    catch (Exception Ex)
                    {
                        Errorlog.ErrorManager.LogError("SendParenttoSchoolMsg(PtoSMessageHeaderModel Model) @PSMessageController", Ex);
                        result = "Exception";
                    }
                }
            }
            return(Json(result, JsonRequestBehavior.AllowGet));
        }