public item createItem(itemModel im)
{
item newitem = new item();
newitem.itemName = im.itemName;
return(Create(newitem));
}
// 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 IHttpActionResult Return_item([FromUri] int item_id, [FromUri] int qty, [FromUri] int oid)
{
order o = new orderModel().GetAll().Where(x => x.id == oid).ToList()[0];
order_items oi = new order_itemsModel().GetAll().Where(x => x.oid == o.id && x.item_id == item_id).ToList()[0];
oi.qty = oi.qty - qty;
oi.total = oi.total - oi.item.retail_price * qty;
oi.profit = oi.profit - (oi.item.retail_price - oi.item.original_price) * qty;
//oi.disc = oi.disc - oi.item.discount_price * qty;
new order_itemsModel().Update(oi);
o.total_amount = o.total_amount - (oi.item.retail_price * qty);
o.total_profit = o.total_profit - (oi.item.retail_price - oi.item.original_price) * qty;
new orderModel().Update(o);
order_return or = new order_return();
or.oid = oid;
or.dt = DateTime.Now;
or.user_id = User.Identity.GetUserId();
int id = new order_returnModel().Create(or);
order_return_items ori = new order_return_items();
ori.orid = id;
ori.item_id = item_id;
ori.qty = qty;
new order_return_itemModel().Create(ori);
item i = new itemModel().GetAll().Where(x => x.id == item_id).ToList()[0];
i.qty = i.qty + qty;
new itemModel().Update(i);
return(Ok());
}
public MainPage()
{
InitializeComponent();
vm = new itemModel();
//Llamo al modelo de objeto prestablecido en la carpeta ViewModel.
itemList.ItemsSource = vm.items;
// Detail = new NavigationPage(new Page1());
var nav = new NavigationPage(new Page1());
nav.BarBackgroundColor = Color.Black;
nav.BarTextColor = Color.White;
/* Se cambian las propiedades de la barra de navegación.
* - Se tuvo que instanciar una variable de pagina de navegación para pode realizar los cambios
* de propiedades, pues al igualarlo con detail se daba lugar a un override atributos.
*/
Detail = nav;
IsPresented = true;
/*Indica que esta sera la página que sera presentada al inicio de la aplicación poco después
* de que se termine el tiempo de duracion del splashscreen incorporado.
*/
}
public void Enter_New_Stock([System.Web.Http.FromUri] int item_id, [System.Web.Http.FromUri] int retail_price, [System.Web.Http.FromUri] int new_qty)
{
item i = new itemModel().GetAll().Where(x => x.id == item_id).ToList()[0];
i.retail_price = retail_price;
i.qty = i.qty + new_qty;
new itemModel().Update(i);
}
public ActionResult Edit(itemModel im)
{
if (ModelState.IsValid)
{
_itemRepository.editItem(im);
return(RedirectToAction("Index"));
}
return(View(im));
}
//
// GET: /item/details?itemid={itemid}
//
public ActionResult getItem(int itemid)
{
itemModel im = _itemRepository.GetItem(itemid);
return(Json(new
{
im
}, JsonRequestBehavior.AllowGet));
}
public ActionResult Create(itemModel item)
{
if (ModelState.IsValid)
{
_itemRepository.createItem(item);
return(RedirectToAction("Index"));
}
return(View(item));
}
//
// GET: /baseItem/GetItem/{itemID}
//
public itemModel GetItem(int itemID)
{
using (var db = new WarehouseEntities())
{
itemModel item = (from i in db.items where i.itemID == itemID select new itemModel {
itemID = i.itemID, itemName = i.itemName
}).FirstOrDefault();
return(item);
}
}
public ActionResult createItem(string itemName)
{
item i = _itemRepository.createItemByName(itemName);
itemModel im = itemModel.ToModel(i);
return(Json(new
{
im
}));
}
public JsonResult Filter_Read(string text)
{
text = text.ToLower();
var products = new itemModel().Read();
if (!string.IsNullOrEmpty(text))
{
products = products.Where(i => (i.name.ToLower().Contains(text) || i.Barcode.Equals(text)) && i.isActive && i.tag);
}
return(Json(products, JsonRequestBehavior.AllowGet));
}
public item editItem(itemModel im)
{
item item = Find(i => i.itemID == im.itemID);
if (item != null)
{
item.itemName = im.itemName;
Update(item);
}
return(item);
}
//method to return the list of itemsIssued makes the code more modular
private List <itemsIssuedModel> populateList(List <ItemIssue> allItemsLinq)
{
List <itemsIssuedModel> itemsIssued = new List <itemsIssuedModel>();
foreach (var item in allItemsLinq)
{
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);
personModel newPerson = new personModel(item.Person.personID, item.Person.name, item.Person.phoneNumber, item.Person.email);
itemsIssuedModel newItem = new itemsIssuedModel(item.issueID, newPerson, itemModel, item.itemReturned);
itemsIssued.Add(newItem);
}
return(itemsIssued);
}
// 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);
}
