public ActionResult DeleteVessel(long id) { var gVal = new GenericValidator(); try { if (id < 1) { gVal.Code = -1; gVal.Error = "Invalid selection"; return(Json(gVal, JsonRequestBehavior.AllowGet)); } var delStatus = new VesselServices().DeleteVessel(id); if (delStatus < 1) { gVal.Code = -1; gVal.Error = "Vessel could not be deleted. Please try again later."; return(Json(gVal, JsonRequestBehavior.AllowGet)); } gVal.Code = 5; gVal.Error = "Vessel Information was successfully deleted"; return(Json(gVal, JsonRequestBehavior.AllowGet)); } catch (Exception) { return(Json(gVal, JsonRequestBehavior.AllowGet)); } }
public ActionResult VesselsToOffer(int company, int project, int offer) { VesselServices serv = new VesselServices(); var vessels = serv.VesselAvailableProject(company, project, offer); return(Json(vessels, JsonRequestBehavior.AllowGet)); }
public ActionResult AddVessel(VesselObject vessel) { var gVal = new GenericValidator(); try { var validationResult = ValidateVessel(vessel); if (validationResult.Code == 1) { return(Json(validationResult, JsonRequestBehavior.AllowGet)); } vessel.DateAdded = DateTime.Today; var appStatus = new VesselServices().AddVessel(vessel); if (appStatus < 1) { validationResult.Code = -1; validationResult.Error = appStatus == -2 ? "Vessel processing failed. Please try again." : "Vessel Information already exists"; return(Json(validationResult, JsonRequestBehavior.AllowGet)); } gVal.Code = appStatus; gVal.Error = "Vessel was successfully added."; return(Json(gVal, JsonRequestBehavior.AllowGet)); } catch (Exception) { gVal.Error = "Vessel processing failed. Please try again later"; gVal.Code = -1; return(Json(gVal, JsonRequestBehavior.AllowGet)); } }
public bool HasProjectsVesselsCompany(CompanyModel model) { ProjectServices pSrv = new ProjectServices(); var project = pSrv.GetProjectCollection(new ProjectModel() { CompanyId = (int)model.CompanyId }, new PagerModel(0, 1, "", "")).Data.FirstOrDefault(); if (project != null) { return(true); } VesselServices vSrv = new VesselServices(); var vessel = vSrv.GetFirst(new VesselModel() { Company = new CompanyModel() { CompanyId = model.CompanyId } }); if (vessel != null) { return(true); } return(false); }
public ActionResult EditVessel(VesselObject vessel) { var gVal = new GenericValidator(); try { var stat = ValidateVessel(vessel); if (stat.Code < 1) { return(Json(gVal, JsonRequestBehavior.AllowGet)); } if (Session["_vessel"] == null) { gVal.Code = -1; gVal.Error = "Session has timed out."; return(Json(gVal, JsonRequestBehavior.AllowGet)); } var oldvessel = Session["_vessel"] as VesselObject; if (oldvessel == null) { gVal.Code = -1; gVal.Error = "Session has timed out."; return(Json(gVal, JsonRequestBehavior.AllowGet)); } oldvessel.Name = vessel.Name.Trim(); oldvessel.Capacity = vessel.Capacity; oldvessel.IssueDate = vessel.IssueDate; oldvessel.ExpiryDate = vessel.ExpiryDate; oldvessel.VesselLicense = vessel.VesselLicense; oldvessel.CompanyName = vessel.CompanyName; var docStatus = new VesselServices().UpdateVessel(oldvessel); if (docStatus < 1) { gVal.Code = -1; gVal.Error = docStatus == -3 ? "Vessel already exists." : "Vessel information could not be updated. Please try again later"; return(Json(gVal, JsonRequestBehavior.AllowGet)); } gVal.Code = oldvessel.VesselId; gVal.Error = "Vessel information was successfully updated"; return(Json(gVal, JsonRequestBehavior.AllowGet)); } catch (Exception) { gVal.Code = -1; gVal.Error = "Vessel information could not be updated. Please try again later"; return(Json(gVal, JsonRequestBehavior.AllowGet)); } }
public ActionResult Transaction(string id, VesselViewModel dataVW) { VesselModel data = dataVW.Vessel; RequestResult <VesselModel> result = new RequestResult <VesselModel>() { Status = Status.Success, Data = data }; VesselServices vesselServices = new VesselServices(); try { if (!ModelState.IsValid) { result = new RequestResult <VesselModel>() { Status = Status.Error, Message = localResource.ErrorOnSave } } ; else { if (id == "add") { if (Request.Files.Count > 0) { var File = Request.Files[0]; data.Image.FileName = File.FileName; data.Image.ContentType = File.ContentType; data.Image.FileContent = File.InputStream; } data.UserModifiedId = SessionWeb.User.UserId; result = vesselServices.InsUpdComplete( dataVW.Vessel, dataVW.VesselSpecificInfo, dataVW.SpecificInfo, dataVW.VesselCost); result.Data.Image.FileContent = null; if (result.Status != Status.Success) { throw new Exception(string.Format("{0}: {1}", globalResources.SomethingWrong, result.Message)); } return(Json(result)); } } } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); Response.StatusCode = (int)HttpStatusCode.BadRequest; Response.StatusDescription = ex.Message; return(Json(ex.Message, JsonRequestBehavior.AllowGet)); } return(Json(result)); }
public ActionResult Vessels(int?companId) { var company = companId == null ? new CompanyModel() : new CompanyModel() { CompanyId = UserCompanyId }; VesselServices regSrv = new VesselServices(); return(Json(regSrv.Get(new VesselModel() { Company = company }))); }
public ActionResult Edit(int Id) { CountryServices countryServices = new CountryServices(); ProjectTypeServices projectTypeServices = new ProjectTypeServices(); ClasificationSocietyServices clasificationSocietyServices = new ClasificationSocietyServices(); PortServices portServices = new PortServices(); RegionServices regionServices = new RegionServices(); VesselTypeServices vesselTypeServices = new VesselTypeServices(); VesselServices vesselServices = new VesselServices(); VesselViewModel model = new VesselViewModel(); //Desencriptamos y validamos permisos y existencia VesselModel vessel = vesselServices.GetFirst(new VesselModel() { VesselId = Id }); if (vessel == null || vessel.Company.CompanyId != SessionWeb.User.CompanyId) { return(RedirectToAction("Unauthorized", "Redirect")); } model.Vessel = vessel; model.VesselSpecificInfo = vesselServices.GetSpecificInfo(Id); model.SpecificInfo = vesselServices.GetSpecificInfoExtra(Id); model.VesselCost = vesselServices.GetCost(Id); ViewBag.LstCountry = countryServices.GetSelect(globalResources.Select).Select(x => new SelectListItem { Value = x.Value, Text = x.Text }); ViewBag.LstProjectType = projectTypeServices.GetSelect(null).Select(x => new SelectListItem { Value = x.Value, Text = x.Text }); ViewBag.LstVesselType = vesselTypeServices.GetSelect(globalResources.Select).Select(x => new SelectListItem { Value = x.Value, Text = x.Text }); ViewBag.LstClasificationSociety = clasificationSocietyServices.GetSelect(globalResources.Select).Select(x => new SelectListItem { Value = x.Value, Text = x.Text }); ViewBag.LstPort = portServices.GetSelect(globalResources.Select).Select(x => new SelectListItem { Value = x.Value, Text = x.Text }); ViewBag.LstRegion = regionServices.GetSelect(globalResources.Select).Select(x => new SelectListItem { Value = x.Value, Text = x.Text }); return(View("Create", model)); }
public ActionResult Valid(string id, VesselModel data) { RequestResult <string> result; VesselServices vesselServices = new VesselServices(); result = vesselServices.Eval(data); if (result.Status == Status.Warning) { Response.StatusCode = (int)HttpStatusCode.BadRequest; Response.StatusDescription = result.Message; } return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult GetVesselObjects(JQueryDataTableParamModel param) { try { IEnumerable <VesselObject> filteredParentMenuObjects; var countG = 0; var pagedParentMenuObjects = GetVessels(param.iDisplayLength, param.iDisplayStart, out countG); if (!string.IsNullOrEmpty(param.sSearch)) { filteredParentMenuObjects = new VesselServices().Search(param.sSearch); countG = filteredParentMenuObjects.Count(); } else { filteredParentMenuObjects = pagedParentMenuObjects; } if (!filteredParentMenuObjects.Any()) { return(Json(new List <VesselObject>(), JsonRequestBehavior.AllowGet)); } var sortColumnIndex = Convert.ToInt32(Request["iSortCol_0"]); Func <VesselObject, string> orderingFunction = (c => sortColumnIndex == 1 ? c.CompanyName : sortColumnIndex == 2 ? c.Name : c.CapacityStr); var sortDirection = Request["sSortDir_0"]; // asc or desc filteredParentMenuObjects = sortDirection == "desc" ? filteredParentMenuObjects.OrderBy(orderingFunction) : filteredParentMenuObjects.OrderByDescending(orderingFunction); var displayedPersonnels = filteredParentMenuObjects; var result = from c in displayedPersonnels select new[] { Convert.ToString(c.VesselId), c.CompanyName, c.Name, c.CapacityStr }; return(Json(new { param.sEcho, iTotalRecords = countG, iTotalDisplayRecords = countG, aaData = result }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { ErrorLogger.LoggError(ex.StackTrace, ex.Source, ex.Message); return(Json(new List <VesselObject>(), JsonRequestBehavior.AllowGet)); } }
public JsonResult List(DatatableModel dt, VesselModel filters) { VesselServices services = new VesselServices(); PagerModel pager = dt.ToPager(); filters.Company.CompanyId = SessionWeb.User.CompanyId; var collection = services.Get(pager, filters); return(Json(new { status = UI.Status.Success, sEcho = dt.sEcho, iTotalRecords = pager.TotalRecords, iTotalDisplayRecords = pager.TotalRecords, aaData = collection }, JsonRequestBehavior.AllowGet)); }
public ActionResult Manage(int Id) { VesselServices services = new VesselServices(); ReasonAvailabilityServices reasonServices = new ReasonAvailabilityServices(); ViewBag.LstReason = reasonServices.GetSelect(globalResources.Select).Select(x => new SelectListItem { Value = x.Value, Text = x.Text }); ViewBag.LstEstatus = services.GetEstatus(); VesselModel vessel = services.GetFirst(new VesselModel() { VesselId = Id }); return(View(new VesselAvailabilityViewModel() { VesselId = Id, VesselEstatusId = (int)vessel.Status })); }
public ActionResult GetVessel(long id) { try { var vessel = new VesselServices().GetVessel(id); if (vessel == null || vessel.VesselId < 1) { return(Json(new VesselObject(), JsonRequestBehavior.AllowGet)); } Session["_vessel"] = vessel; return(Json(vessel, JsonRequestBehavior.AllowGet)); } catch (Exception) { return(Json(new VesselObject(), JsonRequestBehavior.AllowGet)); } }
public ActionResult AvailabilityTransaction(string id, VesselAvailabilityViewModel data) { RequestResult <VesselAvailabilityModel> result = new RequestResult <VesselAvailabilityModel>() { Status = Status.Success, Data = data }; VesselAvailabilityServices availabilityServices = new VesselAvailabilityServices(); VesselServices services = new VesselServices(); try { if (id.ToLower() == "add") { if (!ModelState.IsValid) { result = new RequestResult <VesselAvailabilityModel>() { Status = Status.Error, Message = localResource.ErrorOnSave } } ; else { result = availabilityServices.InsUpd(data); if (result.Status != Status.Success) { throw new Exception(string.Format("{0}: {1}", globalResources.SomethingWrong, result.Message)); } return(Json(result)); } } else if (id.ToLower() == "del") { result = availabilityServices.Del((int)data.AvailabilityVesselId); if (result.Status != Status.Success) { throw new Exception(string.Format("{0}: {1}", globalResources.SomethingWrong, result.Message)); } return(Json(result)); } else if (id.ToLower() == "status") { RequestResult <VesselModel> resultV = new RequestResult <VesselModel>() { Status = Status.Success, Data = data.ToVesselModel() }; resultV = services.InsUpd(data.ToVesselModel()); if (result.Status != Status.Success) { throw new Exception(string.Format("{0}: {1}", globalResources.SomethingWrong, result.Message)); } return(Json(result)); } } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); Response.StatusCode = (int)HttpStatusCode.BadRequest; Response.StatusDescription = ex.Message; return(Json(ex.Message, JsonRequestBehavior.AllowGet)); } return(Json(result)); }
public ActionResult BulkUpload(HttpPostedFileBase file) { var gVal = new GenericValidator(); try { if (file.ContentLength > 0) { const string folderPath = "~/BulkUploads"; var fileName = file.FileName; var path = Server.MapPath(folderPath + "/" + fileName); if (System.IO.File.Exists(path)) { System.IO.File.Delete(path); } file.SaveAs(path); var msg = string.Empty; var errorList = new List <long>(); var vesselLicenses = new List <VesselObject>(); var successfulUploads = ReadExcelData(path, "Vessels", ref errorList, ref msg, ref vesselLicenses); if (!successfulUploads.Any()) { gVal.Code = -1; gVal.Error = msg; return(Json(gVal, JsonRequestBehavior.AllowGet)); } if (errorList.Any() && successfulUploads.Any()) { var feedbackMessage = successfulUploads.Count + " records were successfully uploaded." + "\n" + errorList.Count + " record(s) could not be uploaded due to specified/unspecified errors."; if (msg.Length > 0) { feedbackMessage += "<br/>" + msg; } gVal.Code = -1; gVal.Error = feedbackMessage; return(Json(gVal, JsonRequestBehavior.AllowGet)); } var saveCount = new VesselServices().AddVessel(vesselLicenses); if (saveCount != vesselLicenses.Count) { var feedbackMessage = saveCount + " records were successfully uploaded." + "\n" + (vesselLicenses.Count - saveCount) + " record(s) could not be uploaded due to specified/unspecified errors."; if (msg.Length > 0) { feedbackMessage += "<br/>" + msg; } gVal.Code = -1; gVal.Error = feedbackMessage; return(Json(gVal, JsonRequestBehavior.AllowGet)); } if (errorList.Any() && !successfulUploads.Any()) { var feedbackMessage = errorList.Count + " record(s) could not be uploaded due to specified/unspecified errors."; ViewBag.ErrorCode = -1; if (msg.Length > 0) { feedbackMessage += "<br/>" + msg; } gVal.Code = -1; gVal.Error = feedbackMessage; return(Json(gVal, JsonRequestBehavior.AllowGet)); } if (!errorList.Any() && successfulUploads.Any()) { var feedbackMessage = successfulUploads.Count + " records were successfully uploaded."; if (msg.Length > 0) { feedbackMessage += "<br/>" + msg; } gVal.Code = 5; gVal.Error = feedbackMessage; return(Json(gVal, JsonRequestBehavior.AllowGet)); } } gVal.Code = -1; gVal.Error = "The selected file is invalid"; return(Json(gVal, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { ErrorLogger.LoggError(ex.StackTrace, ex.Source, ex.Message); gVal.Code = -1; gVal.Error = "File processing failed."; return(Json(gVal, JsonRequestBehavior.AllowGet)); } }