public ActionResult ProjectMeeting() { DSRCManagementSystemEntities1 objdb = new DSRCManagementSystemEntities1(); // var ProjectList = objdb.Projects.Where(x=>x.IsActive==true).ToList(); int userId = Convert.ToInt32(Session["UserID"]); var ProjectList = (from p in objdb.Projects join pt in objdb.Master_ProjectTypes on p.ProjectTypeID equals pt.ProjectTypeID join up in objdb.UserProjects.Where(x => x.UserID == userId) on p.ProjectID equals up.ProjectID where p.IsActive == true && (p.IsDeleted != true || p.IsDeleted == null) select new Projects() { ProjectID = p.ProjectID, ProjectName = p.ProjectName, ProjectCode = p.ProjectCode, ProjectType = pt.ProjectTypeName, RAGStatus = p.RAGStatus, RAGComments = p.RAGComments ?? "Comments not added", CommentsCreated = p.CommentsCreated, //MemberTypeID = up.MemberTypeID }).Distinct().ToList(); ProjectMeetingTime objtime = new ProjectMeetingTime(); var ProjectLead = (from t in objdb.Users.Where(x => x.IsActive == true && x.UserStatus != 6) join atn in objdb.MeetingGuids on t.UserID equals atn.UserId select new { Id = t.UserID, FirstName = t.FirstName + " " + (t.LastName.Length > 0 ? t.LastName : ""), LastName = t.LastName, }).ToList(); var Days = objdb.Master_Days.ToList(); ViewBag.Leaders = new MultiSelectList(ProjectLead, "Id", "FirstName", "LastName"); ViewBag.DayList = new SelectList(new[] { new Master_Days() { Id = 0, Days = "--Select--" } }.Union(Days), "Id", "Days", 0); ViewBag.Projects = new SelectList(ProjectList, "ProjectID", "ProjectName"); ViewBag.Week = new SelectList(new[] { new { Text = "--Select--", Value = 0 }, new { Text = "1", Value = 1 }, new { Text = "2", Value = 2 } }, "Value", "Text", 0); return(View()); }
public ActionResult ProjectMeeting(ProjectMeetingTime objmeeting) { DSRCManagementSystemEntities1 objdb = new DSRCManagementSystemEntities1(); var Message = ""; var already = objdb.MettingSchedules.Where(o => o.Week == objmeeting.Week && o.Day == objmeeting.Day && o.TimeSlot == objmeeting.TimeSlotFrom).Select(i => i.ProjectID).FirstOrDefault(); if (already != null) { return(Json(new { Result = "AlreadyExist", URL = @Url.Action("AlertPopUp", "Popup") }, JsonRequestBehavior.AllowGet)); } var time = Convert.ToDateTime(objmeeting.TimeSlotFrom); var hour = Convert.ToInt32(time.Hour); var min = Convert.ToInt32(time.Minute); var tt = time.ToString("tt"); // List<string> obj = new List<string>(); var obj = objdb.MettingSchedules.Where(o => o.Week == objmeeting.Week && o.Day == objmeeting.Day).Select(o => o).ToList(); TimeSpan CurTime = new TimeSpan(hour, min, 0); foreach (var item in obj) { var dbtime = Convert.ToDateTime(item.TimeSlot); var hourdb = Convert.ToInt32(dbtime.Hour); var mindb = Convert.ToInt32(dbtime.Minute); var ttdb = dbtime.ToString("tt"); TimeSpan Db_StartTime = new TimeSpan(hourdb, mindb, 0); var dbendtime = Convert.ToDateTime(item.EndTime); var hourenddb = Convert.ToInt32(dbendtime.Hour); var minenddb = Convert.ToInt32(dbendtime.Minute); var endttdb = dbendtime.ToString("tt"); TimeSpan Db_EndTime = new TimeSpan(hourenddb, minenddb, 0); if (Db_StartTime == CurTime) { Message = "availabletime"; return(Json(new { Result = Message }, JsonRequestBehavior.AllowGet)); } else if (Db_StartTime >= CurTime && CurTime < Db_EndTime) { Message = "availabletime"; return(Json(new { Result = Message }, JsonRequestBehavior.AllowGet)); } else if (Db_StartTime <= CurTime && CurTime <= Db_EndTime) { Message = "availabletime"; return(Json(new { Result = Message }, JsonRequestBehavior.AllowGet)); } } DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1(); DSRCManagementSystem.MettingSchedule objdetail = new DSRCManagementSystem.MettingSchedule(); objdetail.ProjectID = Convert.ToInt32(objmeeting.ProjectNameId); objdetail.TimeSlot = objmeeting.TimeSlotFrom; objdetail.EndTime = objmeeting.TimeSlotTo; objdetail.Day = objmeeting.Day; objdetail.Week = objmeeting.Week; objdetail.Attendees = objmeeting.Attendee; db.AddToMettingSchedules(objdetail); db.SaveChanges(); return(Json(new { Result = "Success" }, JsonRequestBehavior.AllowGet)); }