public ActionResult ScheduleAttendees(ProjectMom model) { DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1(); int value = Convert.ToInt32(model.Attendee); var check = db.MeetingGuids.Where(x => x.UserId == value).Select(o => o.Id).FirstOrDefault(); var asobj = db.MeetingGuids.CreateObject(); if (check == 0) { asobj.UserId = value; var fname = db.Users.Where(x => x.UserID == value).Select(o => o.FirstName + "" + (o.LastName ?? "")).FirstOrDefault(); asobj.FirstName = fname; db.MeetingGuids.AddObject(asobj); db.SaveChanges(); } return(Json("Success", JsonRequestBehavior.AllowGet)); }
public ActionResult MOM(ProjectMom objmom) { DSRCManagementSystemEntities1 ob = new DSRCManagementSystemEntities1(); objmom.ProjectId = Convert.ToInt32(System.Web.HttpContext.Current.Application["agenda"]); var agenda = ob.AgendaFeedbacks.Where(x => EntityFunctions.TruncateTime(x.AgendaDate) == DateTime.Today.Date && x.ProjectId == objmom.ProjectId).Select(x => x.Agenda).FirstOrDefault(); var feedback = ob.AgendaFeedbacks.Where(x => EntityFunctions.TruncateTime(x.FeedbackDate) == DateTime.Today.Date && x.ProjectId == objmom.ProjectId).Select(x => x.Feedback).FirstOrDefault(); var mom = ob.AgendaFeedbacks.Where(x => EntityFunctions.TruncateTime(x.FeedbackDate) == DateTime.Today.Date && x.ProjectId == objmom.ProjectId).Select(x => x.MOM).FirstOrDefault(); if (agenda != null && feedback != null && mom == null) { DSRCManagementSystemEntities1 obj = new DSRCManagementSystemEntities1(); var fed = ob.AgendaFeedbacks.Where(x => EntityFunctions.TruncateTime(x.FeedbackDate) == DateTime.Today.Date && x.ProjectId == objmom.ProjectId).Select(x => x).FirstOrDefault(); fed.MOM = objmom.ProjectMOM; fed.ProjectId = objmom.ProjectId; fed.MOMDate = System.DateTime.Now; ob.SaveChanges(); return(Json(new { Result = "Success", URL = @Url.Action("AlertPopUp", "Popup") }, JsonRequestBehavior.AllowGet)); } else if (agenda == null && feedback != null && mom == null) { DSRCManagementSystemEntities1 obj = new DSRCManagementSystemEntities1(); var age = obj.AgendaFeedbacks.Where(x => EntityFunctions.TruncateTime(x.FeedbackDate) == DateTime.Today.Date && x.ProjectId == objmom.ProjectId).Select(x => x).FirstOrDefault(); age.MOM = objmom.ProjectMOM; age.MOMDate = System.DateTime.Now; age.ProjectId = objmom.ProjectId; obj.SaveChanges(); return(Json(new { Result = "Success", URL = @Url.Action("AlertPopUp", "Popup") }, JsonRequestBehavior.AllowGet)); } else if (agenda != null && feedback == null && mom == null) { DSRCManagementSystemEntities1 obj = new DSRCManagementSystemEntities1(); var age = obj.AgendaFeedbacks.Where(x => EntityFunctions.TruncateTime(x.AgendaDate) == DateTime.Today.Date && x.ProjectId == objmom.ProjectId).Select(x => x).FirstOrDefault(); age.MOM = objmom.ProjectMOM; age.MOMDate = System.DateTime.Now; age.ProjectId = objmom.ProjectId; obj.SaveChanges(); return(Json(new { Result = "Success", URL = @Url.Action("AlertPopUp", "Popup") }, JsonRequestBehavior.AllowGet)); } else if (agenda == null && feedback == null && mom == null) { DSRCManagementSystemEntities1 obj = new DSRCManagementSystemEntities1(); DSRCManagementSystem.AgendaFeedback objd = new DSRCManagementSystem.AgendaFeedback(); objd.MOM = objmom.ProjectMOM; objd.ProjectId = objmom.ProjectId; objd.MOMDate = System.DateTime.Now; obj.AddToAgendaFeedbacks(objd); obj.SaveChanges(); return(Json(new { Result = "Success", URL = @Url.Action("AlertPopUp", "Popup") }, JsonRequestBehavior.AllowGet)); } else if (agenda == null && feedback == null && mom != null) { DSRCManagementSystemEntities1 obj = new DSRCManagementSystemEntities1(); DSRCManagementSystem.AgendaFeedback objd = new DSRCManagementSystem.AgendaFeedback(); objd.MOM = objmom.ProjectMOM; objd.ProjectId = objmom.ProjectId; objd.MOMDate = System.DateTime.Now; obj.AddToAgendaFeedbacks(objd); obj.SaveChanges(); return(Json(new { Result = "Success", URL = @Url.Action("AlertPopUp", "Popup") }, JsonRequestBehavior.AllowGet)); } else if (agenda != null && feedback != null && mom != null) { DSRCManagementSystemEntities1 obj = new DSRCManagementSystemEntities1(); DSRCManagementSystem.AgendaFeedback objd = new DSRCManagementSystem.AgendaFeedback(); objd.MOM = objmom.ProjectMOM; objd.ProjectId = objmom.ProjectId; objd.MOMDate = System.DateTime.Now; obj.AddToAgendaFeedbacks(objd); obj.SaveChanges(); return(Json(new { Result = "Success", URL = @Url.Action("AlertPopUp", "Popup") }, JsonRequestBehavior.AllowGet)); } return(View()); }