public ActionResult ViewPSMessage(long MessageId)
{
PtoSMessageHeaderModel M = new PtoSMessageHeaderModel();
try
{
var H = Connection.SMGTgetPtoSMessageView(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.ParentId = H.ParentId;
M.ParentName = H.ParentName;
M.RecepientUser = H.RecepientUser;
M.SchoolId = H.SchoolId;
M.SeqNo = H.SeqNo;
M.Status = H.Status;
M.Subject = H.Subject;
M.TeacherName = H.PersonName;
List <tblParentToSchollMessageAttachment> AList = Connection.tblParentToSchollMessageAttachments.Where(
x => x.MessageId == MessageId).ToList();
M.AttachmentList = AList;
}
catch (Exception Ex)
{
Errorlog.ErrorManager.LogError("ActionResult ViewPSMessage(long MessageId) @ PSMessageController", Ex);
}
return(PartialView("ViewMessage", M));
}
public JsonResult SendParenttoSchoolMsg(PtoSMessageHeaderModel Model)
{
string result = "Error";
using (SchoolMGTEntitiesConnectionString Connection = new SchoolMGTEntitiesConnectionString())
{
using (var scope = new TransactionScope())
{
try
{
tblParentToSchoolMessageHeader MsgHead = new tblParentToSchoolMessageHeader();
MsgHead.SchoolId = _session.School_Id;
MsgHead.MessageId = Model.MessageId;
MsgHead.ParentId = Convert.ToInt64(Session["PTSParentId"]);//session parent id
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.Status = "N";
MsgHead.Subject = Model.Subject;
MsgHead.Attachments = 0;
tblParentToSchoolMessageDetail MsgDetail = new tblParentToSchoolMessageDetail();
MsgDetail.SchoolId = _session.School_Id;
MsgDetail.MessageId = Convert.ToInt64(Model.MessageId);;
MsgDetail.RecepientUser = Model.RecepientUser;
MsgDetail.IsActive = "Y";
MsgDetail.Status = "N";
MsgDetail.AuthorizationDate = DateTime.Now;
MsgDetail.AuthorizedBy = _session.User_Id;
MsgDetail.AuthStatus = "A";
MsgDetail.CreatedBy = _session.User_Id;
MsgDetail.CreatedDate = DateTime.Now;
Connection.tblParentToSchoolMessageHeaders.Add(MsgHead);
Connection.tblParentToSchoolMessageDetails.Add(MsgDetail);
Connection.SaveChanges();
scope.Complete();
result = "Success";
}
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));
}
public ActionResult DeleteAttachment(PtoSMessageHeaderModel Model)
{
try
{
tblParentToSchollMessageAttachment Tble = Connection.tblParentToSchollMessageAttachments.Find(
Model.SeqNo);
string path = Tble.AttachementPath;
Connection.tblParentToSchollMessageAttachments.Remove(Tble);
Connection.SaveChanges();
System.IO.File.Delete(Server.MapPath(path));
return(Json(Model.SeqNo, JsonRequestBehavior.AllowGet));
}
catch
{
return(Json("Error", JsonRequestBehavior.AllowGet));
}
}
public JsonResult AttachmentUpload(PtoSMessageHeaderModel Model)
{
try
{
var file = Model.Attachment_File;
long AttachmentId = 0;
tblParentToSchollMessageAttachment Attachmentfile = new tblParentToSchollMessageAttachment();
if (file != null)
{
var Atid = Connection.tblParameters.Where(x => x.ParameterId == "PSMAS").Select(
x => x.ParameterValue).SingleOrDefault();
AttachmentId = Convert.ToInt64(Atid);
long Next = AttachmentId + 1;
var Attachement_Path = "/Attachments/PtS/" + DateTime.Now.ToString("yyyy") + "/" +
DateTime.Now.ToString("MM") + "/" + DateTime.Now.ToString("dd") + "/" + Model.MessageId;
var fileName = Path.GetFileName(file.FileName);
var extention = Path.GetExtension(file.FileName);
Attachmentfile.AttachementName = file.FileName;
Attachmentfile.AttachementPath = Attachement_Path + "/" + file.FileName;
Attachmentfile.MessageId = Model.MessageId;
Attachmentfile.SeqNo = AttachmentId;
Connection.tblParentToSchollMessageAttachments.Add(Attachmentfile);
Connection.SaveChanges();
tblParameter TCtable = Connection.tblParameters.SingleOrDefault(
x => x.ParameterId == "PSMAS");
TCtable.ParameterValue = Next.ToString();
Connection.SaveChanges();
if (!Directory.Exists(Server.MapPath(Attachement_Path)))
{
Directory.CreateDirectory(Server.MapPath(Attachement_Path));
}
file.SaveAs(Server.MapPath(Attachement_Path + "/" + file.FileName));
}
var result = new { FileName = file.FileName, SeqNo = AttachmentId };
return(Json(result, JsonRequestBehavior.AllowGet));
}
catch (Exception Ex)
{
Errorlog.ErrorManager.LogError("AttachmentUpload(PtoSMessageHeaderModel Model) @PSMessageController", Ex);
var result = new { FileName = "Error", SeqNo = "Error" };
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
