public JsonResult Notification1(string uid) { string name = Request["uid"]; Response.AppendHeader("Access-Control-Allow-Origin", "null"); var a = from x in db.Announcements where x.destination.Equals(name) && (!(x.title.Equals("message")) && !(x.Sender_u_id.Equals("ExamBranch"))) //&& x.status.Equals("0") select x; List<Announcement> anno = new List<Announcement>(); foreach (Announcement b in a) { Announcement an = new Announcement(); an.mesg_text = b.mesg_text; an.Sender_u_id = b.Sender_u_id; an.status = b.status; an.title = b.title; an.dateTime = b.dateTime; an.audience = b.audience; an.destination = b.destination; anno.Add(an); } return this.Json(anno, JsonRequestBehavior.AllowGet); }
public ActionResult saveSittingPlan() { if (Session["id"] != null && db.users.Find(Session["id"]).type.Equals("ExamBranch")) { string result; HttpPostedFileBase file = Request.Files[0]; file.SaveAs(Server.MapPath(@"~\Files\" + file.FileName)); var dataFile = Server.MapPath(@"~\Files\" + file.FileName); Announcement a = new Announcement(); a.attachment = dataFile; a.Sender_u_id = "ExamBranch"; char[] delimiterChar = { ',' }; string[] data = null; System.IO.FileStream fin = new FileStream(dataFile, FileMode.Open); StreamReader sr = new StreamReader(fin); result = sr.ReadLine(); try { while (result != null) { data = result.Split(delimiterChar); Announcement a1 = new Announcement(); a1.Sender_u_id = "ExamBranch"; a1.destination = data[0].ToString(); string[] str = data[1].Split(' '); string[] time = str[1].Split(':'); string[] date = str[0].Split('/'); string tt = str[2]; if (tt.Equals("AM")) { DateTime dt = new DateTime(Convert.ToInt32(date[2]), Convert.ToInt32(date[0]), Convert.ToInt32(date[1]), Convert.ToInt32(time[0]), Convert.ToInt32(time[1]), 0); a1.dateTime = dt; } else { DateTime dt = new DateTime(Convert.ToInt32(date[2]), Convert.ToInt32(date[0]), Convert.ToInt32(date[1]), Convert.ToInt32(time[0]) + 12, Convert.ToInt32(time[1]), 0); a1.dateTime = dt; } a1.mesg_text = data[2].ToString() + " " + data[3].ToString() + " " + data[4].ToString(); db.Announcements.Add(a1); result = sr.ReadLine(); data = null; db.Announcements.Add(a1); } sr.Close(); fin.Close(); db.SaveChanges(); } catch (Exception e) { ViewBag.ErrorType = "Upload Sitting Plan"; ViewBag.message = "File format is not correct"; sr.Close(); fin.Close(); return View("ErrorPage"); } return View("ExamBranchHome"); } return RedirectToAction("signIn", "Home"); }
public ActionResult personalMesg2T1() { if (Session["id"] != null && db.users.Find(Session["id"]).type.Equals("Teacher")) { try { ViewBag.ttid = Session["id"]; String subject = Request["sub"]; String mesg = Request["mesg_text"]; var dateAsString = DateTime.Now.ToString("yyyy-MM-dd"); String ttid = Request["tid"]; var q = from x in db.teachers where x.tid.Equals(ttid) select x; foreach (var i in q) { var a = new Announcement(); a.destination = i.tid; a.audience = i.name; a.title = "message"; a.mesg_text = mesg; // a.attachment = attachment; a.Sender_u_id = Session["id"].ToString(); a.dateTime = DateTime.Now; a.status = "0"; db.Announcements.Add(a); } try { db.SaveChanges(); } catch (DbEntityValidationException ex) { StringBuilder sb = new StringBuilder(); foreach (var failure in ex.EntityValidationErrors) { sb.AppendFormat("{0} failed validation\n", failure.Entry.Entity.GetType()); foreach (var error in failure.ValidationErrors) { sb.AppendFormat("- {0} : {1}", error.PropertyName, error.ErrorMessage); sb.AppendLine(); } } throw new DbEntityValidationException( "Entity Validation Failed - errors follow:\n" + sb.ToString(), ex ); // Add the original exception as the innerException } return View("TeacherHome"); } catch (Exception e) { ViewBag.ErrorType = "Exception"; ViewBag.message = e.Message; return View("ErrorPage"); } } else return RedirectToAction("signIn", "Home"); }
public ActionResult AnnouncementDegFallSection() { { if (Session["id"] != null && db.users.Find(Session["id"]).type.Equals("CustomUser") || Session["id"] != null && db.users.Find(Session["id"]).type.Equals("ExamBranch")) { ViewBag.ttid = Session["id"]; String subject = Request["sub"]; String mesg = Request["mesg_text"]; var dateAsString = DateTime.Now.ToString("yyyy-MM-dd"); String fall = Request["fall"]; String degree = Request["degree"]; String section = Request["section"]; var q = from x in db.students where x.batch.Equals(fall) where x.degree.Equals(degree) where x.section.Equals(section) select x; foreach (var i in q) { var a = new Announcement(); a.destination = i.sid; a.audience = fall + " " + degree; a.mesg_text = mesg; a.Sender_u_id = Session["id"].ToString(); a.dateTime = DateTime.Now; a.status = "0"; db.Announcements.Add(a); } try { db.SaveChanges(); } catch (DbEntityValidationException ex) { StringBuilder sb = new StringBuilder(); foreach (var failure in ex.EntityValidationErrors) { sb.AppendFormat("{0} failed validation\n", failure.Entry.Entity.GetType()); foreach (var error in failure.ValidationErrors) { sb.AppendFormat("- {0} : {1}", error.PropertyName, error.ErrorMessage); sb.AppendLine(); } } throw new DbEntityValidationException( "Entity Validation Failed - errors follow:\n" + sb.ToString(), ex ); } return View("CustomUserHome"); } return RedirectToAction("signIn", "Home"); } }
public ActionResult AnnouncementDegFallSection() { if (Session["id"] != null && db.users.Find(Session["id"]).type.Equals("Teacher")) { try { ViewBag.ttid = Session["id"]; String subject = Request["sub"]; String mesg = Request["mesg_text"]; // String attachment = Request["attachment"]; //String audience = Request["a"]; // check on this if audience == "fall" then which fall, populate Student list acc. //if audience == "degree" then which degree, populate Student list acc. //int id = -1; // String a_id; //a_id = ViewBag.annID; //int ann; //a_id = db.Announcements.Max(p => p.announcement_id); var dateAsString = DateTime.Now.ToString("yyyy-MM-dd"); String fall = Request["fall"]; String degree = Request["degree"]; String section = Request["section"]; var q = from x in db.students where x.batch.Equals(fall) where x.degree.Equals(degree) where x.section.Equals(section) select x; foreach (var i in q) { var a = new Announcement(); a.destination = i.sid; a.audience = fall + " " + degree; a.mesg_text = mesg; a.Sender_u_id = Session["id"].ToString(); a.dateTime = DateTime.Now; a.status = "0"; db.Announcements.Add(a); // id.ToString(); // ViewBag.annID = id; } try { db.SaveChanges(); } catch (DbEntityValidationException ex) { StringBuilder sb = new StringBuilder(); foreach (var failure in ex.EntityValidationErrors) { sb.AppendFormat("{0} failed validation\n", failure.Entry.Entity.GetType()); foreach (var error in failure.ValidationErrors) { sb.AppendFormat("- {0} : {1}", error.PropertyName, error.ErrorMessage); sb.AppendLine(); } } throw new DbEntityValidationException( "Entity Validation Failed - errors follow:\n" + sb.ToString(), ex ); // Add the original exception as the innerException } return View("TeacherHome"); } catch (Exception e) { ViewBag.ErrorType = "Exception"; ViewBag.message = e.Message; return View("ErrorPage"); } } else return RedirectToAction("signIn", "Home"); }