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());
}
