public ActionResult Index() { // GoogleServiceMethodCalls objGoogleCal = new GoogleServiceMethodCalls(); // objGoogleCal.CheckCalendarEvents("*****@*****.**"); //objGoogleCal.CheckCalendarEvents("*****@*****.**"); // objGoogleCal.CheckCalendarEvents("*****@*****.**"); // objGoogleCal.CheckCalendarEvents("*****@*****.**"); //if (itemlistex.Items[i].Id == "3784i2iqlb187phdp7d76g6et4") // { // } var schedulerViewModel = new Models.SchedulerViewModel(); var currentuser = UserManager.Current(); if (currentuser != null) { // var users = _scheduler.GetAllUsersByOrgId(Convert.ToInt32(currentuser.OrgId)); // var usercalenderlst = _scheduler.GetCalenderUsers(Convert.ToInt32(currentuser.OrgId)); // var userProductGroups = _scheduler.GetUserProductCalendar(Convert.ToInt32(currentuser.OrgId)); //var calenderUsers = // users.Join(usercalenderlst, e => e.Row_Id, d => d.UserId, (e, d) => new { e.FirstName, e.LastName, e.UserType, d.UserId, d.Color, d.CalendarId }).ToList().OrderBy(x => x.FirstName).ToList(); ; var calenderUsers = _scheduler.GetCalenderUsers(Convert.ToInt32(currentuser.OrgId)); var userProductCalendar = _scheduler.GetUserProductCalendar(Convert.ToInt32(currentuser.OrgId)); //var userProductCalendar = // calenderUsers.ToList() // .Join(userProductGroups, e => e.UserId, f => f.UserId, // (e, f) => new { e.UserId, e.UserType, e.FirstName, e.LastName, e.CalendarId, f.ProductGroupId }); var userProductCalendarlst = new List<UserProductCalendar>(); foreach (var itemgrp in userProductCalendar) { if (itemgrp != null) { var grodgrp = new UserProductCalendar(); grodgrp.UserId = itemgrp.UserId.ToString(); grodgrp.CalendarId = itemgrp.CalendarId.ToString(); grodgrp.UserProductGroup = itemgrp.ProductGroupId.ToString(); grodgrp.UserName = itemgrp.FirstName + " " + itemgrp.LastName; userProductCalendarlst.Add(grodgrp); } } schedulerViewModel.UserProductCalendar = userProductCalendarlst; var lstresources = new List<ScheduleResources>(); foreach (var item in calenderUsers) { if (item != null) { ScheduleResources scheduleResources = new ScheduleResources(); scheduleResources.UserId = item.UserId.ToString(); scheduleResources.Text = item.FirstName + " " + item.LastName; scheduleResources.Value = item.CalendarId.ToString(); scheduleResources.Color = item.Color; lstresources.Add(scheduleResources); } } schedulerViewModel.CalenderResources = lstresources.Take(1).ToList(); schedulerViewModel.AllCalenderResources = lstresources; schedulerViewModel.AllUsers = lstresources; //Group resource code } return PartialView("_SchedulerIndex", schedulerViewModel); }
public ActionResult GroupCalendar(IEnumerable<int> userIds) { var schedulerViewModel = new Models.SchedulerViewModel(); //using (var OrderMangtDB = new OrderMgntEntities()) //{ var currentuser = UserManager.Current(); string struserids = userIds.Select(x => x.ToString()).Aggregate("", (a, b) => a + "" + b + ",").ToString(); struserids = struserids.Remove(struserids.Length - 1, 1); var calendarUser = _scheduler.GetGroupCalendarUsers(currentuser.OrgId, struserids); //var calendarUser2 = OrderMangtDB.CalendarUsers.Where(x => userIds.Contains((int)x.CalendarId)) // .Distinct() // .Join( // OrderMangtDB.Users.Where(m => m.OrgId == currentuser.OrgId && (m.UserType == 1 || m.UserType == 2) && m.IsActive == true && m.IsDeleted == false), cu => cu.UserId, u => u.Row_Id, (cu, u) => new { u.FirstName, u.LastName, u.UserType, cu.UserId, cu.Color, cu.CalendarId }).OrderBy(x => x.FirstName).ToList(); List<ScheduleResources> lstresources = new List<ScheduleResources>(); if (calendarUser != null) { foreach (var item in calendarUser) { ScheduleResources scheduleResources = new ScheduleResources(); scheduleResources.Text = item.FirstName + " " + item.LastName; // GetUserNameById((int)item.UserId); scheduleResources.Value = item.CalendarId.ToString(); scheduleResources.Color = item.Color; lstresources.Add(scheduleResources); } } schedulerViewModel.CalenderResources = lstresources; // } return PartialView("_Scheduler", schedulerViewModel); }