protected void Page_Load(object sender, EventArgs e)
{
//If contains a room id and a facility id we are creating the asset.
if (Page.RouteData.Values["room_id"] != null && Page.RouteData.Values["facility_id"] != null)
{
facility_id = Convert.ToInt32(Page.RouteData.Values["facility_id"]);
room_id = Convert.ToInt32(Page.RouteData.Values["room_id"]);
}
//If asset id is not null we are editing an asset.
else if (Page.RouteData.Values["asset_id"] != null)
{
asset_id = Convert.ToInt32(Page.RouteData.Values["asset_id"]);
selected_asset = (from a in db.assets
where a.id == asset_id
select a).Single();
facility_id = selected_asset.facility_id;
room_id = selected_asset.room_id;
if (!Page.IsPostBack)
{
AssetName.Text = selected_asset.name;
AssetSku.Text = selected_asset.sku;
}
}
}
protected void submitAsset(Object sender, EventArgs e)
{
//If selected asset is null then creating a new asset.
if (selected_asset == null)
{
selected_asset = new asset();
selected_asset.facility_id = facility_id;
selected_asset.room_id = room_id;
selected_asset.name = AssetName.Text;
selected_asset.last_scan = DateTime.Now;
selected_asset.add_date = DateTime.Now;
selected_asset.sku = AssetSku.Text;
db.assets.InsertOnSubmit(selected_asset);
db.SubmitChanges();
}
//If not null then simply updating the name and sku
else
{
selected_asset.name = AssetName.Text;
selected_asset.sku = AssetSku.Text;
db.SubmitChanges();
}
Response.RedirectToRoute("ViewRoom", new { facility_id = facility_id, room_id = room_id });
}
public static AssetModel GetAssetModel(int dossierId, int assetId = 0)
{
PersonalFinancesDBEntities db = new PersonalFinancesDBEntities();
var asset = new AssetModel();
asset.assetId = assetId;
asset.subcategories = GetCategories(dossierId);
if (assetId != 0)
{
//existing record
asset assetDTO = db.assets.Find(assetId);
asset.dossierId = dossierId;
asset.receivable = decimal.Round(assetDTO.receivable, 2, MidpointRounding.AwayFromZero).ToString();;
asset.payable = decimal.Round(assetDTO.payable, 2, MidpointRounding.AwayFromZero).ToString();;
asset.isAsset = (assetDTO.receivable >= assetDTO.payable);
asset.description = assetDTO.description;
asset.assetSubcategoryId = assetDTO.assetSubcategoryId;
}
else
{
//new record
asset.dossierId = dossierId;
asset.receivable = "0,00";
asset.payable = "0,00";
asset.description = "";
asset.assetSubcategoryId = 0;
}
return(asset);
}
// update aaudit
internal static int updateAaudit(AWF myAWF, string actionString, string eventId, int itemSequence, RBA_Variables variables)
{
asset myAsset = getAsset(myAWF, itemSequence, variables);
switch (getProductType(myAWF, itemSequence, variables))
{
case productType.Static:
AWF_DB_Log.insertAauditRecordInDb(myAsset.Id, eventId, string.Format("{0}: {1} | Job Number: {2}", actionString, myAWF.Products.Item[itemSequence].ItemCode, myAWF.JobNumber.ToString()));
break;
case productType.Variable:
AWF_DB_Log.insertAauditRecordInDb(myAsset.Id, eventId, string.Format("{0}: {1}", actionString, myAsset.Name));
break;
}
string sql = "UPDATE asset "
+ "SET tlc=(SELECT DISTINCT tc "
+ "FROM aaudit WHERE id = :asset_id "
+ "AND seq = (SELECT DISTINCT MAX(seq) "
+ "FROM aaudit WHERE id = :asset_id ) LIMIT 1) "
+ (actionString.Contains("DESTROY/CANCEL") ? ", status = 3" : String.Empty)
+ "WHERE id = :asset_id; ";
string[] parameterNames = { "asset_id" };
string[] parameterVals = { myAsset.Id };
return(AWFPostgresDataLayer.ExecuteNonQuery(sql, parameterNames, parameterVals));
}
public ActionResult DeleteConfirmed(int id)
{
asset asset = db.assets.Find(id);
db.assets.Remove(asset);
db.SaveChanges();
TempData["Info"] = "Asset deleted succesfully";
return(RedirectToAction("Index"));
}
//
// GET: /Asset/Edit/5
public ActionResult Edit(int id = 0)
{
asset asset = db.assets.Find(id);
if (asset == null)
{
return(HttpNotFound());
}
return(View(asset));
}
public int Create()
{
asset assetToCreate = new asset();
assetToCreate = UpdateFields(assetToCreate);
db.assets.Add(assetToCreate);
db.SaveChanges();
return(assetToCreate.assetId);
}
public bool UpdateAsset(asset OurAsset)
{
int rowsAffected = this._db.Execute(@"UPDATE [Asset] SET [Name] = @Name, [Role] = @Role,[RegistrationDate] = @RegistrationDate, [Email] = @Email,
[Password] = @Password WHERE ID = " + OurAsset.ID, OurAsset);
if (rowsAffected > 0)
{
return(true);
}
return(false);
}
// GET api/Asset/5
public assetDTO Getasset(int id)
{
asset asset = db.assets.Single(a => a.id == id);
if (asset == null)
{
throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.NotFound));
}
return(asset.toDTO());
}
public bool InsertAsset(asset OurAsset)
{
int rowsAffected = this._db.Execute("INSERT Asset([Name],[Role],[RegistrationDate],[Email],[Password]) VALUES(@Name, @Role,@RegistrationDate, @Email, @Password)",
new { Name = OurAsset.Name, Role = OurAsset.Role, RegistrationDate = OurAsset.RegistrationDate, Email = OurAsset.Email, Password = OurAsset.Password });
if (rowsAffected > 0)
{
return(true);
}
return(false);
}
public ActionResult Edit(asset asset)
{
if (ModelState.IsValid)
{
db.Entry(asset).State = EntityState.Modified;
db.SaveChanges();
TempData["Success"] = "Asset edited successfully";
return(RedirectToAction("Index"));
}
return(View(asset));
}
public ActionResult Create(asset asset)
{
if (ModelState.IsValid)
{
asset.locked = 0;
db.assets.Add(asset);
db.SaveChanges();
TempData["Success"] = "Asset created succesfully";
return(RedirectToAction("Index"));
}
return(View(asset));
}
private asset UpdateFields(asset assetToUpdate)
{
assetToUpdate.dossierId = this.dossierId;
assetToUpdate.payable = decimal.Parse(this.payable);
assetToUpdate.receivable = decimal.Parse(this.receivable);
bool isAsset = (assetToUpdate.receivable > assetToUpdate.payable);
assetToUpdate.assetSubcategoryId = this.assetSubcategoryId;
assetToUpdate.description = (this.description == null) ? "" : this.description;
return(assetToUpdate);
}
public bool NewAssetToDb(AssetModel a)
{
var newAsset = new asset {
assetName = a.Name, assetPrice = a.Price, assetDescription = a.Description
};
//newAsset.Id = a.id;
_db.assets.InsertOnSubmit(newAsset);
_db.SubmitChanges();
return(true);
}
// GET: Asset/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
asset asset = db.assets.Find(id);
if (asset == null)
{
return(HttpNotFound());
}
return(View(asset));
}
// POST api/Asset
public HttpResponseMessage Postasset(asset asset)
{
if (ModelState.IsValid)
{
db.assets.AddObject(asset);
db.SaveChanges();
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, asset);
response.Headers.Location = new Uri(Url.Link("DefaultApi", new { id = asset.id }));
return(response);
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
public int Update()
{
asset assetToUpdate = db.assets.Find(this.assetId);
if (assetToUpdate == null)
{
return(0);
}
UpdateFields(assetToUpdate);
db.Entry(assetToUpdate).State = EntityState.Modified;
db.SaveChanges();
return(1);
}
public qnx(qnx old)
{
env = new env(old.env);
author = old.author;
authorId = old.authorId;
id = old.id;
filename = old.filename;
name = old.name;
description = old.description;
publisher = old.publisher;
versionNumber = old.versionNumber;
int assetCount = 5, splashAssetCount = old.splashScreens.images != null ? old.splashScreens.images.Length : 0;
assets = new asset[assetCount + splashAssetCount];
assets[0] = new asset(old.icon.image, old.icon.image);
assets[1] = new asset("Data", null);
assets[2] = new asset("lib", null);
assets[3] = new asset("SLAwards.bundle", "scoreloop/SLAwards.bundle");
assets[4] = new asset("Release", null);
for (int i = 0; i != splashAssetCount; ++i)
{
assets[assetCount + i] = new asset(old.splashScreens.images[i], old.splashScreens.images[i]);
}
icon = new icon(old.icon);
splashScreens = new splashScreens(old.splashScreens);
initialWindow = new initialWindow(old.initialWindow);
if (old.configuration != null)
{
configuration = new configuration(old.configuration);
}
category = old.category;
permissions = new permission[old.permissions.Length];
for (int i = 0; i != permissions.Length; ++i)
{
permissions[i] = new permission(old.permissions[i]);
}
}
// DELETE api/Asset/5
public HttpResponseMessage Deleteasset(int id)
{
asset asset = db.assets.Single(a => a.id == id);
if (asset == null)
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
db.assets.DeleteObject(asset);
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
return(Request.CreateResponse(HttpStatusCode.OK, asset));
}
// PUT api/Asset/5
public HttpResponseMessage Putasset(int id, asset asset)
{
if (ModelState.IsValid && id == asset.id)
{
db.assets.Attach(asset);
db.ObjectStateManager.ChangeObjectState(asset, EntityState.Modified);
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
public void AddAsset(AssetData item)
{
hasError = false;
try
{
TraditionAssetEntities db = new TraditionAssetEntities();
var data = new asset()
{
//asset_id = item.Asset_id,
os_id = item.Os_id,
asset_type_id = item.Asset_type_id,
original_supplier_id = item.Original_supplier_id,
supplier_id = item.Supplier_id,
using_by_staff_id = item.Using_by_staff_id,
asset_code = item.Asset_code,
brand = item.Brand,
price = item.Price,
cpu = item.Cpu,
ram = item.Ram,
hdd = item.Hdd,
notes = item.Note,
start_date_warranty = item.Start_date_warranty,
expiry_date_warranty = item.Expiry_date_warranty,
is_active = item.Is_active,
create_date = DateTime.Now,
modified_date = DateTime.Now
};
db.asset.Add(data);
db.SaveChanges();
MessageBox.Show("Insert complete");
}
catch (Exception ex)
{
errorMessage = "Add error, " + ex.Message;
hasError = true;
}
}
public void ExportToCollada(string outputPath)
{
var collada = new COLLADA();
var asset = new asset();
var contributor = new assetContributor();
if (ArtToolInfo != null)
{
contributor.authoring_tool = ArtToolInfo.FromArtToolName;
}
else
{
contributor.authoring_tool = "LSLib COLLADA Exporter v" + Common.LibraryVersion();
}
asset.contributor = new assetContributor[] { contributor };
asset.created = DateTime.Now;
asset.modified = DateTime.Now;
asset.unit = new assetUnit();
asset.unit.name = "meter";
// TODO: Handle up vector, etc. properly?
if (ArtToolInfo != null)
{
asset.unit.meter = ArtToolInfo.UnitsPerMeter;
}
else
{
asset.unit.meter = 1;
}
asset.up_axis = UpAxisType.Y_UP;
collada.asset = asset;
var geometries = new List <geometry>();
var controllers = new List <controller>();
var geomNodes = new List <node>();
ExportModels(geometries, controllers, geomNodes);
var animations = new List <animation>();
var animationClips = new List <animation_clip>();
if (Animations != null)
{
foreach (var anim in Animations)
{
var anims = anim.ExportAnimations();
animations.AddRange(anims);
var clip = new animation_clip();
clip.id = anim.Name + "_Animation";
clip.name = anim.Name;
clip.start = 0.0;
clip.end = anim.Duration;
clip.endSpecified = true;
var animInstances = new List <InstanceWithExtra>();
foreach (var animChannel in anims)
{
var instance = new InstanceWithExtra();
instance.url = "#" + animChannel.id;
animInstances.Add(instance);
}
clip.instance_animation = animInstances.ToArray();
animationClips.Add(clip);
}
}
var rootElements = new List <object>();
if (animations.Count > 0)
{
var animationLib = new library_animations();
animationLib.animation = animations.ToArray();
rootElements.Add(animationLib);
}
if (animationClips.Count > 0)
{
var animationClipLib = new library_animation_clips();
animationClipLib.animation_clip = animationClips.ToArray();
rootElements.Add(animationClipLib);
}
if (geometries.Count > 0)
{
var geometryLib = new library_geometries();
geometryLib.geometry = geometries.ToArray();
rootElements.Add(geometryLib);
}
if (controllers.Count > 0)
{
var controllerLib = new library_controllers();
controllerLib.controller = controllers.ToArray();
rootElements.Add(controllerLib);
}
var visualScenes = new library_visual_scenes();
var visualScene = new visual_scene();
visualScene.id = "DefaultVisualScene";
visualScene.name = "unnamed";
visualScene.node = geomNodes.ToArray();
visualScenes.visual_scene = new visual_scene[] { visualScene };
var visualSceneInstance = new InstanceWithExtra();
visualSceneInstance.url = "#DefaultVisualScene";
rootElements.Add(visualScenes);
var scene = new COLLADAScene();
scene.instance_visual_scene = visualSceneInstance;
collada.scene = scene;
collada.Items = rootElements.ToArray();
collada.Save(outputPath);
}
=> (TryGetResource(asset, dc, out var resource) ? resource.LastUser?.Owner : null) ?? dc.LastUser ?? dc.Owner;
public qnx(OldUnityXml.qnx old)
{
env = new env(old.env);
author = old.author;
authorId = old.authorId;
id = old.id;
filename = old.filename;
name = old.name;
description = old.description;
publisher = old.publisher;
versionNumber = old.versionNumber;
int assetCount = 5, splashAssetCount = old.splashScreens.images != null ? old.splashScreens.images.Length : 0;
assets = new asset[assetCount + splashAssetCount];
assets[0] = new asset(old.icon.image, old.icon.image);
assets[1] = new asset("Data", null);
assets[2] = new asset("lib", null);
assets[3] = new asset("SLAwards.bundle", "scoreloop/SLAwards.bundle");
assets[4] = new asset("Release", null);
for (int i = 0; i != splashAssetCount; ++i)
{
assets[assetCount+i] = new asset(old.splashScreens.images[i], old.splashScreens.images[i]);
}
icon = new icon(old.icon);
splashScreens = new splashScreens(old.splashScreens);
initialWindow = new initialWindow(old.initialWindow);
configuration = new configuration(old);
category = old.category;
permissions = new permission[old.actions.Length];
for (int i = 0; i != permissions.Length; ++i)
{
permissions[i] = new permission(old.actions[i]);
}
}
public bool Put([FromBody] asset ourAsset)
{
return(_ourAssetRepository.UpdateAsset(ourAsset));
}
public ExportToCollada(string workingPath)
{
this.workingPath = workingPath;
collada = new COLLADA();
geometries = new List <geometry>();
nodes = new List <node>();
meshLookup = new Dictionary <Mesh, string>();
ass = new asset();
ass.up_axis = UpAxisType.Y_UP;
ass.unit = new assetUnit();
ass.unit.meter = 1;
ass.unit.name = "meter";
libraryGeometries = new library_geometries();
// create effects
libraryEffects = new library_effects();
effects = new List <effect>();
effects.Add(new effect());
var effectId = CreateId();
effects[0].id = effectId;
effects[0].Items = new effectFx_profile_abstractProfile_COMMON[]
{
new effectFx_profile_abstractProfile_COMMON()
};
effects[0].Items[0].technique = new effectFx_profile_abstractProfile_COMMONTechnique();
effects[0].Items[0].technique.sid = "COMMON";
var phong = new effectFx_profile_abstractProfile_COMMONTechniquePhong();
effects[0].Items[0].technique.Item = phong;
SetPhong(phong, new Vector4(0.5f, 0.5f, 0.5f, 1));
// create materials
libraryMaterials = new library_materials();
materials = new List <material>();
materials.Add(new material());
materialId = CreateId();
materials[0].id = materialId;
materials[0].name = defaultMaterialName;
materials[0].instance_effect = new instance_effect();
materials[0].instance_effect.url = "#" + effectId;
// create visual scenes
visualScenes = new library_visual_scenes();
visualScene = new visual_scene();
visualScenes.visual_scene = new visual_scene[]
{
visualScene
};
var visualSceneId = CreateId();
visualScenes.visual_scene[0].id = visualSceneId;
libraryImages = new library_images();
images = new List <image>();
Build();
collada.scene = new COLLADAScene();
collada.scene.instance_visual_scene = new InstanceWithExtra();
collada.scene.instance_visual_scene.url = "#" + visualSceneId;
}
public bool Post([FromBody] asset ourAsset)
{
return(_ourAssetRepository.InsertAsset(ourAsset));
}
protected void Page_Load(object sender, EventArgs e)
{
System.Web.UI.WebControls.Label label = new Label();
// enclosing in try/catch for easier debugging, primarily
try
{
// get a handle to the asset operation service
proxy = new AssetOperationHandlerService();
// contruct a path object referencing the 'about' page from the example.com site
// note: change this path to a page that actually exists in your cms instance, if necessary
pagePath = new path();
// set the relative path (from the Base Folder) to the asset
pagePath.path1 = "/about";
// set the site name of the path object (note: set siteName to 'Global' if the asset is not in a Site)
pagePath.siteName = "example.com";
// contruct asset identifier used for read() operation
id = new identifier();
// set the asset type
id.type = entityTypeString.page;
// set asset path (may use either path or id, but never both)
id.path = pagePath;
// contruct authentication element to be used in all operations
auth = new authentication();
// change username / password as necessary
auth.username = "******";
auth.password = "******";
// attempt to read the asset
result = proxy.read(auth, id);
// print asset contents to page label
label.Text = CascadeWSUtils.printAssetContents(result.asset);
// edit the asset
// create an empty asset for use with edit() operation
// (note: this is assuming the authentication user has bypass workflow abilities --
// if not, you will also need to supply workflowConfig information)
asset editAsset = new asset();
editAsset.page = result.asset.page;
// add some content to the exiting page xhtml
editAsset.page.xhtml += "<h1>Added via .NET</h1>";
// must call this method to avoid sending both id and path values in
// component references in the asset -- will generate SOAP errors otherwise
CascadeWSUtils.nullPageValues(editAsset.page);
// attempt to edit
operationResult editResult = proxy.edit(auth, editAsset);
// check results
label.Text += "<br/><br/>edit success? " + editResult.success + "<br/>message = " + editResult.message;
// create new asset (using read asset as a model)
asset newAsset = new asset();
page newPage = result.asset.page;
// must call this method to avoid sending both id and path values in
// component references in the asset -- will generate SOAP errors otherwise
CascadeWSUtils.nullPageValues(newPage);
// since this will be a new asset, change its name
newPage.name = "new-page-created-via-dot-net";
// remove id from read asset
newPage.id = null;
// remove other system properties brought over from read asset
newPage.lastModifiedBy = null;
newPage.lastModifiedDate = null;
newPage.lastModifiedDateSpecified = false;
newPage.lastPublishedBy = null;
newPage.lastPublishedDate = null;
newPage.lastPublishedDateSpecified = false;
newPage.pageConfigurations = null;
newAsset.page = newPage;
// attempt to create
createResult createResults = proxy.create(auth, newAsset);
// check create results
label.Text = label.Text + "<br/><br/>create success? " + createResults.success + "<br/>message = " + createResults.message;
// debugging -- writes the serialzed XML of the asset element sent in create request to a file
/*
* // Serializing the returned object
* System.Xml.Serialization.XmlSerializer x = new System.Xml.Serialization.XmlSerializer(newAsset.GetType());
*
* System.IO.MemoryStream ms = new System.IO.MemoryStream();
*
* x.Serialize(ms, newAsset);
*
* ms.Position = 0;
*
* // Outputting to client
*
* byte[] byteArray = ms.ToArray();
*
* Response.Clear();
* Response.AddHeader("Content-Disposition", "attachment; filename=results.xml");
*
* Response.AddHeader("Content-Length", byteArray.Length.ToString());
*
* Response.ContentType = "text/xml";
*
* Response.BinaryWrite(byteArray);
* Response.End();
* */
}
catch (Exception booboo) { label.Text = "Exception thrown:<br>" + booboo.GetBaseException() + "<br/><br/>STACK TRACE:<br/>" + booboo.StackTrace; }
WSContent.Controls.Add(label);
}
