public string fallItem(string token) { token = TokenManager.readToken(HttpContext.Current.Request); string message = ""; var strP = TokenManager.GetPrincipal(token); if (strP != "0") //invalid authorization { return(TokenManager.GenerateToken(strP)); } else { try { string newObject = ""; inventoryItemLocation Object = null; IEnumerable <Claim> claims = TokenManager.getTokenClaims(token); foreach (Claim c in claims) { if (c.Type == "itemObject") { newObject = c.Value.Replace("\\", string.Empty); newObject = newObject.Trim('"'); Object = JsonConvert.DeserializeObject <inventoryItemLocation>(newObject, new IsoDateTimeConverter { DateTimeFormat = "dd/MM/yyyy" }); break; } } using (incposdbEntities entity = new incposdbEntities()) { var unitEntity = entity.Set <pos>(); var tmpItem = entity.inventoryItemLocation.Where(p => p.id == Object.id).FirstOrDefault(); tmpItem.notes = Object.notes; tmpItem.isFalls = true; tmpItem.updateDate = DateTime.Now; tmpItem.updateUserId = Object.updateUserId; tmpItem.fallCause = Object.fallCause; message = tmpItem.id.ToString(); entity.SaveChanges(); } } catch { message = "0"; return(TokenManager.GenerateToken(message)); } } return(TokenManager.GenerateToken(message)); }
public string Delete(string token) { token = TokenManager.readToken(HttpContext.Current.Request); string message = ""; var strP = TokenManager.GetPrincipal(token); if (strP != "0") //invalid authorization { return(TokenManager.GenerateToken(strP)); } else { int id = 0; int userId = 0; Boolean final = false; IEnumerable <Claim> claims = TokenManager.getTokenClaims(token); foreach (Claim c in claims) { if (c.Type == "itemId") { id = int.Parse(c.Value); } else if (c.Type == "userId") { userId = int.Parse(c.Value); } else if (c.Type == "final") { final = bool.Parse(c.Value); } } if (final) { try { using (incposdbEntities entity = new incposdbEntities()) { inventoryItemLocation Deleterow = entity.inventoryItemLocation.Find(id); entity.inventoryItemLocation.Remove(Deleterow); message = entity.SaveChanges().ToString(); return(TokenManager.GenerateToken(message)); } } catch { message = "0"; return(TokenManager.GenerateToken(message)); } } else { try { using (incposdbEntities entity = new incposdbEntities()) { inventoryItemLocation Obj = entity.inventoryItemLocation.Find(id); Obj.isActive = 0; Obj.updateUserId = userId; Obj.updateDate = DateTime.Now; message = entity.SaveChanges().ToString(); return(TokenManager.GenerateToken(message)); } } catch { message = "0"; return(TokenManager.GenerateToken(message)); } } } }
public string Save(string token) { token = TokenManager.readToken(HttpContext.Current.Request); var strP = TokenManager.GetPrincipal(token); if (strP != "0") //invalid authorization { return(TokenManager.GenerateToken(strP)); } else { string message = ""; string newObject = ""; int inventoryId = 0; List <InventoryItemLocationModel> Object = null; IEnumerable <Claim> claims = TokenManager.getTokenClaims(token); foreach (Claim c in claims) { if (c.Type == "itemObject") { newObject = c.Value.Replace("\\", string.Empty); newObject = newObject.Trim('"'); Object = JsonConvert.DeserializeObject <List <InventoryItemLocationModel> >(newObject, new JsonSerializerSettings { DateParseHandling = DateParseHandling.None }); } else if (c.Type == "inventoryId") { inventoryId = int.Parse(c.Value); } } using (incposdbEntities entity = new incposdbEntities()) { List <inventoryItemLocation> items = entity.inventoryItemLocation.Where(x => x.inventoryId == inventoryId).ToList(); if (items == null || items.Count == 0)// add first time { foreach (InventoryItemLocationModel il in Object) { inventoryItemLocation tmp = new inventoryItemLocation(); if (il.createUserId == 0 || il.createUserId == null) { Nullable <int> id = null; tmp.createUserId = id; } if (il.amountDestroyed == 0 || il.amountDestroyed == null) { Nullable <int> id = 0; tmp.amountDestroyed = id; } tmp.inventoryId = inventoryId; tmp.amount = il.amount; tmp.amountDestroyed = il.amountDestroyed; tmp.isDestroyed = il.isDestroyed; tmp.isFalls = il.isFalls; tmp.realAmount = il.quantity; tmp.cause = il.cause; tmp.notes = il.notes; tmp.itemLocationId = il.itemLocationId; tmp.createDate = DateTime.Now; tmp.updateDate = DateTime.Now; tmp.updateUserId = il.createUserId; entity.inventoryItemLocation.Add(tmp); message = tmp.id.ToString(); } entity.SaveChanges(); return(TokenManager.GenerateToken(message)); } else // edit saved inventory details { foreach (InventoryItemLocationModel il in Object) { inventoryItemLocation invItem = entity.inventoryItemLocation.Find(il.id); invItem.amount = il.amount; invItem.isDestroyed = il.isDestroyed; invItem.isFalls = il.isFalls; invItem.amountDestroyed = il.amountDestroyed; invItem.cause = il.cause; invItem.notes = il.notes; invItem.updateDate = DateTime.Now; invItem.updateUserId = il.updateUserId; message = invItem.id.ToString(); } entity.SaveChanges(); return(TokenManager.GenerateToken(message)); } } message = "0"; return(TokenManager.GenerateToken(message)); } }