private bool SaveShipStoresToPortCall(List <FalShipStores> shipStores, int portCallId) { var portCall = _context.PortCall.Where(pc => pc.PortCallId == portCallId).FirstOrDefault(); if (portCall != null) { try { _context.FalShipStores.RemoveRange(_context.FalShipStores.Where(fss => fss.PortCallId == portCallId)); if (shipStores.Any()) { _context.FalShipStores.AddRange(shipStores); } _context.SaveChanges(); return(true); } catch (Exception ex) { return(false); } } return(false); }
public IActionResult Register([FromBody] PortCall portCall) { try { var clearanceAgencies = _context.Organization.Where(org => org.OrganizationTypeId == Constants.Integers.DatabaseTableIds.ORGANIZATION_TYPE_GOVERNMENT_AGENCY).ToList(); List <OrganizationPortCall> organizationPortCallList = new List <OrganizationPortCall>(); if (clearanceAgencies.Any()) { foreach (Organization agency in clearanceAgencies) { OrganizationPortCall opc = new OrganizationPortCall { OrganizationId = agency.OrganizationId, PortCallId = portCall.PortCallId }; organizationPortCallList.Add(opc); _context.OrganizationPortCall.Add(opc); } _context.SaveChanges(); return(Json(organizationPortCallList)); } else { return(BadRequest("Warning: clearance list for port call is empty: no authorities could be found")); } } catch (DbUpdateException ex) when(ex.InnerException is Npgsql.PostgresException) { Npgsql.PostgresException innerEx = (Npgsql.PostgresException)ex.InnerException; return(BadRequest("PostgreSQL Error Code: " + innerEx.SqlState)); } }
public IActionResult UpdateList([FromBody] List <IdentityDocument> identityDocumentList) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try{ if (!identityDocumentList.Any()) { _context.IdentityDocument.RemoveRange(_context.IdentityDocument.ToList()); } else { var removeList = _context.IdentityDocument.Where(i => !identityDocumentList.Any(identityDocumentEntity => identityDocumentEntity.IdentityDocumentId == i.IdentityDocumentId)); _context.IdentityDocument.RemoveRange(removeList); foreach (IdentityDocument identityDocumentEntity in identityDocumentList) { if (_context.IdentityDocument.Any(i => i.IdentityDocumentId == identityDocumentEntity.IdentityDocumentId)) { _context.IdentityDocument.Update(identityDocumentEntity); } else { _context.IdentityDocument.Add(identityDocumentEntity); } } } _context.SaveChanges(); return(Ok(true)); } catch (Exception e) { return(BadRequest(e)); } }
public IActionResult RemovePurposeForPortCall(int portCallId) { try { var removeList = _context.PortCallHasPortCallPurpose.Where(pcHasPurpose => pcHasPurpose.PortCallId == portCallId); _context.PortCallHasPortCallPurpose.RemoveRange(removeList); _context.SaveChanges(); return(Json("Purposes removed from port call with ID: " + portCallId)); } catch (DbUpdateException ex) when(ex.InnerException is Npgsql.PostgresException) { Npgsql.PostgresException innerEx = (Npgsql.PostgresException)ex.InnerException; return(BadRequest("PostgreSQL Error Code: " + innerEx.SqlState)); } }
public IActionResult SaveFalSecurity([FromBody] FalSecurity falSecurity) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { if (falSecurity.FalSecurityId > 0) { _context.ShipToShipActivity.RemoveRange(_context.ShipToShipActivity.Where(stsa => stsa.FalSecurityId == falSecurity.FalSecurityId)); _context.SecurityPreviousPortOfCall.RemoveRange(_context.SecurityPreviousPortOfCall.Where(pc => pc.FalSecurityId == falSecurity.FalSecurityId)); _context.FalSecurity.Update(falSecurity); } else { _context.FalSecurity.Add(falSecurity); } _context.SaveChanges(); return(Ok(falSecurity)); } catch (Exception e) { return(BadRequest(e)); } }
public IActionResult AddCertificateOfRegistry([FromBody] CertificateOfRegistry certificate) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { _context.CertificateOfRegistry.Add(certificate); _context.SaveChanges(); return(Ok()); } catch (Exception e) { return(BadRequest(e)); } }
public IActionResult Add([FromBody] PersonOnBoard personOnBoard) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { _context.PersonOnBoard.Add(personOnBoard); _context.SaveChanges(); return(Ok()); } catch (Exception e) { return(BadRequest(e)); } }
public IActionResult Add(MeasurementType measurementType) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { _context.MeasurementType.Add(measurementType); _context.SaveChanges(); return(Ok()); } catch (Exception e) { return(BadRequest(e)); } }
public IActionResult UpdateList([FromBody] List <FalShipStores> shipStoresList, int portCallId) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { _context.FalShipStores.RemoveRange(_context.FalShipStores.Where(st => st.PortCallId == portCallId)); _context.FalShipStores.AddRange(shipStoresList); _context.SaveChanges(); return(Json(shipStoresList)); } catch (Exception e) { return(BadRequest(e)); } }
public IActionResult Update([FromBody] PortCallDetails portCallDetails) { if (!ValidateDetails(portCallDetails)) { return(BadRequest("Invalid port call details from data.")); } try { _context.PortCallDetails.Update(portCallDetails); _context.SaveChanges(); } catch (DbUpdateException ex) when(ex.InnerException is Npgsql.PostgresException) { Npgsql.PostgresException innerEx = (Npgsql.PostgresException)ex.InnerException; return(BadRequest("PostgreSQL Error Code: " + innerEx.SqlState)); } return(Json(portCallDetails)); }
public IActionResult Add(CustomsCargo cargo) { if (cargo == null) { return(BadRequest("Empty request body.")); } _context.CustomsCargo.Add(cargo); _context.SaveChanges(); return(Ok(cargo)); }
public IActionResult SaveShipContactList([FromBody] List <ShipContact> shipContactList) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { var shipIdList = shipContactList.Select(sc => sc.ShipId).ToList(); var removeList = _context.ShipContact.Where(sc => shipContactList.Any(contactEntity => contactEntity.ShipId == sc.ShipId)); _context.ShipContact.RemoveRange(removeList); _context.ShipContact.AddRange(shipContactList); _context.SaveChanges(); return(Json(shipContactList)); } catch (Exception e) { return(BadRequest(e)); } }
public IActionResult Add(Dpg dpg) { if (dpg == null) { return(BadRequest("Empty body.")); } _context.Dpg.Add(dpg); _context.SaveChanges(); return(Ok(dpg)); }
public static void AddUnconnectedUsers(open_ssnContext context) { Password pw = new Password { Hash = "XXXXXXXX" }; User usr = new User { Email = "*****@*****.**", EmailConfirmed = true, NormalizedEmail = "*****@*****.**", Password = pw }; context.Set <User>().Add(usr); context.SaveChanges(); }
public IActionResult UpdateList([FromBody] List <DpgOnBoard> dpgOnBoardList, long portCallId) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { if (!dpgOnBoardList.Any()) { _context.DpgOnBoard.RemoveRange(_context.DpgOnBoard.Where(s => s.PortCallId == portCallId)); } else { var oldList = _context.DpgOnBoard.AsNoTracking().Where(s => s.PortCallId == portCallId).ToList(); var removeList = oldList.Where(dpg => !dpgOnBoardList.Any(dpgEntity => dpgEntity.DpgOnBoardId == dpg.DpgOnBoardId)).ToList(); _context.DpgOnBoard.RemoveRange(removeList); foreach (var dpgOnBoard in dpgOnBoardList) { if (_context.DpgOnBoard.Any(dpg => dpg.DpgOnBoardId == dpgOnBoard.DpgOnBoardId)) { _context.DpgOnBoard.Update(dpgOnBoard); } else { _context.DpgOnBoard.Add(dpgOnBoard); } } } _context.SaveChanges(); return(Ok(true)); } catch (Exception e) { return(BadRequest(e)); } }
public IActionResult SaveInternationalShipSecurityCertificate([FromBody] InternationalShipSecurityCertificate issc) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { if (issc.IsscId > 0) { _context.InternationalShipSecurityCertificate.Update(issc); } else { _context.InternationalShipSecurityCertificate.Add(issc); } _context.SaveChanges(); return(Ok(issc)); } catch (Exception e) { return(BadRequest(e)); } }
public IActionResult SaveCompanySecurityOfficer([FromBody] CompanySecurityOfficer cso) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { if (cso.CompanySecurityOfficerId > 0) { _context.CompanySecurityOfficer.Update(cso); } else { _context.CompanySecurityOfficer.Add(cso); } _context.SaveChanges(); return(Ok(cso)); } catch (Exception e) { return(BadRequest(e)); } }
private static void AddRoleData(open_ssnContext context) { var con = context as DbContext; ClaimType claimType = new ClaimType { Name = "Port Call", Description = "Claim type for claims related to port call." }; Role role = new Role { Name = "admin", NormalizedName = "ADMIN", Description = "Administrator role" }; context.ClaimType.Add(claimType); context.Role.Add(role); context.SaveChanges(); role = context.Set <Role>().SingleAsync(r => r.Name == "admin").GetAwaiter().GetResult(); claimType = con.Set <ClaimType>().SingleAsync(ct => ct.Name == "Port Call").GetAwaiter().GetResult(); List <Claim> claims = new List <Claim> { new Claim { ClaimType = claimType, ClaimValue = "View" }, new Claim { ClaimType = claimType, ClaimValue = "Edit" } }; List <RoleClaim> roleClaims = new List <RoleClaim>(); foreach (var claim in claims) { roleClaims.Add(new RoleClaim { Role = role, Claim = claim }); } role = context.Set <Role>().SingleAsync(r => r.Name == "admin").GetAwaiter().GetResult(); context.RoleClaim.AddRange(roleClaims); context.SaveChanges(); // Add new customs role role = new Role { Name = "customs", NormalizedName = "CUSTOMS", Description = "Customs role" }; context.Role.Add(role); context.SaveChanges(); // Make customs role have portcall view and clearance claims claims.RemoveAt(1); claims.Insert(1, new Claim { ClaimType = claimType, ClaimValue = "Clearance" }); roleClaims.Clear(); foreach (var claim in claims) { roleClaims.Add(new RoleClaim { Role = role, Claim = claim }); } context.RoleClaim.AddRange(roleClaims); context.SaveChanges(); }