public ActionResult DeletePort(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 PortServices().DeletePort(id);
if (delStatus < 1)
{
gVal.Code = -1;
gVal.Error = "Port could not be deleted. Please try again later.";
return(Json(gVal, JsonRequestBehavior.AllowGet));
}
gVal.Code = 5;
gVal.Error = "Port Information was successfully deleted";
return(Json(gVal, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
return(Json(gVal, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Create()
{
CountryServices countryServices = new CountryServices();
ProjectTypeServices projectTypeServices = new ProjectTypeServices();
ClasificationSocietyServices clasificationSocietyServices = new ClasificationSocietyServices();
PortServices portServices = new PortServices();
RegionServices regionServices = new RegionServices();
VesselTypeServices vesselTypeServices = new VesselTypeServices();
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(new VesselViewModel()));
}
public ActionResult EditPort(PortObject port)
{
var gVal = new GenericValidator();
try
{
var stat = ValidatePort(port);
if (stat.Code < 1)
{
return(Json(gVal, JsonRequestBehavior.AllowGet));
}
if (Session["_port"] == null)
{
gVal.Code = -1;
gVal.Error = "Session has timed out.";
return(Json(gVal, JsonRequestBehavior.AllowGet));
}
var oldport = Session["_port"] as PortObject;
if (oldport == null)
{
gVal.Code = -1;
gVal.Error = "Session has timed out.";
return(Json(gVal, JsonRequestBehavior.AllowGet));
}
oldport.Name = port.Name;
oldport.CountryId = port.CountryId;
var docStatus = new PortServices().UpdatePort(oldport);
if (docStatus < 1)
{
gVal.Code = -1;
gVal.Error = docStatus == -3 ? "Port already exists." : "Port information could not be updated. Please try again later";
return(Json(gVal, JsonRequestBehavior.AllowGet));
}
gVal.Code = oldport.Id;
gVal.Error = "Port information was successfully updated";
return(Json(gVal, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
gVal.Code = -1;
gVal.Error = "Port information could not be updated. Please try again later";
return(Json(gVal, JsonRequestBehavior.AllowGet));
}
}
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 GetPortObjects(JQueryDataTableParamModel param)
{
try
{
IEnumerable <PortObject> filteredParentMenuObjects;
var countG = 0;
var pagedParentMenuObjects = GetPorts(param.iDisplayLength, param.iDisplayStart, out countG);
if (!string.IsNullOrEmpty(param.sSearch))
{
filteredParentMenuObjects = new PortServices().Search(param.sSearch);
}
else
{
filteredParentMenuObjects = pagedParentMenuObjects;
}
if (!filteredParentMenuObjects.Any())
{
return(Json(new List <PortObject>(), JsonRequestBehavior.AllowGet));
}
var sortColumnIndex = Convert.ToInt32(Request["iSortCol_0"]);
Func <PortObject, string> orderingFunction = (c => sortColumnIndex == 1 ? c.Name : c.CountryName);
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.Id), c.Name, c.CountryName };
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 <PortObject>(), JsonRequestBehavior.AllowGet));
}
}
public List <PortObject> GetPorts()
{
try
{
var port = new PortServices().GetPorts();
Session["_port"] = port;
return(new List <PortObject>());
}
catch (Exception)
{
return(new List <PortObject>());
}
}
public ActionResult GetPort(long id)
{
try
{
var port = new PortServices().GetPort(id);
if (port == null || port.Id < 1)
{
return(Json(new PortObject(), JsonRequestBehavior.AllowGet));
}
Session["_port"] = port;
return(Json(port, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
return(Json(new PortObject(), JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddPort(PortObject port)
{
var gVal = new GenericValidator();
try
{
var importerInfo = GetLoggedOnUserInfo();
if (importerInfo.Id < 1)
{
gVal.Error = "Your session has timed out";
gVal.Code = -1;
return(Json(gVal, JsonRequestBehavior.AllowGet));
}
var validationResult = ValidatePort(port);
if (validationResult.Code == 1)
{
return(Json(validationResult, JsonRequestBehavior.AllowGet));
}
var appStatus = new PortServices().AddPort(port);
if (appStatus < 1)
{
validationResult.Code = -1;
validationResult.Error = appStatus == -2 ? "Port upload failed. Please try again." : "The Port Information already exists";
return(Json(validationResult, JsonRequestBehavior.AllowGet));
}
gVal.Code = appStatus;
gVal.Error = "Port was successfully added.";
return(Json(gVal, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
gVal.Error = "Port processing failed. Please try again later";
gVal.Code = -1;
return(Json(gVal, JsonRequestBehavior.AllowGet));
}
}
public RequestResult <VesselModel> InsUpdComplete(VesselModel vessel,
VesselSpecificInfoModel vesselSpecificInfo,
SpecificInformationModel specificInfo,
VesselCostModel vesselCost)
{
RequestResult <VesselModel> resp = new RequestResult <VesselModel>()
{
Status = Status.Success
};
SpecificInformationServices specificInfoServices = new SpecificInformationServices();
CabinSpecificationServices cabinSpecificationServices = new CabinSpecificationServices();
RegionServices regionServices = new RegionServices();
PortServices portServices = new PortServices();
TransactionOptions scopeOptions = new TransactionOptions();
//scopeOptions.IsolationLevel = IsolationLevel.ReadCommitted;
using (TransactionScope ts = new TransactionScope(TransactionScopeOption.Required, scopeOptions))
{
try
{
//Ciclo para ir a buscar diferentes puntos en el mapa, en caso de que el q se me asigne de forma aleatoria, se encuentre ya en BD
int valLocation = 2;
int test = 1;
int cont = 0;
while (valLocation > test && cont <= 100)
{
//Si se va a insertar, le agregamos un punto en el mapa
if (vessel.VesselId == null)
{
test = 0;
PortModel port = portServices.GetById((int)vessel.HomePort.PortId);
vessel.Location = regionServices.GetLocation(port.Region.RegionId);
}
else //De lo contrario verificamos si ha cambiado su puerto, si cambió le asignamos una nueva locación
{
test = 1;
int?RegionIdAct = portServices.GetById((int)vessel.HomePort.PortId).Region.RegionId;
int?RegionIdAnt = GetById((int)vessel.VesselId).HomePort.Region.RegionId;
if (RegionIdAnt != RegionIdAct)
{
vessel.Location = regionServices.GetLocation(RegionIdAct);
}
}
//Verificamos si existe otro Barco en el mismo punto
if (vessel.Location.Lat == 0)
{
test = valLocation;
}
else
{
valLocation =
Get(new VesselModel()
{
Location = new LatLng()
{
Lat = vessel.Location.Lat,
Lng = vessel.Location.Lng
}
}).Count();
}
cont++;
}
if (cont == 100)
{
throw new Exception("Se ha alcanzado el número de barcos permitidos para una región");
}
RequestResult <VesselModel> res1 = InsUpd(vessel);
if (res1.Status != Status.Success)
{
throw new Exception(res1.Message);
}
vesselSpecificInfo.VesselId = res1.Data.VesselId;
vesselSpecificInfo.UserModifiedId = vessel.UserModifiedId;
RequestResult <VesselSpecificInfoModel> res2 = InsUpdSpecificInfo(vesselSpecificInfo);
if (res2.Status != Status.Success)
{
throw new Exception(res2.Message);
}
specificInfo.MatchableId = res1.Data.VesselId;
specificInfo.Type = SpecificInformationModel.VESSEL_TYPE;
RequestResult <SpecificInformationModel> res3 = specificInfoServices.InsUpd(specificInfo);
if (res3.Status != Status.Success)
{
throw new Exception(res3.Message);
}
List <CabinSpecificationModel> lstCabins = specificInfo.GetCabinSpecificationList(CabinSpecificationModel.VESSEL_TYPE);
RequestResult <CabinSpecificationModel> respC;
foreach (CabinSpecificationModel cabin in lstCabins)
{
respC = cabinSpecificationServices.InsUpd(cabin);
if (respC.Status != Status.Success)
{
throw new Exception(respC.Message);
}
}
vesselCost.VesselId = res1.Data.VesselId;
RequestResult <VesselCostModel> res4 = InsUpdCost(vesselCost);
if (res4.Status != Status.Success)
{
throw new Exception(res4.Message);
}
resp = res1;
ts.Complete();
}
catch (Exception ex)
{
resp.Status = Status.Error;
resp.Message = ex.Message;
ts.Dispose();
throw new Exception(ex.Message);
}
}
return(resp);
}
public PortController()
{
_portServices = new PortServices();
}
