internal static void CreateInvAdj(Item item, int quant, string reason)
{
InventoryAdj invadj = new InventoryAdj(item, quant, reason);
using (var db = new ADDbContext())
{
db.InventoryAdj.Add(invadj);
db.SaveChanges();
}
}
internal static InventoryAdj FindById(int invAdjId)
{
InventoryAdj invadj = new InventoryAdj();
using (var db = new ADDbContext())
{
if (db.InventoryAdj.Where(x => x.Id == invAdjId).Any())
{
invadj = db.InventoryAdj.Include("item").Where(x => x.Id == invAdjId).FirstOrDefault();
}
}
return(invadj);
}
internal static void RejectInvAdj(int invAdjId, string remark)
{
InventoryAdj invadj = new InventoryAdj();
using (var db = new ADDbContext())
{
if (db.InventoryAdj.Where(x => x.Id == invAdjId).Any())
{
invadj = db.InventoryAdj.Where(x => x.Id == invAdjId).FirstOrDefault();
invadj.Status = "rejected";
invadj.Remark = remark;
db.SaveChanges();
}
}
}
internal static void DeleteInvAdj(int itemId)
{
InventoryAdj invadj = new InventoryAdj();
using (var db = new ADDbContext())
{
if (db.InventoryAdj.Where(x => x.Id == itemId).Any())
{
invadj = db.InventoryAdj.Where(x => x.Id == itemId).FirstOrDefault();
db.InventoryAdj.Remove(invadj);
db.SaveChanges();
}
}
}
public JsonResult approveInvAdj(int InvAdjId, string remark)
{
InventoryAdjData.ApproveInvAdj(InvAdjId, remark);
///Add record to stock card
///
InventoryAdj invadj = InventoryAdjData.FindById(InvAdjId);
Item item = ItemData.GetItemById(invadj.item.Id);
int balance = StockCardData.GetStockBalanceByItem(item);
StockCardData.AdjustStockRecord(DateTime.Today, invadj, balance);
///
object n = new { amt = 0 };
return(Json(n, JsonRequestBehavior.AllowGet));
}
public static void AdjustStockRecord(DateTime dt, InventoryAdj invadj, int balance)
{
StockCard sc = new StockCard();
Item it = new Item();
using (var db = new ADDbContext())
{
if (db.Item.Where(x => x.Id == invadj.item.Id).Any())
{
it = db.Item.Where(x => x.Id == invadj.item.Id).FirstOrDefault();
}
sc.date = dt;
sc.item = it;
sc.quant = invadj.Quant;
sc.comment = "Stock Adjustment--" + invadj.Reason;
sc.balance = balance + invadj.Quant;
db.StockCard.Add(sc);
db.SaveChanges();
}
}