public ActionResult DropView()
{
Models.mysqlConnector objConnector = new Models.mysqlConnector();
ViewBag.treeDataSource = objConnector.GetPersonContacts();
List <SchedulerDataModel> eventListData = new List <SchedulerDataModel>();
eventListData = objConnector.GetEvents();
ViewBag.Jobs = objConnector.GetJobs();
foreach (SchedulerDataModel objemodel in eventListData)
{
string[] newArr = new string[] { };
List <string> list = new List <string>();
string AttendeesData1 = objemodel.attendeesAsString;
if (AttendeesData1 != string.Empty)
{
string[] _arr = AttendeesData1.Split(',');
foreach (string stringCon in _arr)
{
list.Add(stringCon);
}
newArr = list.ToArray();
objemodel.Attendees = newArr;
}
else
{
objemodel.Attendees = new string[] { }
};
objemodel.Subject = objemodel.Job;
}
ViewBag.datasource = eventListData;
ViewBag.Resources = new string[] { "Jobs" };
return(View());
}
public ActionResult BindEvent()
{
Models.mysqlConnector objConnector = new Models.mysqlConnector();
List <SchedulerDataModel> eventListData = new List <SchedulerDataModel>();
eventListData = objConnector.GetEvents();
foreach (SchedulerDataModel objemodel in eventListData)
{
string[] newArr = new string[] { };
List <string> list = new List <string>();
string AttendeesData1 = objemodel.attendeesAsString;
if (AttendeesData1 != string.Empty)
{
string[] _arr = AttendeesData1.Split(',');
foreach (string stringCon in _arr)
{
list.Add(stringCon);
}
newArr = list.ToArray();
objemodel.Attendees = newArr;
}
else
{
objemodel.Attendees = new string[] { }
};
objemodel.Subject = objemodel.Job;
}
return(Json(eventListData, JsonRequestBehavior.AllowGet));
}
public JsonResult LoadData(Params param)
{
DateTime start = param.StartDate;
DateTime end = param.EndDate;
Models.mysqlConnector objConnector = new Models.mysqlConnector();
var data = objConnector.GetEvents();
return(Json(data, JsonRequestBehavior.AllowGet));
}
public JsonResult UpdateData(EditParams2 param)
{
Models.mysqlConnector objConnector = new Models.mysqlConnector();
if (param.action == "insert" || (param.action == "batch" && param.added != null)) // this block of code will execute while inserting the appointments
{
var value = (param.action == "insert") ? param.value : param.added[0];
int intMax = db.ScheduleEventDatas.ToList().Count > 0 ? db.ScheduleEventDatas.ToList().Max(p => p.Id) : 1;
DateTime startTime = Convert.ToDateTime(value.StartTime);
DateTime endTime = Convert.ToDateTime(value.EndTime);
SchedulerDataModel appointment = new SchedulerDataModel()
{
Id = intMax + 1,
StartTime = startTime.ToLocalTime(),
EndTime = endTime.ToLocalTime(),
Job = value.Job,
Attendees = value.Attendees,
Event = value.Event,
ResourceId = value.ResourceId,
IsAllDay = value.IsAllDay,
StartTimezone = value.StartTimezone,
EndTimezone = value.EndTimezone,
RecurrenceRule = value.RecurrenceRule,
RecurrenceID = value.RecurrenceID,
RecurrenceException = value.RecurrenceException,
};
string resp = objConnector.AddEvent(appointment);
ViewData["result"] = resp;
}
if (param.action == "remove" || (param.action == "batch" && param.deleted != null)) // this block of code will execute while removing the appointment
{
int key = Convert.ToInt32(param.key);
SchedulerDataModel obj2 = param.deleted.FirstOrDefault();
SchedulerDataModel appointment = new SchedulerDataModel();
if (appointment != null)
{
ViewData["result"] = objConnector.DeleteEvent(obj2.Id);
}
}
var data = objConnector.GetEvents();
return(Json(data, JsonRequestBehavior.AllowGet));
}
public JsonResult CrudActions(SchedulerDataModel obj)
{
Models.mysqlConnector objConnector = new Models.mysqlConnector();
var value = obj;
int intMax = db.ScheduleEventDatas.ToList().Count > 0 ? db.ScheduleEventDatas.ToList().Max(p => p.Id) : 1;
DateTime startTime = Convert.ToDateTime(value.StartTime);
DateTime endTime = Convert.ToDateTime(value.EndTime);
string resp = "";
if (obj.action == "edit")
{
SchedulerDataModel appointment = new SchedulerDataModel()
{
Id = value.Id,
StartTime = startTime.ToLocalTime(),
EndTime = endTime.ToLocalTime(),
Subject = value.Job,
Attendees = value.Attendees,
Event = value.Event,
ResourceId = value.ResourceId,
IsAllDay = value.IsAllDay,
StartTimezone = value.StartTimezone,
EndTimezone = value.EndTimezone,
RecurrenceRule = value.RecurrenceRule,
RecurrenceID = value.RecurrenceID,
RecurrenceException = value.RecurrenceException,
};
resp = objConnector.UpdateEvent(appointment);
}
else if (obj.action == "Add")
{
SchedulerDataModel appointment = new SchedulerDataModel()
{
StartTime = startTime.ToLocalTime(),
EndTime = endTime.ToLocalTime(),
Job = value.Subject,
Attendees = value.Attendees,
Event = value.Event,
ResourceId = value.ResourceId,
IsAllDay = value.IsAllDay,
StartTimezone = value.StartTimezone,
EndTimezone = value.EndTimezone,
RecurrenceRule = value.RecurrenceRule,
RecurrenceID = value.RecurrenceID,
RecurrenceException = value.RecurrenceException,
};
resp = objConnector.AddEvent(appointment);
}
else if (obj.action == "editFromDrop")
{
SchedulerDataModel appointment = new SchedulerDataModel()
{
Id = value.Id,
//StartTime = startTime.ToLocalTime(),
//EndTime = endTime.ToLocalTime(),
attendeesAsString = value.attendeesAsString,
//ResourceId = value.ResourceId,
};
List <SchedulerDataModel> eventListData2 = new List <SchedulerDataModel>();
eventListData2 = objConnector.searchEventByTime(appointment);
if (eventListData2 != null && eventListData2.Count > 0)
{
string[] _ArrAttendees = eventListData2.FirstOrDefault().attendeesAsString.Split(',');
int existCount = 0;
foreach (string valueString in _ArrAttendees)
{
if (valueString == value.attendeesAsString)
{
existCount++;
break;
}
}
if (existCount == 0)
{
string toModify = eventListData2.FirstOrDefault().attendeesAsString;
toModify = toModify + "," + value.attendeesAsString;
appointment.attendeesAsString = toModify;
appointment.Id = eventListData2.FirstOrDefault().Id;
resp = objConnector.updateByDrop(appointment);
}
}
}
ViewData["result"] = resp;
return(Json(new string[] { }, JsonRequestBehavior.AllowGet));
}