public void SeeAnnouncement(int Id)
{
var announcementID = db.AspNetAnnouncement_Subject.Where(s => s.Id == Id).Select(s => s.AnnouncementID).SingleOrDefault();
AspNetStudent_Announcement result = db.AspNetStudent_Announcement.Where(x => x.Id == Id).Select(x => x).FirstOrDefault();
result.Seen = true;
db.SaveChanges();
}
public ActionResult Create([Bind(Include = "Id,Title,Description")] AspNetAnnouncement aspNetAnnouncement)
{
string subjects = Request.Form["subjects"];
IEnumerable <string> selectedsubjects = subjects.Split(',');
if (ModelState.IsValid)
{
//var context = new BloggingContext();
var dbContextTransaction = db.Database.BeginTransaction();
try
{
//TransactionScope ts = new TransactionScope();
// announcement.SubjectID=
db.AspNetAnnouncements.Add(aspNetAnnouncement);
db.SaveChanges();
int announcementID = db.AspNetAnnouncements.Max(item => item.Id);
List <int> SubjectIDs = new List <int>();
foreach (var item in selectedsubjects)
{
int subjectID = Convert.ToInt32(item);
SubjectIDs.Add(subjectID);
}
foreach (var item in SubjectIDs)
{
AspNetAnnouncement_Subject ann_sub = new AspNetAnnouncement_Subject();
ann_sub.SubjectID = item;
ann_sub.AnnouncementID = announcementID;
db.AspNetAnnouncement_Subject.Add(ann_sub);
db.SaveChanges();
}
List <string> student = db.AspNetStudent_Subject.Where(x => SubjectIDs.Contains(x.SubjectID)).Select(s => s.StudentID).ToList();
foreach (var item in student)
{
AspNetStudent_Announcement stu_ann = new AspNetStudent_Announcement();
stu_ann.StudentID = item;
stu_ann.AnnouncementID = announcementID;
stu_ann.Seen = false;
db.AspNetStudent_Announcement.Add(stu_ann);
db.SaveChanges();
}
dbContextTransaction.Commit();
//ts.Complete();
}
catch (Exception)
{
dbContextTransaction.Dispose();
}
return(RedirectToAction("Index"));
}
return(View(aspNetAnnouncement));
}
// GET: Assignment/Details/5
public ActionResult AnnouncementDetail(int?id)
{
var announcementID = db.AspNetAnnouncement_Subject.Where(s => s.Id == id).Select(s => s.AnnouncementID).SingleOrDefault();
AspNetStudent_Announcement result = db.AspNetStudent_Announcement.Where(x => x.StudentID == StudentID && x.AnnouncementID == announcementID).Select(x => x).FirstOrDefault();
result.Seen = true;
db.SaveChanges();
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var Announcement = db.AspNetAnnouncement_Subject.Find(id);
if (Announcement == null)
{
return(HttpNotFound());
}
return(View(Announcement));
}
// GET: Assignment/Details/5
public ActionResult AnnouncementDetail(int?id)
{
var announcementID = db.AspNetAnnouncement_Subject.Where(s => s.Id == id).Select(s => s.AnnouncementID).SingleOrDefault();
AspNetStudent_Announcement result = (from p in db.AspNetStudent_Announcement
where p.StudentID == StudentID && p.AnnouncementID == announcementID
select p).SingleOrDefault();
result.Seen = true;
db.SaveChanges();
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
// List<int> student = db.Student_Subject.Where(x => SubjectIDs.Contains(x.SubjectID)).Select(s => s.StudentID).ToList();
var Announcement = db.AspNetAnnouncement_Subject.Find(id);
if (Announcement == null)
{
return(HttpNotFound());
}
return(View(Announcement));
}
public ActionResult Create([Bind(Include = "Id,Title,Description")] AspNetAnnouncement aspNetAnnouncement)
{
string subjects = Request.Form["subjects"];
IEnumerable <string> selectedsubjects = subjects.Split(',');
if (ModelState.IsValid)
{
var dbContextTransaction = db.Database.BeginTransaction();
try
{
aspNetAnnouncement.Date = DateTime.Now;
db.AspNetAnnouncements.Add(aspNetAnnouncement);
db.SaveChanges();
int announcementID = db.AspNetAnnouncements.Max(item => item.Id);
List <int> SubjectIDs = new List <int>();
foreach (var item in selectedsubjects)
{
int subjectID = Convert.ToInt32(item);
SubjectIDs.Add(subjectID);
}
foreach (var item in SubjectIDs)
{
AspNetAnnouncement_Subject ann_sub = new AspNetAnnouncement_Subject();
ann_sub.SubjectID = item;
ann_sub.AnnouncementID = announcementID;
db.AspNetAnnouncement_Subject.Add(ann_sub);
db.SaveChanges();
}
List <string> student = db.AspNetStudent_Subject.Where(x => SubjectIDs.Contains(x.SubjectID)).Select(s => s.StudentID).ToList();
foreach (var item in student)
{
AspNetStudent_Announcement stu_ann = new AspNetStudent_Announcement();
stu_ann.StudentID = item;
stu_ann.AnnouncementID = announcementID;
stu_ann.Seen = false;
db.AspNetStudent_Announcement.Add(stu_ann);
db.SaveChanges();
/////////////////////////////////////////////////////Push Notifications Module////////////////////////////////////////////////////////////
//var pushNotificationObj = new AspNetPushNotification();
//pushNotificationObj.Message = "New Announcement: " + aspNetAnnouncement.Title + ", Description: " + aspNetAnnouncement.Description;
//pushNotificationObj.UserID = item;
//pushNotificationObj.IsOpenParent = false;
//pushNotificationObj.IsOpenStudent = false;
//pushNotificationObj.Time = DateTime.Now;
//db.AspNetPushNotifications.Add(pushNotificationObj);
//db.SaveChanges();
}
////////////////////////////////////////////////NOTIFICATION///////////////////////////////////////////////////////////////////
var NotificationObj = new AspNetNotification();
NotificationObj.Description = aspNetAnnouncement.Description;
NotificationObj.Subject = aspNetAnnouncement.Title;
NotificationObj.SenderID = User.Identity.GetUserId();
NotificationObj.Time = DateTime.Now;
NotificationObj.Url = "/AspNetAnnouncement/details/" + aspNetAnnouncement.Id;
NotificationObj.SessionID = SessionID;
db.AspNetNotifications.Add(NotificationObj);
db.SaveChanges();
var NotificationID = db.AspNetNotifications.Max(x => x.Id);
List <string> students = db.AspNetStudent_Subject.Where(x => SubjectIDs.Contains(x.SubjectID)).Select(s => s.StudentID).ToList();
var users = new List <String>();
foreach (var item in students)
{
var parentID = db.AspNetParent_Child.Where(x => x.ChildID == item).Select(x => x.ParentID).FirstOrDefault();
users.Add(parentID);
}
var allusers = users.Union(students);
//Message start
//var classe = db.AspNetClasses.Where(p => p.Id == aspNetHomework.ClassId).FirstOrDefault();
//Utility obj = new Utility();
//obj.SMSToOffitialsp("Dear Principal, Announcement has been made with Title: " + aspNetAnnouncement.Title + "- IPC NGS Preschool, Aziz Avenue, Lahore.");
//obj.SMSToOffitialsa("Dear Admin, Announcement has been made with Title: " + aspNetAnnouncement.Title + "- IPC NGS Preschool, Aziz Avenue, Lahore.");
//AspNetMessage oob = new AspNetMessage();
//oob.Message = "Dear Parents, Announcement has been made with Title: " + aspNetAnnouncement.Title + "For discription login to Portal please - IPC NGS Preschool, Aziz Avenue, Lahore.";
//obj.SendSMS(oob, users);
//Message end
foreach (var receiver in allusers)
{
var notificationRecieve = new AspNetNotification_User();
notificationRecieve.NotificationID = NotificationID;
notificationRecieve.UserID = Convert.ToString(receiver);
notificationRecieve.Seen = false;
db.AspNetNotification_User.Add(notificationRecieve);
db.SaveChanges();
}
dbContextTransaction.Commit();
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
var UserNameLog = User.Identity.Name;
AspNetUser a = db.AspNetUsers.First(x => x.UserName == UserNameLog);
string UserIDLog = a.Id;
var classObjLog = Request.Form["ClassID"];
var logMessage = "A new Announcement Added, Topic: " + aspNetAnnouncement.Title + ", Description: " + aspNetAnnouncement.Description + ", ClassIDs: " + classObjLog;
var LogControllerObj = new AspNetLogsController();
LogControllerObj.CreateLogSave(logMessage, UserIDLog);
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
}
catch (Exception)
{
dbContextTransaction.Dispose();
}
return(RedirectToAction("Teacher_Announcement", "Teacher_Dashboard"));
}
return(View(aspNetAnnouncement));
}
