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));
}
