public void rejectAdjustmentItem(int adjustmentId, int itemId)
{
StockAdjustmentItem item = db.StockAdjustmentItems.Where(x => x.StockAdjustmentID == adjustmentId && x.ItemID == itemId).FirstOrDefault();
item.Status = AdjustmentStatus.Rejected.ToString();
db.StockAdjustmentItems.Attach(item);
var entry = db.Entry(item);
entry.Property(e => e.Status).IsModified = true;
db.SaveChanges();
}
public bool CreateSpotAdjustment(Adjustment adjustment)
{
bool isSuccessful = false;
LogicUniStoreModel dbContext;
try
{
StockAdjustment objAdjustment = new StockAdjustment()
{
CreatedBy = adjustment.CreatedBy,
CreatedDate = DateTime.Now,
SockAdjustmentNumber = adjustment.Number,
Status = AdjustmentStatus.Created.ToString(),
Type = StockCheckType.OnSpot.ToString()
};
objAdjustment.StockAdjustmentItems = new List <StockAdjustmentItem>();
foreach (AdjustmentItem item in adjustment.Items)
{
StockAdjustmentItem objAdjItem = new StockAdjustmentItem()
{
CountDate = DateTime.Now,
CountPerson = adjustment.CreatedBy.ToString(), //TODO: Change to Id
CountQuantity = item.Quantity,
ItemID = item.ItemId,
Remark = item.Remarks,
Status = AdjustmentStatus.Created.ToString(),
AdjustQuantity = item.Quantity,
StockAdjustment = objAdjustment
};
objAdjustment.StockAdjustmentItems.Add(objAdjItem);
}
dbContext = new LogicUniStoreModel();
dbContext.Database.Connection.Open();
using (var txn = dbContext.Database.BeginTransaction())
{
//Create Adjustment and Items
AdjustmentDao dao = new AdjustmentDao(dbContext);
dao.CreateAdjustment(objAdjustment);
//Update stock card
//dao.updateStockCard(objAdjustment.StockAdjustmentItems.ToList());
txn.Commit();
isSuccessful = true;
}
dbContext.Database.Connection.Close();
}
catch (Exception)
{
// throw;
}
return(isSuccessful);
}