|
public JsonResult LoadData(Params param)
{
// Fetching data from the different tables
var data1 = tbl1.Tables.ToList();
var data2 = tb2.AppointmentTables.ToList();
// Comining the different tables data to the one variable
List<AppointmentData> resultData = new List<AppointmentData>();
for(int i = 0; i < data1.Count; i++)
{
resultData.Add(new AppointmentData { Id = data1[i].Id, Subject = data1[i].Subject, StartTime = data1[i].StartTime, EndTime = data1[i].EndTime, Description = data1[i].Description });
}
for(int i = 0; i < data2.Count; i++)
{
resultData.Add(new AppointmentData { Id = data2[i].Id, Subject = data2[i].Subject, StartTime = data2[i].StartTime, EndTime = data2[i].EndTime, Description = data2[i].Description });
}
// Returning the combined data
return Json(resultData, JsonRequestBehavior.AllowGet);
} |
