public ActionResult Delete(int id) { var sda = new ShipDataAccess(context); sda.Delete(sda.getById(id)); return(RedirectToAction("List")); }
public DataSet GetPositionsOnStandingOrder() { using (var sqlconn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["mio"].ConnectionString)) { sqlconn.Open(); var dsout = new DataSet(); var dt = new DataTable(); var pos = new SqlGeography(); ShipDataAccess sda = null; StandingOrderDataAccess soda = null; using (var da = new SqlDataAdapter("SELECT * FROM AIS", sqlconn)) { da.Fill(dt); } dt.Columns.Add("LATITUD", typeof(Decimal)); dt.Columns.Add("LONGITUD", typeof(Decimal)); foreach (DataRow row in dt.Rows) { try { sda = new ShipDataAccess(); soda = new StandingOrderDataAccess(); var spman = new ShipPositionManager(); var ddpman = new DDPVersionManager(); var ddpver = ddpman.GetCurrentDDPVersion(); var lastpos = spman.GetLastShipPosition(sda.getById((int)row["ID_BARCO"]).IMONum); List <StandingOrder> so = new List <StandingOrder>(); if (lastpos != null) { so = soda.GetOrdersForPosition(lastpos, ddpver); } if (so.Count == 0) { dt.Rows.Remove(row); continue; } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex); } finally { sda.Dispose(); soda.Dispose(); } pos = SqlGeography.STGeomFromWKB(new SqlBytes((byte[])row["Position"]), 4326); row["LATITUD"] = decimal.Parse(pos.Lat.ToString()); row["LONGITUD"] = decimal.Parse(pos.Long.ToString()); } dt.Columns.Remove("Position"); dsout.Tables.Add(dt); return(dsout); } }
public ActionResult Edit(int id) { var sda = new ShipDataAccess(context); ViewData["shipid"] = id; return(View("New", sda.getById(id))); }
public void SendReport(string requestor, ShipPosition position, string referenceId, DataCenterTypesIDE.responseTypeType responseType, DataCenterLogic.DataCenterTypesIDE.messageTypeType messageType) { //Configuracion del datacenter var configMgr = new ConfigurationManager(); //DataCenterTypesIDE.responseTypeType responseType = getResponseTypeFromRequest(spr); //DataCenterLogic.DataCenterTypesIDE.messageTypeType messageType = getMessageTypeFromRequest(spr); //Obtengo el ship al que pertenece la posicion using (var shipdao = new ShipDataAccess()) { Ship ship = shipdao.getById(position.ShipId); var shipPosReport = new DataCenterTypesIDE.ShipPositionReportType(); var point = SqlGeography.STPointFromWKB(new System.Data.SqlTypes.SqlBytes(position.Position.ToArray()), 4326); shipPosReport.ASPId = configMgr.Configuration.ASPId; shipPosReport.DataUserProvider = "1005"; //if( responseType == DataCenterLogic.DataCenterTypesIDE.responseTypeType.Item4 ) // shipPosReport.DataUserProvider = "3005"; shipPosReport.DataUserRequestor = requestor; shipPosReport.DCId = configMgr.Configuration.DataCenterID; shipPosReport.DDPVersionNum = DDPVersionManager.currentDDP(); shipPosReport.IMONum = ship.IMONum; shipPosReport.Latitude = WGS84LatFormat(point.Lat.Value); shipPosReport.Longitude = WGS84LongFormat(point.Long.Value); shipPosReport.MessageId = MessageIdManager.Generate(); shipPosReport.MessageType = messageType; shipPosReport.MMSINum = ship.MMSINum; shipPosReport.ReferenceId = referenceId; shipPosReport.ResponseType = responseType; shipPosReport.schemaVersion = decimal.Parse(configMgr.Configuration.SchemaVersion); shipPosReport.ShipborneEquipmentId = ship.EquipID; shipPosReport.ShipName = ship.Name; shipPosReport.test = DataCenterLogic.DataCenterTypesIDE.testType.Item1; shipPosReport.TimeStamp1 = position.TimeStamp; shipPosReport.TimeStamp2 = position.TimeStampInASP; shipPosReport.TimeStamp3 = position.TimeStampOutASP; shipPosReport.TimeStamp4 = position.TimeStampInDC; shipPosReport.TimeStamp5 = DateTime.UtcNow; log.Debug("Enqueing Report for ship: " + shipPosReport.IMONum + " Pos. Long. Lat.:" + shipPosReport.Longitude + " " + shipPosReport.Latitude + " Requestor: " + shipPosReport.DataUserRequestor); QueueManager.Instance().EnqueueOut(shipPosReport, "shipPositionReport"); } }