public JsonResult LoadTimeSheetDetails(TimeSheetDetailsFilterViewModel viewModel)
{
try
{
if (ModelState.IsValid)
{
#region Result ViewModel
//Get Data from Database
var mergeCellGroupColumnNameList = new string[] { "ProjectText", "ApprovalStatus", "SubmittedText" };
var footerColumnNameList = GetFooterColumnNameList();
var highLightColumnNameList = GetHighLightAndOffDayColumnNameList();
var changeColumnNameList = GetChangeColumnNameList();
var changeColumnHeaderList = GetChangeColumnHeaderList();
//var changeColumnNameList = new string[] { };
//var changeColumnHeaderList = new string[] { };
var offDayColumnNameList = GetHighLightAndOffDayColumnNameList();
var footerTextColumnName = "CompletedText";
var mergeColumnHeaderStartColumnName = GetMergeColumnHeaderStartColumnName();
var mergeColumnHeaderNumberOfColumns = GetMergeColumnHeaderNumberOfColumns();
var flexiValue = GetFlexiValue();
//Get Data from Database
TimeSheetDetailsFilterResultViewModel timeSheetFilterResultViewModel = new TimeSheetDetailsFilterResultViewModel();
timeSheetFilterResultViewModel.FortnightType = 1;
timeSheetFilterResultViewModel.FortnightDayNumber = 15;
timeSheetFilterResultViewModel.MergeCellGroupColumnNameList = mergeCellGroupColumnNameList.ToArray();
timeSheetFilterResultViewModel.FooterColumnNameList = footerColumnNameList.ToArray();
timeSheetFilterResultViewModel.FooterTextColumnName = footerTextColumnName;
timeSheetFilterResultViewModel.MergeColumnHeaderStartColumnName = mergeColumnHeaderStartColumnName;
timeSheetFilterResultViewModel.MergeColumnHeaderNumberOfColumns = mergeColumnHeaderNumberOfColumns;
timeSheetFilterResultViewModel.HighLightColumnNameList = highLightColumnNameList.ToArray();
timeSheetFilterResultViewModel.ChangeColumnNameList = changeColumnNameList.ToArray();
timeSheetFilterResultViewModel.ChangeColumnHeaderList = changeColumnHeaderList.ToArray();
timeSheetFilterResultViewModel.OffDayColumnNameList = offDayColumnNameList.ToArray();
timeSheetFilterResultViewModel.FlexiValue = flexiValue;
//timeSheetFilterResultViewModel.JqGridUrl = "";
#endregion
return Json(new { data = timeSheetFilterResultViewModel, status = Boolean.TrueString }, JsonRequestBehavior.AllowGet);
}
return Json(new { data = "Error!", status = Boolean.FalseString }, JsonRequestBehavior.AllowGet);
}
catch (Exception ex)
{
return Json(new { data = "Error!", status = Boolean.FalseString }, JsonRequestBehavior.AllowGet);
}
}
public JsonResult LoadTimeSheet(TimeSheetDetailsFilterViewModel viewModel)
{
try
{
if (ModelState.IsValid)
{
#region GridColumnNameList Data
List<string> gridColumnNameArrayList = new List<string>();
gridColumnNameArrayList.Add("Id");
gridColumnNameArrayList.Add("ProjectNo");
gridColumnNameArrayList.Add("Project No");
gridColumnNameArrayList.Add("IsProject");
gridColumnNameArrayList.Add("IsApprovalStatus");
gridColumnNameArrayList.Add("Approval Status");
gridColumnNameArrayList.Add("IsSubmittedTo");
gridColumnNameArrayList.Add("SubmittedTo");
gridColumnNameArrayList.Add("Submitted To");
gridColumnNameArrayList.Add("IsActivity");
gridColumnNameArrayList.Add("Activity");
gridColumnNameArrayList.Add("IsCompleted");
gridColumnNameArrayList.Add("Completed");
gridColumnNameArrayList.Add("Is Complete");
gridColumnNameArrayList.Add("IsEdited"); //index 14 of ArrayList
gridColumnNameArrayList.Add("1");
gridColumnNameArrayList.Add("2");
gridColumnNameArrayList.Add("3");
gridColumnNameArrayList.Add("4");
gridColumnNameArrayList.Add("5");
var gridColumnNameList = gridColumnNameArrayList.ToArray();
#endregion
#region GridColumnModelList Data
List<string> gridColumnModelNameArrayList = new List<string>();
gridColumnModelNameArrayList.Add("Id");
gridColumnModelNameArrayList.Add("ProjectNo");
gridColumnModelNameArrayList.Add("ProjectText");
gridColumnModelNameArrayList.Add("IsProject");
gridColumnModelNameArrayList.Add("IsApprovalStatus");
gridColumnModelNameArrayList.Add("ApprovalStatus");
gridColumnModelNameArrayList.Add("IsSubmittedTo");
gridColumnModelNameArrayList.Add("SubmittedTo");
gridColumnModelNameArrayList.Add("SubmittedText");
gridColumnModelNameArrayList.Add("IsActivity");
gridColumnModelNameArrayList.Add("Activity");
gridColumnModelNameArrayList.Add("IsCompleted");
gridColumnModelNameArrayList.Add("Completed");
gridColumnModelNameArrayList.Add("CompletedText");
gridColumnModelNameArrayList.Add("IsEdited"); //index 14 of ArrayList
gridColumnModelNameArrayList.Add("1");
gridColumnModelNameArrayList.Add("2");
gridColumnModelNameArrayList.Add("3");
gridColumnModelNameArrayList.Add("4");
gridColumnModelNameArrayList.Add("5");
var gridColumnModelNameList = gridColumnModelNameArrayList.ToArray();
#endregion
#region Result ViewModel
var mergeCellGroupColumnNameList = new string[] { "ProjectText", "ApprovalStatus", "SubmittedText" };
var footerColumnNameList = new string[] { "DayOne", "DayTwo", "DayThree", "DayFour", "DayFive" };
var highLightColumnNameList = new string[] { "DayOne", "DayFive" };
var changeColumnNameList = new string[] { "DayOne", "DayFive" };
var offDayColumnNameList = new string[] { "DayOne", "DayFive" };
var footerTextColumnName = "CompletedText";
var mergeColumnHeaderStartColumnName = "DayOne";
var mergeColumnHeaderNumberOfColumns = "5";
var flexiValue = "8";
TimeSheetDetailsFilterResultViewModel timeSheetFilterResultViewModel = new TimeSheetDetailsFilterResultViewModel();
timeSheetFilterResultViewModel.FortnightType = 1;
timeSheetFilterResultViewModel.FortnightDayNumber = 15;
timeSheetFilterResultViewModel.MergeCellGroupColumnNameList = mergeCellGroupColumnNameList.ToArray();
timeSheetFilterResultViewModel.FooterColumnNameList = footerColumnNameList.ToArray();
timeSheetFilterResultViewModel.FooterTextColumnName = footerTextColumnName;
timeSheetFilterResultViewModel.MergeColumnHeaderStartColumnName = mergeColumnHeaderStartColumnName;
timeSheetFilterResultViewModel.MergeColumnHeaderNumberOfColumns = mergeColumnHeaderNumberOfColumns;
timeSheetFilterResultViewModel.HighLightColumnNameList = highLightColumnNameList.ToArray();
timeSheetFilterResultViewModel.ChangeColumnNameList = changeColumnNameList.ToArray();
timeSheetFilterResultViewModel.OffDayColumnNameList = offDayColumnNameList.ToArray();
timeSheetFilterResultViewModel.FlexiValue = flexiValue;
//timeSheetFilterResultViewModel.GridColumnNameList = gridColumnNameList;
//timeSheetFilterResultViewModel.GridColumnModelNameList = gridColumnModelNameList;
//timeSheetFilterResultViewModel.JqGridUrl = "";
#endregion
return Json(new { data = timeSheetFilterResultViewModel, status = Boolean.TrueString }, JsonRequestBehavior.AllowGet);
}
return Json(new { data = "Error!", status = Boolean.FalseString }, JsonRequestBehavior.AllowGet);
}
catch (Exception ex)
{
return Json(new { data = "Error!", status = Boolean.FalseString }, JsonRequestBehavior.AllowGet);
}
}