public EventModel()
{
this.CalenderResources = new List<ScheduleResources>();
using (var OrderMangtDB = new OrderMgntEntities())
{
var calenderUsers = OrderMangtDB.CalendarUsers.ToList();
List<ScheduleResources> lstresources = new List<ScheduleResources>();
foreach (var item in calenderUsers)
{
ScheduleResources scheduleResources = new ScheduleResources();
scheduleResources.Text = GetUserNameById((int)item.UserId);
scheduleResources.Value = item.CalendarId.ToString();
scheduleResources.Color = item.Color;
lstresources.Add(scheduleResources);
}
this.CalenderResources = lstresources;
}
}
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 JsonResult GetUserList([DataSourceRequest] DataSourceRequest request)
{
List<ScheduleResources> lstresources = new List<ScheduleResources>();
using (var OrderMangtDB = new OrderMgntEntities())
{
var calenderUsers = OrderMangtDB.CalendarUsers.ToList();
Controllers.SchedulerController scheduleCntrl = new Controllers.SchedulerController();
foreach (var item in calenderUsers)
{
ScheduleResources scheduleResources = new ScheduleResources();
scheduleResources.Text = scheduleCntrl.GetUserNameById((int)item.UserId);
scheduleResources.Value = item.CalendarId.ToString();
scheduleResources.Color = item.Color;
lstresources.Add(scheduleResources);
}
;
}
JsonResult jsonResult = Json(lstresources.ToDataSourceResult(request));
jsonResult.MaxJsonLength = Int32.MaxValue;
return jsonResult;
}
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);
}
public JsonResult GetCalenderUser()
{
IList<ScheduleResources> lstresources = new List<ScheduleResources>();
try
{
// using (var OrderMangtDB = new OrderMgntEntities())
// {
var currentuser = UserManager.Current();
if (currentuser != null)
{
var users = _scheduler.GetAllUsersByOrgId(currentuser.OrgId.Value);
var calendarUserlst = _scheduler.GetAllCalendarUser();
var calenderUsers =
users.Where(
m => (m.UserType == 1 || m.UserType == 2) && m.IsActive == true)
.Join(calendarUserlst, e => e.Row_Id, d => d.UserId,
(e, d) => new { e.FirstName, e.LastName, e.UserType, d.UserId, d.Color, d.CalendarId }).OrderBy(e=> e.FirstName);
if (calenderUsers != null && calenderUsers.ToList().Count > 0)
{
foreach (var item in calenderUsers.ToList())
{
var scheduleResources = new ScheduleResources();
scheduleResources.Text = item.FirstName + " " + item.LastName;
scheduleResources.Value = item.CalendarId.ToString();
if (item != null && item.Color != null)
{
scheduleResources.Color = item.Color.Replace("#", "\\#");
}
else
{
scheduleResources.Color = "";
}
lstresources.Add(scheduleResources);
}
}
}
// }
}
catch (Exception ex)
{
string msg = ex.Message;
}
return Json(lstresources, JsonRequestBehavior.AllowGet);
}
