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
{
}
}
