public JsonResult AssignLocation() { string json = Request.InputStream.ReadToEnd(); AssignLocationModel inputData = JsonConvert.DeserializeObject <AssignLocationModel>(json); bool success = false; string error = ""; masterEntities entities = new masterEntities(); try { // haetaan ensin paikan id-numero koodin perusteella int locationId = (from l in entities.AssetLocations where l.Code == inputData.LocationCode select l.Id).FirstOrDefault(); // haetaan ensin laitteen id-numero koodin perusteella int AssetId = (from a in entities.Assets where a.Code == inputData.AssetCode select a.Id).FirstOrDefault(); if ((locationId > 0) && (AssetId > 0)) { // tallennetaan uusi rivi aikaleiman kanssa kantaan AssetLocation1 newEntry = new AssetLocation1(); newEntry.LocationId = locationId; newEntry.AssetId = AssetId; newEntry.LastSeen = DateTime.Now; entities.AssetLocations1.Add(newEntry); entities.SaveChanges(); success = true; } } catch (Exception ex) { error = ex.GetType().Name + ":" + ex.Message; } finally { entities.Dispose(); } // palautetaan Json-muotoinen tulos kutsujalle var result = new { success = success, error = error }; return(Json(result)); }
public JsonResult AssignLocation() //JsonResult=palauttaa Jsonia, AssignLocation=rutiinin nimi { string json = Request.InputStream.ReadToEnd(); //laajennusmetodi, WebUtilities.cs luokkaan AssignLocationModel inputData = JsonConvert.DeserializeObject <AssignLocationModel>(json); bool success = false; //oletetaan ettei onnistu string error = ""; Asset2Entities entities = new Asset2Entities(); try { // haetaan ensin paikan id-numero koodin perusteella int locationId = (from l in entities.AssetLocation where l.Code == inputData.LocationCode select l.Id).FirstOrDefault(); // haetaan laitteen id-numero koodin perusteella int assetId = (from a in entities.Assets where a.Code == inputData.AssetCode select a.Id).FirstOrDefault(); if ((locationId > 0) && (assetId > 0)) { // UUDEN RIVIN TALLENTAMINEN aikaleiman kanssa TIETOKANTAAN AssetLocations newEntry = new AssetLocations(); newEntry.LocationId = locationId; newEntry.AssetId = assetId; newEntry.LastSeen = DateTime.Now; entities.AssetLocations.Add(newEntry); entities.SaveChanges(); success = true; //muutetaan success=true } } catch (Exception ex) { error = ex.GetType().Name + ": " + ex.Message; } finally { entities.Dispose(); } // palautetaan JSON-muotoinen tulos kutsujalle var result = new { success = success, error = error }; return(Json(result)); }
public JsonResult AssignLocation() { string json = Request.InputStream.ReadToEnd(); AssignLocationModel inputData = JsonConvert.DeserializeObject <AssignLocationModel>(json); bool success = false; string error = ""; Entities entities = new Entities(); try { int locationId = (from l in entities.AssetLocation where l.Code == inputData.LocationCode select l.Id).FirstOrDefault(); int assetId = (from a in entities.Assets where a.Code == inputData.AssetCode select a.Id).FirstOrDefault(); if ((locationId > 0) && (assetId > 0)) { AssetsLocations newEntry = new AssetsLocations(); newEntry.LocationId = locationId; newEntry.AssetId = assetId; newEntry.LastSeen = DateTime.Now; entities.AssetLocations.Add(newEntry); entities.SaveChanges(); success = true; } } catch (Exception ex) { error = ex.GetType().Name + "; " + ex.Message; } finally { entities.Dispose(); } var result = new { success = success, error = error }; return(Json(result)); }
public JsonResult AssignLocation() { string json = Request.InputStream.ReadToEnd(); AssignLocationModel inputData = JsonConvert.DeserializeObject<AssignLocationModel>(json); AssetLocationsDatabaseEntities = new AssetLocationsDatabaseEntities(); try { int locationId=(from l in //tähän jäin } catch { } }