public async Task <IActionResult> PutAltUnit(int id, AltUnit altUnit) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != altUnit.Id) { return(BadRequest()); } _context.Entry(altUnit).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!AltUnitExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public void AltUnitTest() { Layer target = new Layer(); AltUnit expected = AltUnit.Meters; target.AltUnit = expected; AltUnit actual = target.AltUnit; Assert.AreEqual(expected, actual); }
public bool CheckAltUnit(AltUnit altUnit) { var check = _context.altUnits.Where(p => p.Code == altUnit.Code).FirstOrDefault(); if (check == null) { return(false); } return(true); }
public override void WriteLayerProperties(System.Xml.XmlTextWriter xmlWriter) { xmlWriter.WriteAttributeString("TimeSeries", TimeSeries.ToString()); xmlWriter.WriteAttributeString("BeginRange", BeginRange.ToString()); xmlWriter.WriteAttributeString("EndRange", EndRange.ToString()); xmlWriter.WriteAttributeString("Decay", Decay.ToString()); xmlWriter.WriteAttributeString("CoordinatesType", CoordinatesType.ToString()); xmlWriter.WriteAttributeString("LatColumn", LatColumn.ToString()); xmlWriter.WriteAttributeString("LngColumn", LngColumn.ToString()); xmlWriter.WriteAttributeString("GeometryColumn", GeometryColumn.ToString()); xmlWriter.WriteAttributeString("AltType", AltType.ToString()); xmlWriter.WriteAttributeString("MarkerMix", MarkerMix.ToString()); xmlWriter.WriteAttributeString("ColorMap", ColorMap.ToString()); xmlWriter.WriteAttributeString("MarkerColumn", MarkerColumn.ToString()); xmlWriter.WriteAttributeString("ColorMapColumn", ColorMapColumn.ToString()); xmlWriter.WriteAttributeString("PlotType", PlotType.ToString()); xmlWriter.WriteAttributeString("MarkerIndex", MarkerIndex.ToString()); xmlWriter.WriteAttributeString("MarkerScale", MarkerScale.ToString()); xmlWriter.WriteAttributeString("AltUnit", AltUnit.ToString()); xmlWriter.WriteAttributeString("AltColumn", AltColumn.ToString()); xmlWriter.WriteAttributeString("StartDateColumn", StartDateColumn.ToString()); xmlWriter.WriteAttributeString("EndDateColumn", EndDateColumn.ToString()); xmlWriter.WriteAttributeString("SizeColumn", SizeColumn.ToString()); xmlWriter.WriteAttributeString("HyperlinkFormat", HyperlinkFormat.ToString()); xmlWriter.WriteAttributeString("HyperlinkColumn", HyperlinkColumn.ToString()); xmlWriter.WriteAttributeString("ScaleFactor", ScaleFactor.ToString()); xmlWriter.WriteAttributeString("PointScaleType", PointScaleType.ToString()); xmlWriter.WriteAttributeString("ShowFarSide", ShowFarSide.ToString()); xmlWriter.WriteAttributeString("RaUnits", RaUnits.ToString()); xmlWriter.WriteAttributeString("HoverTextColumn", NameColumn.ToString()); xmlWriter.WriteAttributeString("XAxisColumn", XAxisColumn.ToString()); xmlWriter.WriteAttributeString("XAxisReverse", XAxisReverse.ToString()); xmlWriter.WriteAttributeString("YAxisColumn", YAxisColumn.ToString()); xmlWriter.WriteAttributeString("YAxisReverse", YAxisReverse.ToString()); xmlWriter.WriteAttributeString("ZAxisColumn", ZAxisColumn.ToString()); xmlWriter.WriteAttributeString("ZAxisReverse", ZAxisReverse.ToString()); xmlWriter.WriteAttributeString("CartesianScale", CartesianScale.ToString()); xmlWriter.WriteAttributeString("CartesianCustomScale", CartesianCustomScale.ToString()); xmlWriter.WriteAttributeString("DynamicData", DynamicData.ToString()); xmlWriter.WriteAttributeString("AutoUpdate", AutoUpdate.ToString()); xmlWriter.WriteAttributeString("DataSourceUrl", DataSourceUrl.ToString()); }
public async Task <ActionResult <AltUnit> > PostAltUnit(AltUnit alt) { _context.altUnits.Add(alt); _context.Database.OpenConnection(); try { _context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT dbo.altUnits ON"); _context.SaveChanges(); _context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT dbo.altUnits OFF"); } finally { _context.Database.CloseConnection(); } await _context.SaveChangesAsync(); return(CreatedAtAction("GetAltUnit", new { id = alt.Id }, alt)); }
public IActionResult Get() { var query = from h in context.Lg00101Orfiche join y in context.Lg00101Orfline on h.Logicalref equals y.Ordficheref join r in context.Lg001Clcard on h.Clientref equals r.Logicalref join x in context.Lg001Items on y.Stockref equals x.Logicalref join q in context.Lg001Unitsetf on y.Usref equals q.Logicalref join z in context.Lg001Unitsetl on y.Uomref equals z.Logicalref join w in context.Lg001Specodes.Where(p => p.Spetyp1 == 1) on x.Specode equals w.Specode into ej from w in ej.DefaultIfEmpty() join e in context.Lg001Specodes.Where(p => p.Spetyp2 == 1) on x.Specode2 equals e.Specode into ed from e in ed.DefaultIfEmpty() join a in context.Lg001Specodes.Where(p => p.Spetyp3 == 1) on x.Specode3 equals a.Specode into ey from a in ey.DefaultIfEmpty() join b in context.Lg001Specodes.Where(p => p.Spetyp4 == 1) on x.Specode4 equals b.Specode into ek from b in ek.DefaultIfEmpty() join g in context.Lg001Specodes.Where(p => p.Spetyp5 == 1) on x.Specode5 equals g.Specode into eo from g in eo.DefaultIfEmpty() select new { Logicalref = h.Logicalref, Sipdetay = y.Logicalref, Main = new { MainCode = q.Code, MainName = q.Name, MainLogicalRef = q.Logicalref, MainCreatedTime = q.CapiblockCreadeddate, MainModifiedTime = q.CapiblockModifieddate }, Alt = new { AltCode = z.Code, AltName = z.Name, AltId = z.Logicalref, AltMainID = z.Unitsetref }, Item = new { ItemId = x.Logicalref, ItemCode = x.Code, ItemName = x.Name, ItemColor = w.Definition, ItemFloor = e.Definition, ItemPattern = a.Definition, ItemRope = b.Definition, ItemStrike = g.Definition, ItemCreatedTime = x.CapiblockCreadeddate, ItemModifiedTime = x.CapiblockModifieddate }, Client = new { ClientId = r.Logicalref, ClientName = r.Definition, ClientCode = r.Code }, Order = new { orderId = h.Logicalref, FicheNo = h.Ficheno, clientid = r.Logicalref }, Orderdetail = new { OrderId = h.Logicalref, amount = y.Amount, altunitId = z.Logicalref, itemId = x.Logicalref }, Ficheno = h.Ficheno, Date = h.Date, Time = h.Time, Stockref = y.Stockref, specode1 = w.Definition, specode2 = e.Definition, specode3 = a.Definition, specode4 = b.Definition, specode5 = g.Definition, Musteri = h.Clientref, musterino = r.Code, birim = y.Usref }; foreach (var item in query) { //client oluşturma ClientsController clientsController = new ClientsController(_context); Client client = new Client(); client.Name = item.Client.ClientName; client.ClientCode = item.Client.ClientCode; client.Id = item.Client.ClientId; clientsController.PostClient(client); //item oluşturma ItemsController itemsController = new ItemsController(_context); Item item1 = new Item(); item1.Id = item.Item.ItemId; item1.Code = item.Item.ItemCode; item1.Name = item.Item.ItemName; item1.Color = item.Item.ItemColor; item1.Floor = item.Item.ItemFloor; item1.Pattern = item.Item.ItemPattern; item1.Rope = item.Item.ItemRope; item1.Strike = item.Item.ItemStrike; item1.LogicCreatedDate = item.Item.ItemCreatedTime; item1.LogicModifiedDate = item.Item.ItemModifiedTime; itemsController.PostItem(item1); //mainunit MainUnitsController mainUnit = new MainUnitsController(_context); MainUnit main = new MainUnit(); main.Code = item.Main.MainCode.ToString(); main.Name = item.Main.MainName; main.Id = item.Main.MainLogicalRef; main.LogicCreatedDate = item.Main.MainCreatedTime; main.LogicModifiedDate = item.Main.MainModifiedTime; mainUnit.PostMainUnit(main); //altUnit AltUnitsController altUnit = new AltUnitsController(_context); AltUnit alt = new AltUnit(); alt.Id = item.Alt.AltId; alt.Code = item.Alt.AltCode; alt.Name = item.Alt.AltName; alt.MainUnitId = item.Alt.AltMainID; //altUnit.PostAltUnit(alt); altUnit.PostAltUnit(alt); //order OrdersController order1 = new OrdersController(_context); Order order = new Order(); order.Id = item.Order.orderId; order.FicheNo = item.Order.FicheNo; order.ClientId = item.Order.clientid; order.Statu = 0; order1.PostOrder(order); //orderdetail OrderDetailsController orderDetail = new OrderDetailsController(_context); OrderDetail orderd = new OrderDetail(); orderd.OrderId = item.Orderdetail.OrderId; orderd.Amount = item.Orderdetail.amount; orderd.AltUnitId = item.Orderdetail.altunitId; orderd.ItemId = item.Orderdetail.itemId; orderDetail.PostOrderDetail(orderd); } return(Ok(query)); }