public IHttpActionResult GetBarcodeItem(string barcode)
{
BarcodeItem item = new BarcodeItem();
dynamic item_attributes = new JObject();
dynamic item_response = new JObject();
using (var DB = new collectorEntities1())
{
item = ItemService.GetBarcodeItem(DB, barcode);
}
if (item != null)
{
item_attributes.title = item.Title;
item_attributes.upc = item.Upc;
item_attributes.ean = item.Ean;
item_attributes.category = item.Category;
item_attributes.model = item.Model;
item_attributes.manufacturer = item.Manufacturer;
item_attributes.description = item.Description;
item_response.code = 200;
return(Json(new { item_response, item_attributes, success = true }));
}
else
{
item_response = new JObject();
item_response.code = 404;
return(Json(new { success = false }));
}
}
public static void SetPassword(collectorEntities1 DB, string password)
{
var user = DB.Users.OrderByDescending(u => u.ID).FirstOrDefault();
password = Utils.sha256(password + user.ID);
user.Password = password;
DB.SaveChanges();
}
public IHttpActionResult PostBarcode([FromBody] dynamic jsonObject)
{
using (var DB = new collectorEntities1())
{
ItemService.PostBarcodeItem(DB, jsonObject);
}
return(Json(new { success = true }));
}
public IHttpActionResult GetUserItems(int userID)
{
List <CollectionItem> userItems = new List <CollectionItem>();
using (var DB = new collectorEntities1())
{
userItems = ItemService.GetUserItems(DB, userID);
}
return(Json(new { userItems }));
}
public IHttpActionResult GetItems()
{
List <CollectionItem> allItems = new List <CollectionItem>();
using (var DB = new collectorEntities1())
{
allItems = ItemService.GetItems(DB);
}
return(Json(new { item = allItems }));
}
public static void PostItem(collectorEntities1 DB, dynamic jsonItem)
{
CollectionItem item = new CollectionItem();
item.ItemName = jsonItem.itemName;
item.UPC = jsonItem.upcCode;
item.UserID = jsonItem.userID;
DB.CollectionItems.Add(item);
DB.SaveChanges();
}
public ActionResult Index()
{
ViewBag.Title = "Home Page";
using (var DB = new collectorEntities1())
{
ViewBag.Items = ItemService.GetItems(DB);
}
return(View());
}
public static bool VerifyLogin(collectorEntities1 DB, string password, User user)
{
password = Utils.sha256(password + user.ID);
if (password == user.Password)
{
return(true);
}
else
{
return(false);
}
}
public static void CreateUser(collectorEntities1 DB, string username, string password, string displayName)
{
User user = new User()
{
Username = username,
DisplayName = displayName
};
DB.Users.Add(user);
DB.SaveChanges();
SetPassword(DB, password);
}
public ActionResult AddUser(string username, string password, string displayName)
{
User user = new User();
using (var DB = new collectorEntities1())
{
user = UserService.GetUser(DB, username);
if (user != null)
{
return(RedirectToAction("RegisterConfirm", new { nameTaken = true }));
}
UserService.CreateUser(DB, username, password, displayName);
}
return(RedirectToAction("RegisterConfirm"));
}
public IHttpActionResult PostItem([FromBody] dynamic jsonObject)
{
using (var DB = new collectorEntities1())
{
var item = ItemService.GetItemByBarcodeAndUser(DB, jsonObject.upcCode.ToString(), (int)jsonObject.userID);
if (item == null)
{
ItemService.PostItem(DB, jsonObject);
}
else
{
return(Json(new { success = false }));
}
}
return(Json(new { success = true }));
}
public static void PostBarcodeItem(collectorEntities1 DB, dynamic jsonItem) // Needs checked because barcodes add a 13 char
{
BarcodeItem item = new BarcodeItem()
{
Upc = jsonItem.upc,
Ean = jsonItem.ean,
Category = jsonItem.category,
Brand = jsonItem.brand,
Model = jsonItem.model,
Manufacturer = jsonItem.manufacturer,
Description = jsonItem.description,
Title = jsonItem.title
};
DB.BarcodeItems.Add(item);
DB.SaveChanges();
}
public IHttpActionResult GetLogin(string username, string password)
{
User user = new User();
bool validLogin = false;
using (var DB = new collectorEntities1())
{
user = UserService.GetUser(DB, username);
validLogin = UserService.VerifyLogin(DB, password, user);
}
if (validLogin)
{
return(Json(new { login = validLogin, userID = user.ID, username = user.Username, userDisplayName = user.DisplayName }));
}
else
{
return(Json(new { login = validLogin }));
}
}
public static CollectionItem GetItemByBarcodeAndUser(collectorEntities1 DB, string barcode, int userID)
{
var userItems = DB.CollectionItems.Where(i => i.UserID == userID).ToList();
return(userItems.Where(b => b.UPC == barcode).FirstOrDefault());
}
public static List <CollectionItem> GetUserItems(collectorEntities1 DB, int userID)
{
return(DB.CollectionItems.Where(i => i.UserID == userID).ToList());
}
public static List <CollectionItem> GetItems(collectorEntities1 DB)
{
return(DB.CollectionItems.ToList());
}
public static BarcodeItem GetBarcodeItem(collectorEntities1 DB, string barcode)
{
return(DB.BarcodeItems.Where(b => b.Upc == barcode).FirstOrDefault());
}
public static User GetUser(collectorEntities1 DB, string userName)
{
return(DB.Users.Where(u => u.Username == userName).FirstOrDefault());
}
