public static StockTransaction returnStock(long pid, int qua, string comment)
{
StockInventory db = new StockInventory();
StockTransaction st = new StockTransaction();
Stock s = db.Stocks.Include("Product.Category").FirstOrDefault(xx => xx.Product.ProductId == pid);
st.Stock = s;
st.comment = comment;
st.time = DateTime.Now;
st.QuantityBefore = s.Quantity;
int x = Stock.RevertStock(s.StockId, qua);
if (x > 0)
{
st.QuantityAfter = x;
st = db.StockTransactions.Add(st);
db.SaveChanges();
if (st != null)
{
return(st);
}
else
{
return(null);
}
}
return(null);
}
public static StockTransaction transact(long sid, int qua, string comment)
{
StockInventory db = new StockInventory();
StockTransaction st = new StockTransaction();
Stock s = db.Stocks.Include("Product.Category").FirstOrDefault(x => x.StockId == sid);
st.Stock = s;
st.comment = comment;
st.time = DateTime.Now;
st.QuantityBefore = s.Quantity;
if (s.Quantity >= qua)
{
int x = Stock.deductStock(s.StockId, qua);
if (x >= 0)
{
try
{
st.QuantityAfter = x;
Stock m = st.Stock;
long c = m.Product.ProductId;
st = db.StockTransactions.Add(st);
db.SaveChanges();
if (st != null)
{
return(st);
}
else
{
return(null);
}
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Debug.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Debug.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
throw;
}
}
}
return(null);
}
public static long removeEntry(long stid)
{
StockInventory db = new StockInventory();
StockTransaction st = db.StockTransactions.FirstOrDefault(x => x.StockTransactionId == stid);
if (st != null)
{
db.StockTransactions.Remove(st);
db.SaveChanges();
return(st.StockTransactionId);
}
else
{
return(0);
}
}