public ActionResult delItem(string itemID)
{
IoTDatabaseDataContext db = new IoTDatabaseDataContext();
int id = 0;;
string result = "";
if (!int.TryParse(itemID, out id))
{
result = "dude plz";
}
else
{
Project toDelete = (from project in db.Projects
where id == project.projectID
select project).Single();
db.Projects.DeleteOnSubmit(toDelete);
try
{
db.SubmitChanges();
result = "project was deleted";
}
catch
{
result = "Project is being used";
}
}
return(RedirectToAction("result", "Home", new { area = "", result = result }));
}
public ActionResult checkOutItem(string personString, string itemString)
{
IoTDatabaseDataContext db = new IoTDatabaseDataContext();
ItemIssue ii = new ItemIssue();
int pID = -1;
int.TryParse(personString, out pID);
int iID = -1;
int.TryParse(itemString, out iID);
try
{
ii.personID = pID;
ii.itemID = iID;
ii.dateTaken = DateTime.Now;
db.ItemIssues.InsertOnSubmit(ii);
db.SubmitChanges();
}
catch (Exception e) { };
return(RedirectToAction("index"));
}
// GET api/<controller>/5
public List <itemDeployedModel> Get(int id)
{
IoTDatabaseDataContext db = new IoTDatabaseDataContext();
List <itemDeployedModel> items = new List <itemDeployedModel>();
List <ItemDeployed> list = (from item in db.ItemDeployeds
where id == item.deployedID
select item).ToList();
foreach (ItemDeployed item in list)
{
projectModel newProject = new projectModel(item.Project.projectName);
typeModel newType = new typeModel(item.Item.SubType.Type.typeID, item.Item.SubType.Type.typeName);
subTypeModel newSubType = new subTypeModel(item.Item.SubType.subTypeID, newType, item.Item.SubType.subTypeName, item.Item.SubType.description);
itemModel itemModel = new itemModel(item.itemID, newSubType, item.Item.itemNote);
itemDeployedModel newDeploy = new itemDeployedModel(newProject, itemModel, item.location, item.date.ToString(), item.notes);
items.Add(newDeploy);
}
return(items);
}
public ActionResult returnItem(string id)
{
IoTDatabaseDataContext db = new IoTDatabaseDataContext();
int iID = -1;
int.TryParse(id, out iID);
string result;
if (iID == -1)
{
ItemIssue select = (from item in db.ItemIssues
where item.issueID == iID
select item).First();
select.itemReturned = true;
select.dateReturned = DateTime.Now;
db.SubmitChanges();
result = "item returned";
}
else
{
result = "No item";
}
return(RedirectToAction("result", "Home", new { area = "", result = result }));
}
public ActionResult post(string name, string phone, string email)
{
IoTDatabaseDataContext db = new IoTDatabaseDataContext();
Person p = new Person();
if (name != "" && email != "")
{
p.name = name;
p.phoneNumber = phone;
p.email = email;
db.Persons.InsertOnSubmit(p);
db.SubmitChanges();
ViewBag.result = name + " added!";
ViewBag.colour = "green";
}
else
{
ViewBag.result = "Please insert a person";
ViewBag.colour = "red";
}
return(View("personAdd"));
}
// DELETE api/<controller>/5
public void Delete(int id)
{
IoTDatabaseDataContext db = new IoTDatabaseDataContext();
ItemIssue item = db.ItemIssues.Where(x => x.issueID == id).Single();
db.ItemIssues.DeleteOnSubmit(item);
db.SubmitChanges();
}
// GET: project
public ActionResult Index()
{
IoTDatabaseDataContext db = new IoTDatabaseDataContext();
List <Project> projects = (from project in db.Projects
select project).ToList();
ViewBag.projects = projects;
return(View());
}
// GET api/<controller> returns all the itemsissued in the data base
public IEnumerable <itemsIssuedModel> Get()
{
//example: api/itemsIssued
List <ItemIssue> itemsIssued = new List <ItemIssue>();
IoTDatabaseDataContext db = new IoTDatabaseDataContext();
itemsIssued = (from itemIssued in db.ItemIssues
select itemIssued).ToList();
return(populateList(itemsIssued));
}
// GET api/<controller>/5
public List <itemsIssuedModel> Get(int id)
{
List <ItemIssue> itemsIssued = new List <ItemIssue>();
IoTDatabaseDataContext db = new IoTDatabaseDataContext();
itemsIssued = (from itemIssued in db.ItemIssues
where itemIssued.issueID == id
select itemIssued).ToList();
return(populateList(itemsIssued));
}
public ActionResult index()
{
IoTDatabaseDataContext db = new IoTDatabaseDataContext();
List <Item> itemList = (from item in db.Items
select item).ToList();
ViewBag.itemList = itemList;
return(View());
}
public List <itemsIssuedModel> person(string person)
{
List <ItemIssue> allIssued = new List <ItemIssue>();
IoTDatabaseDataContext db = new IoTDatabaseDataContext();
allIssued = (from itemIssued in db.ItemIssues
where person == itemIssued.Person.name
select itemIssued).ToList();
return(populateList(allIssued));
}
public IEnumerable <itemsIssuedModel> type(string type)
{
List <ItemIssue> allIssued = new List <ItemIssue>();
IoTDatabaseDataContext db = new IoTDatabaseDataContext();
allIssued = (from itemIssued in db.ItemIssues
where type == itemIssued.Item.SubType.Type.typeName
select itemIssued).ToList();;
return(populateList(allIssued));
}
// POST: api/person
public void Post([FromBody] Person value)
{
IoTDatabaseDataContext db = new IoTDatabaseDataContext();
Person newPerson = new Person();
//newPerson.personID = value.personID;
newPerson.name = value.name;
newPerson.phoneNumber = value.phoneNumber;
newPerson.email = value.email;
db.Persons.InsertOnSubmit(newPerson);
db.SubmitChanges();
}
public ActionResult newItem(string projectName)
{
Project newProject = new Project();
newProject.projectName = projectName;
IoTDatabaseDataContext db = new IoTDatabaseDataContext();
db.Projects.InsertOnSubmit(newProject);
db.SubmitChanges();
return(RedirectToAction("index"));
}
// DELETE: api/person/5
public void Delete(int id)
{
IoTDatabaseDataContext db = new IoTDatabaseDataContext();
var sel = from person in db.Persons
where person.personID == id
select person;
foreach (var item in sel)
{
db.Persons.DeleteOnSubmit(item);
}
db.SubmitChanges();
}
public ActionResult checkOutItem()
{
IoTDatabaseDataContext db = new IoTDatabaseDataContext();
List <Person> per = (from person in db.Persons
select person).ToList();
List <Item> it = (from item in db.Items
select item).ToList();
ViewBag.person = per;
ViewBag.item = it;
return(View());
}
public ActionResult addItem()
{
IoTDatabaseDataContext db = new IoTDatabaseDataContext();
List <Project> projects = (from project in db.Projects
select project).ToList();
ViewBag.projects = projects;
List <Item> items = (from item in db.Items
select item).ToList();
ViewBag.items = items;
return(View());
}
// GET: api/person
public IEnumerable <personModel> Get()
{
List <personModel> per = new List <personModel>();
IoTDatabaseDataContext db = new IoTDatabaseDataContext();
var sel = from person in db.Persons
select person;
foreach (var item in sel)
{
personModel newPerson = new personModel(item.personID, item.name, item.phoneNumber, item.email);
per.Add(newPerson);
}
return(per);
}
// GET api/<controller>
public IEnumerable <personModel> Get()
{
List <personModel> list = new List <personModel>();
IoTDatabaseDataContext db = new IoTDatabaseDataContext();
var people = from person in db.Persons
select person;
foreach (var item in people)
{
personModel newOne = new personModel(item.personID, item.name, item.phoneNumber, item.email);
list.Add(newOne);
}
return(list);
}
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"));
}
// GET: whoHasWhat
public ActionResult Index()
{
IoTDatabaseDataContext db = new IoTDatabaseDataContext();
List <Person> persons = (from fella in db.Persons
select fella).ToList();
try
{
ViewBag.selectedID = persons.First().personID;
ViewBag.persons = persons;
}
catch (Exception e) {
}
ViewBag.persons = persons;
return(View());
}
// GET: itemIssuedPage
public ActionResult Index()
{
IoTDatabaseDataContext db = new IoTDatabaseDataContext();
List <ItemIssue> select = (from item in db.ItemIssues
select item).ToList();
List <ItemIssue> returnList = new List <ItemIssue>();
foreach (ItemIssue item in select)
{
if (item.itemReturned == null || item.itemReturned == false)
{
returnList.Add(item);
}
}
return(View(returnList));
}
// GET api/<controller>
public IEnumerable <itemModel> Get()
{
List <itemModel> itemList = new List <itemModel>();
IoTDatabaseDataContext db = new IoTDatabaseDataContext();
var allItems = from theItem in db.Items
select theItem;
foreach (var item in allItems)
{
typeModel newType = new typeModel(item.SubType.typeID, item.SubType.Type.typeName);
subTypeModel newSubType = new subTypeModel(item.SubType.subTypeID, newType, item.SubType.subTypeName, item.SubType.description);
itemModel itemModel = new itemModel(item.itemID, newSubType, item.itemNote);
itemList.Add(itemModel);
}
return(itemList);
}
public ActionResult delItem(string itemId)
{
int id = 0;
int.TryParse(itemId, out id);
IoTDatabaseDataContext db = new IoTDatabaseDataContext();
Item toDelete = null;
try
{
toDelete = (from item in db.Items
where item.itemID == id
select item).Single();
} catch (Exception e) { }
string result;
if (toDelete != null)
{
db.Items.DeleteOnSubmit(toDelete);
try
{
db.SubmitChanges();
result = "success the item has been deleted";
}
catch (Exception e)
{
result = "you can not delete this item because it is issued to someone or deployed in the field";
}
}
else
{
result = "the item has already been deleted you cheeky bugger";
}
return(RedirectToAction("result", "Home", new { area = "", result = result }));
}
public ActionResult del(string id)
{
int idCast = -1;
int.TryParse(id, out idCast);
IoTDatabaseDataContext db = new IoTDatabaseDataContext();
string name = "";
try
{
name = (from person in db.Persons
where person.personID == idCast
select person).Single().name;
}
catch (Exception e) { }
ViewBag.delete = "Nothing selected";
if (idCast != -1)
{
var sel = from person in db.Persons
where person.personID == idCast
select person;
foreach (var item in sel)
{
db.Persons.DeleteOnSubmit(item);
ViewBag.delete = name + " deleted!";
}
db.SubmitChanges();
}
return(RedirectToAction("result", "Home", new { area = "", result = ViewBag.delete }));
}
public void Post([FromBody] newItemIssued json)
{
IoTDatabaseDataContext db = new IoTDatabaseDataContext();
ItemIssue newItemIssue = new ItemIssue();
newItemIssue.personID = json.personID;
newItemIssue.itemID = json.itemID;
newItemIssue.dateTaken = DateTime.Now;
db.ItemIssues.InsertOnSubmit(newItemIssue);
try
{
db.SubmitChanges();
}
catch (Exception e) {
//bad foreign keys
}
}
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 }));
}
public ActionResult selected(string personID)
{
IoTDatabaseDataContext db = new IoTDatabaseDataContext();
int id = 0;
int.TryParse(personID, out id);
ViewBag.selectedID = id;
List <ItemIssue> itemIssueList = (from itemIssue in db.ItemIssues
where itemIssue.personID == id
select itemIssue).ToList();
List <Person> persons = (from fella in db.Persons
select fella).ToList();
ViewBag.itemIssueList = itemIssueList;
ViewBag.persons = persons;
return(View("index"));
}
// GET: itemPage
public ActionResult addItem()
{
IoTDatabaseDataContext db = new IoTDatabaseDataContext();
List <Type> currentTypes = new List <Type>();
List <SubType> currentSubstypes = new List <SubType>();
currentTypes = (from type in db.Types
select type).ToList();
currentSubstypes = (from type in db.SubTypes
select type).ToList();
ViewBag.currentTypes = currentTypes;
ViewBag.currentSubtypes = currentSubstypes;
return(View());
}
public ActionResult newItem(string type, string subType, string itemNote, string subTypeDescription, string typeList, string subTypeList)
{
IoTDatabaseDataContext db = new IoTDatabaseDataContext();
int subTypeID;
string typeName = typeList;
if (subTypeList == "")
{
if (typeList == "")
{
IoTWebApi.Type newType = new IoTWebApi.Type();
newType.typeName = type;
int typeId = -1;
try {
typeId = (from theType in db.Types
where type == theType.typeName
select theType).First().typeID;
}catch (Exception e) { }
if (typeId == -1)
{
db.Types.InsertOnSubmit(newType);
db.SubmitChanges();
}
typeName = type;
}
SubType newSubType = new SubType();
newSubType.subTypeName = subType;
newSubType.description = subTypeDescription;
newSubType.typeID = (from theType in db.Types
where typeName == theType.typeName
select theType).First().typeID;
//To check if the sub type allready exists
subTypeID = -1;
try
{
subTypeID = (from theSubType in db.SubTypes
where subType == theSubType.subTypeName
select theSubType).First().subTypeID;
}catch (Exception e) { };
if (subTypeID == -1)
{
db.SubTypes.InsertOnSubmit(newSubType);
db.SubmitChanges();
}
subTypeID = (from theSubType in db.SubTypes
where subType == theSubType.subTypeName
select theSubType).First().subTypeID;
}
else
{
//newSubType.subTypeName = subTypeList;
subTypeID = (from theSubType in db.SubTypes
where subTypeList == theSubType.subTypeName
select theSubType).First().subTypeID;
}
Item newItem = new Item();
newItem.subTypeID = subTypeID;
newItem.itemNote = itemNote;
db.Items.InsertOnSubmit(newItem);
db.SubmitChanges();
return(RedirectToAction("index"));
//return View("index");
}