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