// POST: api/DeskStatsLoc public void Post(Models.DeskStats.ModelDeskStatsLoc dd1) { if (dd1.CPUName != null) { Models.DeskStats.DeskStatsLocTableAdapters.DeskStatsLocationsTableAdapter tb = new Models.DeskStats.DeskStatsLocTableAdapters.DeskStatsLocationsTableAdapter(); Models.DeskStats.DeskStatsLoc.LocationsDataTable tb1 = new Models.DeskStats.DeskStatsLoc.LocationsDataTable(); tb.FillBy(tb1, dd1.CPUName); if (tb1.Count > 0) { tb.UpdateQuery(dd1.Location, dd1.CPUName); } else { tb.InsertQuery(dd1.Location, dd1.CPUName); } } }
public string Get(string id) { Models.DeskStats.DeskStatsLocTableAdapters.DeskStatsLocationsTableAdapter tb = new Models.DeskStats.DeskStatsLocTableAdapters.DeskStatsLocationsTableAdapter(); Models.DeskStats.DeskStatsLoc.LocationsDataTable tb1 = new Models.DeskStats.DeskStatsLoc.LocationsDataTable(); tb.FillBy(tb1, id); if (tb1.Count > 0) { string name = ""; foreach(DeskStatsLoc.LocationsRow row1 in tb1) { name= row1.Name; } return name; //return String.Join(Environment.NewLine, tb1.Rows.OfType<DataRow>().Select(x => String.Join(" ; ", x.ItemArray))); } else { return "NotFound"; } }