public int Create(SellingItem item)
{
this.items.Add(item);
this.items.Save();
return(item.Id);
}
public void SetUp()
{
_sellingItem = new SellingItem()
{
Name = "Invalid",
Quality = 1,
SellingDays = 1
};
}
public void SetUp()
{
_sellingItem = new SellingItem()
{
Name = "Backstage passes",
Quality = 1,
SellingDays = 1
};
}
public void SetUp()
{
_sellingItem = new SellingItem()
{
Name = "Normal Item",
Quality = 1,
SellingDays = 1
};
}
public void SetUp()
{
_sellingItem = new SellingItem()
{
Name = "Aged Brie",
Quality = 1,
SellingDays = 1
};
}
public void SetUp()
{
_sellingItem = new SellingItem()
{
Name = "Sulfuras",
Quality = 1,
SellingDays = 1
};
}
public void Update(int id, SellingItem item)
{
var entityToUpdate = this.items.GetById(id);
entityToUpdate.Title = item.Title;
entityToUpdate.Description = item.Description;
entityToUpdate.PriceBGN = item.PriceBGN;
entityToUpdate.Availability = item.Availability;
entityToUpdate.Images = item.Images;
this.items.Save();
}
public int Create(string title, string description, string sellerId, decimal price, int availability)
{
var newEntity = new SellingItem()
{
Title = title,
Description = description,
SellerId = sellerId,
PriceBGN = price,
Availability = availability
};
this.items.Add(newEntity);
this.items.Save();
return(newEntity.Id);
}
public static InventoryItem Get(SellingItem item)
{
switch (item.Name)
{
case "Aged Brie":
return(new AgedBrie(item));
case "Backstage passes":
return(new BackstagePasses(item));
case "Sulfuras":
return(new Sulfuras(item));
case "Normal Item":
return(new NormalItem(item));
case "Conjured":
return(new Conjured(item));
}
return(new Invalid(item));
}
public NormalItem(SellingItem sellingItem) : base(sellingItem)
{
Process();
}
public Invalid(SellingItem sellingItem) : base(sellingItem)
{
Name = _name;
}
public Sulfuras(SellingItem sellingItem) : base(sellingItem)
{
Process();
}
public BackstagePasses(SellingItem sellingItem) : base(sellingItem)
{
Process();
}
public Conjured(SellingItem sellingItem) : base(sellingItem)
{
Process();
}
public ActionResult AddTransaction(string tNo, string tDate, int ShipToLoc, WarehouseTransfer[] GridItems)
{
var status = "error";
try
{
WarehouseTransferMain objWHTM = new WarehouseTransferMain();
objWHTM.TransactionNo = tNo;
objWHTM.TransferDate = DateTime.Parse(tDate);
objWHTM.LocationId = ShipToLoc;
objWHTM.UID = Guid.NewGuid();
objWHTM.CreatedBy = ActiveUserId;
objWHTM.UpdatedBy = ActiveUserId;
objWHTM.CreatedOn = DateTime.Now;
objWHTM.UpdatedOn = DateTime.Now;
db.WarehouseTransferMains.Add(objWHTM);
db.SaveChanges();
WarehouseTransfer objWhT = new WarehouseTransfer();
for (var i = 0; i < GridItems.Length; i++)
{
var items = GridItems[i];
var objItem = (from itm in db.Items where itm.Id == items.ItemId select itm).SingleOrDefault();
var objWh = (from w in db.Warehouses where w.ItemId == items.ItemId select w).SingleOrDefault();
objWhT.ItemId = items.ItemId;
objWhT.WtmId = objWHTM.Id;
objWhT.CategoryId = objItem.CategoryId;
objWhT.UomId = objItem.UomId;
objWhT.Barcode = objItem.Barcode;
objWhT.AvailableQty = objWh.QtyAvailable;
objWhT.IssueQty = items.IssueQty;
objWhT.BalanceQty = (objWhT.AvailableQty) - (items.IssueQty);
objWhT.SaleRate = objWh.SaleRate;
objWhT.CostRate = objWh.CostRate;
objWhT.CreatedOn = DateTime.Now;
objWhT.CreatedBy = ActiveUserId;
objWh.QtyAvailable = (objWh.QtyAvailable) - (items.IssueQty);
db.WarehouseTransfers.Add(objWhT);
//save in selling item table
var alreadyExist = db.SellingItems.Where(x => x.ItemId == items.ItemId).SingleOrDefault();
SellingItem objSi = new SellingItem();
if (alreadyExist == null)
{
objSi.ItemId = items.ItemId;
objSi.Barcode = objItem.Barcode;
objSi.CategoryId = objItem.CategoryId;
objSi.UomId = objItem.UomId;
objSi.Quantity = items.IssueQty;
objSi.CostRate = objWh.CostRate;
objSi.SaleRate = objWh.SaleRate;
objSi.CreatedBy = ActiveUserId;
objSi.CreatedOn = DateTime.Now;
db.SellingItems.Add(objSi);
}
else
{
alreadyExist.Quantity += items.IssueQty;
alreadyExist.CostRate = objWh.CostRate;
alreadyExist.SaleRate = objWh.SaleRate;
alreadyExist.UpdatedBy = ActiveUserId;
alreadyExist.UpdatedOn = DateTime.Now;
}
db.SaveChanges();
}
status = "Success";
}
catch (Exception ex)
{
ApplicationExceptionLogging(ex.Message, ex.StackTrace, "StockTransfer", "AddTransaction");
}
return(Content(status));
}
public AgedBrie(SellingItem sellingItem) : base(sellingItem)
{
Process();
}
private void TriggerSelling(Item item)
{
AudioManager.Instance.PlayItemSell();
SellingItem?.Invoke(item);
}
public InventoryItem(SellingItem sellingItem)
{
Quality = sellingItem.Quality;
SellingDays = sellingItem.SellingDays;
Name = sellingItem.Name;
}
