public ActionResult newItem(string projectName, string projectList, string itemListID, string location, string notes)
{
IoTDatabaseDataContext db = new IoTDatabaseDataContext();
if (projectList != "")
{
Project newProject = new Project();
newProject.projectName = projectName;
db.Projects.InsertOnSubmit(newProject);
db.SubmitChanges();
projectList = projectName;
}
int projectID = (from project in db.Projects
where projectList == project.projectName
select project).First().projectID;
int itemID = -1;
int.TryParse(itemListID, out itemID);
try
{
ItemDeployed newItemDeployed = new ItemDeployed();
newItemDeployed.itemID = itemID;
newItemDeployed.projectID = projectID;
newItemDeployed.location = location;
newItemDeployed.date = DateTime.Now;
newItemDeployed.notes = notes;
db.ItemDeployeds.InsertOnSubmit(newItemDeployed);
db.SubmitChanges();
}
catch (Exception e) { }
return(RedirectToAction("index"));
}
public ActionResult delItem(string itemID)
{
IoTDatabaseDataContext db = new IoTDatabaseDataContext();
int id = 0;
string result;
int.TryParse(itemID, out id);
ItemDeployed toDelete = null;;
try
{
toDelete = (from item in db.ItemDeployeds
where id == item.deployedID
select item).First();
}
catch (Exception e) { }
if (toDelete == null)
{
result = "What item were you trying to delete again, I forgot?";
}
else
{
result = "Item undeployed successfully";
db.ItemDeployeds.DeleteOnSubmit(toDelete);
}
db.SubmitChanges();
return(RedirectToAction("result", "Home", new { area = "", result = result }));
}
