public ActionResult PendingDataProviderAction(JQueryDataTableParamModel aModel) { string baNumber = Convert.ToString(Request["sSearch_0"]); string name = Convert.ToString(Request["sSearch_1"]); string letterNumber = Convert.ToString(Request["sSearch_2"]); string requestDate = Convert.ToString(Request["sSearch_3"]); string phoneNumber = Convert.ToString(Request["sSearch_4"]); string requestType = Convert.ToString(Request["sSearch_5"]); string[] dates = Regex.Split(requestDate, "-yadcf_delim-"); string fromDate = string.Empty; string toDate = string.Empty; if (dates.Count() == 2) { fromDate = dates[0]; toDate = dates[1]; } if (dates.Count() == 1) { fromDate = dates[0]; } TelephoneRequest aRequest = new TelephoneRequest(); int totalRecords = 0; int filteredRecord = 0; List<string[]> pendingRequest = aRequest.GetPendingRequest(out totalRecords,out filteredRecord, baNumber,name,letterNumber,fromDate,toDate,phoneNumber,requestType,aModel.iDisplayStart,aModel.iDisplayLength); return Json(new { sEcho = aModel.sEcho, iTotalRecords = filteredRecord, iTotalDisplayRecords = totalRecords , aaData = pendingRequest }, JsonRequestBehavior.AllowGet); }
public ActionResult GetActivePhoneDataProviderAction(JQueryDataTableParamModel aModel) { string baNumber = Convert.ToString(Request["sSearch_0"]); string name = Convert.ToString(Request["sSearch_1"]); string palteName = Convert.ToString(Request["sSearch_2"]); string requestDate = Convert.ToString(Request["sSearch_3"]); string phoneNumber = Convert.ToString(Request["sSearch_4"]); string rank = Convert.ToString(Request["sSearch_5"]); string[] dates = Regex.Split(requestDate, "-yadcf_delim-"); string fromDate = string.Empty; string toDate = string.Empty; if (dates.Count() == 2) { fromDate = dates[0]; toDate = dates[1]; } if (dates.Count() == 1) { fromDate = dates[0]; } TelephoneNumber aRequest = new TelephoneNumber(); int totalRecords = 0; int filteredRecord = 0; List<string[]> terminatedHistory = aRequest.GetActivePhoneNumberDetails(out totalRecords, out filteredRecord, baNumber, name, palteName, fromDate, toDate, phoneNumber, rank, aModel.iDisplayStart, aModel.iDisplayLength); return Json(new { sEcho = aModel.sEcho, iTotalRecords = filteredRecord, iTotalDisplayRecords = totalRecords, aaData = terminatedHistory }, JsonRequestBehavior.AllowGet); }
public JsonResult DataProviderAction(JQueryDataTableParamModel aModel) { List<string> columnlist = new List<string>(new string[] {"BANumber", "Name", "Rank", "NewPhoneNumber", "ComplainDate", "ComplainType"}); string serachValue = Request["columns[0][search][value]"]; var roleId = Request.Params["max"]; var banumberFilter = Convert.ToString(Request["sSearch_0"]); var nameFilter = Convert.ToString(Request["sSearch_1"]); var rankFilter = Convert.ToString(Request["sSearch_2"]); var dateFilter = Convert.ToString(Request["sSearch_4"]); var phoneFilter = Convert.ToString(Request["sSearch_3"]); var complainFilter = Convert.ToString(Request["sSearch_5"]); var hourlyFilter = Convert.ToString(Request["sSearch_6"]); var isNameSortable = Convert.ToBoolean(Request["bSortable_1"]); string sSearch = string.Empty; if (aModel.sSearch == null) { sSearch = ""; } else { sSearch = aModel.sSearch.ToString(); } var banameSortDirection = Request["sSortDir_0"]; DateTime fromDate = DateTime.MinValue; DateTime toDate = DateTime.MaxValue; if (hourlyFilter == "") { if (dateFilter.Contains("-yadcf_delim-")) { string a1 = dateFilter.Replace("-yadcf_delim-", "~"); //Split date range filters with ~ fromDate = a1.Split('~')[0] == "" ? DateTime.MinValue : Convert.ToDateTime(a1.Split('~')[0]); toDate = a1.Split('~')[1] == "" ? DateTime.MaxValue : Convert.ToDateTime(a1.Split('~')[1]).AddHours(23.99); // toDate = toDate.AddHours(23.99); } } else if (hourlyFilter.Trim() == "Last 12 Hour Data") { toDate = DateTime.Now; fromDate = DateTime.Now.AddHours(-12.5); } else { toDate = DateTime.Now; fromDate = DateTime.Now.AddHours(-24.5); } FilteredLists filteredComplaneList = Telephone.GetFilteredComplaneList(sSearch, banumberFilter, phoneFilter, nameFilter, rankFilter, complainFilter, fromDate, toDate, aModel.iDisplayStart, aModel.iDisplayLength, aModel.sSortDir_0, aModel.iSortCol_0); var result = from c in filteredComplaneList.aComplainList select new[] { c.BANumber, c.Name, c.Rank, c.NewPhoneNumber, c.ComplainDate, c.ComplainType, "Edit", "Delete", Convert.ToString(c.ComplainId) }; List<string[]> resultList = result.ToList(); return Json(new { sEcho = aModel.sEcho, yadcf_data_0 = filteredComplaneList.BaNumberList, yadcf_data_2 = filteredComplaneList.RankList, yadcf_data_5 = filteredComplaneList.ComplainTypeList, iTotalRecords = filteredComplaneList.TotalSize, iTotalDisplayRecords = filteredComplaneList.FilteredSize, aaData = resultList }, JsonRequestBehavior.AllowGet); //Extract only current page }
public JsonResult TelephoneDataProviderAction(JQueryDataTableParamModel aModel) { List<string> columnlist = new List<string>(new string[] { "BANumber", "Name", "Rank", "NewPhoneNumber", "Address", "Gender", "Status", "ConnectedDate", "DisconnectedDate" }); string serachValue = Request["columns[0][search][value]"]; var roleId = Request.Params["max"]; var banumberFilter = Convert.ToString(Request["sSearch_0"]).Trim(); var nameFilter = Convert.ToString(Request["sSearch_1"]).Trim(); var rankFilter = Convert.ToString(Request["sSearch_2"]).Trim(); var phoneFilter = Convert.ToString(Request["sSearch_3"]).Trim(); // var addressFilter = Convert.ToString(Request["sSearch_4"]).Trim(); var phoneTypeFilter = Convert.ToString(Request["sSearch_4"]).Trim(); var homeAddressFilter = Convert.ToString(Request["sSearch_5"]).Trim(); var officeAddressFilter = Convert.ToString(Request["sSearch_6"]); var genderFilter = Convert.ToString(Request["sSearch_7"]); var complainFilter = Convert.ToString(Request["sSearch_5"]); var hourlyFilter = Convert.ToString(Request["sSearch_8"]); var isNameSortable = Convert.ToBoolean(Request["bSortable_1"]); DateTime fromDate = DateTime.MinValue; DateTime toDate = DateTime.MaxValue; if (hourlyFilter.Contains("-yadcf_delim-")) { string a1 = hourlyFilter.Replace("-yadcf_delim-", "~"); //Split date range filters with ~ fromDate = a1.Split('~')[0] == "" ? DateTime.MinValue : Convert.ToDateTime(a1.Split('~')[0]); toDate = a1.Split('~')[1] == "" ? DateTime.MaxValue : Convert.ToDateTime(a1.Split('~')[1]).AddHours(23.99); } string sSearch = string.Empty; if (aModel.sSearch == null) { sSearch = ""; } else { sSearch = aModel.sSearch.ToString(); } var banameSortDirection = Request["sSortDir_0"]; TelphoneUser aTelephoneUser = new TelphoneUser(); // List<TelphoneUser> aUsersList = aTelephoneUser.GetTelphoneUsers(); Telephone aTelephone = new Telephone(); FilteredLists filterTelphoneUsers = aTelephone.GetFilteredPhoneList(sSearch, banumberFilter, phoneFilter, nameFilter, rankFilter, homeAddressFilter, officeAddressFilter, phoneTypeFilter, genderFilter, fromDate, toDate, aModel.iDisplayStart, aModel.iDisplayLength, aModel.sSortDir_0, aModel.iSortCol_0); var result = from c in filterTelphoneUsers.aTelePhoneUserList select new[] { c.BANumber, c.Name, c.Rank, c.NewPhoneNumber, c.PhoneType, c.HomeAddress, c.OfficeAddress, c.Gender, c.ConnectedDate, "Edit", Convert.ToString(c.ID) }; List<string[]> resultList = result.ToList(); List<string> aRankList = new List<string>(); List<string> banumberList = new List<string>(); List<string> complainTypeList = new List<string>(); List<string> statusList=new List<string>(); return Json(new { sEcho = aModel.sEcho, yadcf_data_0 = filterTelphoneUsers.BaNumberList, yadcf_data_2 = filterTelphoneUsers.RankList, yadcf_data_4 = filterTelphoneUsers.PhoneTypeList, // yadcf_data_6 = statusList, iTotalRecords = filterTelphoneUsers.TotalSize, iTotalDisplayRecords = filterTelphoneUsers.FilteredSize, aaData = resultList }, JsonRequestBehavior.AllowGet); }
public JsonResult ResolvedDataProviderAction(JQueryDataTableParamModel aModel) { List<string> columnlist = new List<string>(new string[] { "BANumber", "Name", "Rank", "NewPhoneNumber", "ComplainDate", "ComplainType", "ResolveBy", "ResolvedDate", "ActionTaken", "Remarks" }); var banumberFilter = Convert.ToString(Request["sSearch_0"]); var nameFilter = Convert.ToString(Request["sSearch_1"]); var rankFilter = Convert.ToString(Request["sSearch_2"]).Trim(); var dateFilter = Convert.ToString(Request["sSearch_4"]); var phoneFilter = Convert.ToString(Request["sSearch_3"]).Trim(); var complainFilter = Convert.ToString(Request["sSearch_5"]).Trim(); var hourlyFilter = Convert.ToString(Request["sSearch_6"]).Trim(); var resolverFilter = Convert.ToString(Request["sSearch_6"]).Trim(); var resolveDateFilter = Convert.ToString(Request["sSearch_7"]); var actionTakenFilter = Convert.ToString(Request["sSearch_8"]).Trim(); var remarksFilter = Convert.ToString(Request["sSearch_9"]).Trim(); var isNameSortable = Convert.ToBoolean(Request["bSortable_1"]); string sSearch = string.Empty; if (aModel.sSearch == null) { sSearch = ""; } else { sSearch = aModel.sSearch.ToString(); } var banameSortDirection = Request["sSortDir_0"]; DateTime fromDate = DateTime.MinValue; DateTime toDate = DateTime.MaxValue; if (dateFilter.Contains("-yadcf_delim-")) { string a1 = dateFilter.Replace("-yadcf_delim-", "~"); //Split date range filters with ~ fromDate = a1.Split('~')[0] == "" ? DateTime.MinValue : Convert.ToDateTime(a1.Split('~')[0]); toDate = a1.Split('~')[1] == "" ? DateTime.MaxValue : Convert.ToDateTime(a1.Split('~')[1]).AddHours(23.99); } DateTime resolvefromDate = DateTime.MinValue; DateTime resolvetoDate = DateTime.MaxValue; if (resolveDateFilter.Contains("-yadcf_delim-")) { string b1 = resolveDateFilter.Replace("-yadcf_delim-", "~"); //Split date range filters with ~ resolvefromDate = b1.Split('~')[0] == "" ? DateTime.MinValue : Convert.ToDateTime(b1.Split('~')[0]); resolvetoDate = b1.Split('~')[1] == "" ? DateTime.MaxValue : Convert.ToDateTime(b1.Split('~')[1]).AddHours(23.99); } FilteredLists filteredComplaneList = Telephone.GetResolvedFilteredComplaneList(sSearch, banumberFilter, phoneFilter, nameFilter, rankFilter, complainFilter, fromDate, toDate, resolverFilter, resolvefromDate, resolvetoDate, actionTakenFilter, remarksFilter,aModel.iDisplayStart,aModel.iDisplayLength,aModel.sSortDir_0,aModel.iSortCol_0); var result = from c in filteredComplaneList.aComplainList select new[] { c.BANumber, c.Name, c.Rank, c.NewPhoneNumber, c.ComplainDate, c.ComplainType, c.ResolveBy, c.ResolvedDate, c.ActionTaken, c.Remarks, "View", Convert.ToString(c.ComplainId) }; List<string[]> resultList = result.ToList(); return Json(new { sEcho = aModel.sEcho, yadcf_data_0 = filteredComplaneList.BaNumberList, yadcf_data_2 = filteredComplaneList.RankList, yadcf_data_5 = filteredComplaneList.ComplainTypeList, yadcf_data_6 = filteredComplaneList.ResolverList, //iTotalRecords = complanList.Count(), iTotalRecords = filteredComplaneList.TotalSize, iTotalDisplayRecords = filteredComplaneList.FilteredSize, aaData = resultList }, JsonRequestBehavior.AllowGet); //Extract only current page }
public ActionResult GetActiveTelephoneUsers(JQueryDataTableParamModel aModel) { TelephoneUser aUser = new TelephoneUser(); int totalRecords = 0; int filteredRecord = 0; string baNumber = Convert.ToString(Request["sSearch_0"]); string name = Convert.ToString(Request["sSearch_1"]); string palteName = Convert.ToString(Request["sSearch_2"]); string rank = Convert.ToString(Request["sSearch_3"]); List<string[]> allUsers = aUser.GetAllTelephoneUser(out totalRecords,out filteredRecord,aModel.iDisplayStart,aModel.iDisplayLength,baNumber,name,palteName,rank); return Json(new { sEcho = aModel.sEcho, iTotalRecords = filteredRecord, iTotalDisplayRecords = totalRecords, aaData = allUsers }, JsonRequestBehavior.AllowGet); }