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()); }