//[HttpPost] //[ValidateInput(false)] public FileResult ExportToCSV(long numberToExport, long districtID) //check of html string ook ingestuur moet word (soos by DataController) { var exports = new List <NatisExportModel>(); try { var tisService = new TISService(AuthenticatedUser.SessionToken); exports = (List <NatisExportModel>)tisService.GetExports(numberToExport, districtID); } catch (GatewayException gex) { // Probeer dalk viewbag error message (en return dalk iets) wat van toepassing is: ViewBag.ErrorMessage = gex.Message; RedirectToAction("Index"); } catch (Exception ex) { // Probeer dalk viewbag error message (en return dalk iets) wat van toepassing is: ViewBag.ErrorMessage = ex.Message; RedirectToAction("Index"); } StringBuilder sbRtn = new StringBuilder(); try { // As headers benodig word in die file: var header = string.Format("\"{0}\",{1},{2},{3},{4},{5}", "Reference Number", "Infringement Date", "Export Date", "Vehicle Registration", "Locked By Credential ID", "District ID" ); sbRtn.AppendLine(header); foreach (var export in exports) { var listResults = string.Format("\"{0}\",{1},{2},{3},{4},{5}", makeCsvFriendly(export.ReferenceNumber), makeCsvFriendly(export.InfringementDate), makeCsvFriendly(export.ExportDate), makeCsvFriendly(export.VehicleRegistration), makeCsvFriendly(export.LockedByCredentialID), makeCsvFriendly(export.DistrictID) ); sbRtn.AppendLine(listResults); } } catch (Exception ex) { ViewBag.ErrorMessage = ex.Message; RedirectToAction("Index"); } //File.AppendAllText("c:/Temp/CSVExport", sbRtn.ToString()); return(File(new System.Text.UTF8Encoding().GetBytes(sbRtn.ToString()), "text/csv", "CSVExport.csv")); }
public ActionResult CaptureTISDetails(string referenceNumber, string vehicleRegistration, long lockedByCredentialID) { var currentUserID = AuthenticatedUser.UserData.ID; var tisService = new TISService(AuthenticatedUser.SessionToken); if (string.IsNullOrEmpty(lockedByCredentialID.ToString()) || lockedByCredentialID.Equals(currentUserID)) { try { if (string.IsNullOrEmpty(lockedByCredentialID.ToString())) { if (tisService.CaptureLock(referenceNumber, vehicleRegistration)) { var initialTISList = new List <TISDataModel>(); var initialTISModel = new TISDataModel { ReferenceNumber = referenceNumber, VehicleRegistrationNumber = vehicleRegistration }; initialTISList.Add(initialTISModel); return(View(initialTISList)); } else { ViewBag.ErrorMessage = "Could not lock TIS instance."; return(RedirectToAction("TISCaptureList")); } } else { var initialTISList = new List <TISDataModel>(); var initialTISModel = new TISDataModel { ReferenceNumber = referenceNumber, VehicleRegistrationNumber = vehicleRegistration }; initialTISList.Add(initialTISModel); return(View(initialTISList)); } } catch (GatewayException gex) { ViewBag.ErrorMessage = gex.Message; return(RedirectToAction("TISCaptureList")); } catch (Exception ex) { ViewBag.ErrorMessage = ex.Message; return(RedirectToAction("TISCaptureList")); } } else { return(RedirectToAction("TISCaptureList")); } }
public ActionResult SearchNatisExports(string sidx, string sord, int page, int rows, string vehicleRegistration, string referenceNumber, long districtID) //DateTime exportDate { var tisService = new TISService(AuthenticatedUser.SessionToken); var filters = new List <FilterModel>(); if (!string.IsNullOrWhiteSpace(vehicleRegistration)) { filters.Add(new FilterModel { PropertyName = "VehicleRegistration", Operation = Operation.StartsWith, Value = vehicleRegistration }); } if (!string.IsNullOrWhiteSpace(referenceNumber)) { filters.Add(new FilterModel { PropertyName = "ReferenceNumber", Operation = Operation.StartsWith, Value = referenceNumber }); } if (!string.IsNullOrWhiteSpace(districtID.ToString())) { filters.Add(new FilterModel { PropertyName = "DistrictID", Operation = Operation.Equals, Value = districtID }); } //if (!string.IsNullOrWhiteSpace(exportDate.ToString())) // filters.Add(new FilterModel { PropertyName = "ExportDate", Operation = Operation.Contains, Value = exportDate }); var paginatedList = tisService.GetNatisExportPaginatedList(filters, FilterJoin.And, false, "InfringementDate", page, rows); var totalPages = Math.Ceiling((float)paginatedList.TotalCount / (float)rows); var jsonData = new { total = totalPages, page, records = paginatedList.TotalCount, rows = paginatedList.Models }; return(Json(jsonData, JsonRequestBehavior.AllowGet)); }
public ActionResult CaptureTISDetails(IList <TISDataModel> models) { var tisService = new TISService(AuthenticatedUser.SessionToken); if (!ModelState.IsValid) { return(View(models)); } try { tisService.CaptureTISData(models); return(RedirectToAction("TISCaptureList")); } catch (GatewayException ex) { ModelState.AddModelError(string.Empty, ex.Message); return(View(models)); } }