public List <Model.GoodsReceivedNoteItem> GetGRNItemz4rmbin(Model.Bin bin)
{
var or = SessionData.CurrentSession.OrderRequestList.FirstOrDefault(p => p.OrderRequestItems.Where(k => k.Id == bin.OrderRequestItemId).Count() > 0);
var ppitm = SessionData.CurrentSession.ProcurementPlanItemList.FirstOrDefault(p => p.Id == bin.ProcurementPlanItemId);
if (ppitm != null)
{
return(SessionData.CurrentSession.GoodsReceivedNoteItemList
.Where(gitmz => gitmz.PurchaseOrderItem.ProcurementPlanItem != null &&
gitmz.PurchaseOrderItem.ProcurementPlanItem.ProcurementPlan.Id == ppitm.ProcurementPlan.Id &&
gitmz.GoodsReceivedNote.WareHouseId == bin.WareHouseId &&
(gitmz.BinItems.Count == 0 || gitmz.BinItems.Sum(d => d.QTYReceived) < (Int64)gitmz.QuantityDelivered) &&
gitmz.PurchaseOrderItem.Item.Id == ppitm.ItemId && gitmz.GoodsReceivedNote.Verified).ToList());
}
else
{
var oritm = or.OrderRequestItems.FirstOrDefault(p => p.Id == bin.OrderRequestItemId);
return(SessionData.CurrentSession.GoodsReceivedNoteItemList
.Where(gitmz => gitmz.PurchaseOrderItem.OrderRequestItem != null &&
gitmz.PurchaseOrderItem.OrderRequestItem.OrderRequest.Id == oritm.OrderRequest.Id &&
gitmz.GoodsReceivedNote.WareHouseId == bin.WareHouseId &&
(gitmz.BinItems.Count == 0 || gitmz.BinItems.Sum(d => d.QTYReceived) < (Int64)gitmz.QuantityDelivered) &&
gitmz.PurchaseOrderItem.Item.Id == oritm.ItemId && gitmz.GoodsReceivedNote.Verified).ToList());
}
}
public ActionResult SelectStockItem()
{
var model = new Model.Bin()
{
ORItemsItems = new SelectList(new List <Model.Item>(), "Id", "Name"),
Projects = new SelectList(_orService.GetProjectNos(), "Id", "ProjectNumber")
};
return(View(model));
}
public ActionResult SaveBC(Model.Bin entity)
{
entity.Id = Guid.NewGuid();
entity.CountryProgrammeId = countryProg.Id;
entity.PreparedBy = currentStaff.Id;
entity.PreparedOn = DateTime.Now;
entity.RefNumber = _binService.GenerateUniquBCNo();
entity.QTY = 0;
if (!_binService.IsBinAdded(entity))
{
LoadBin();
}
return(ViewBinCard());
}
public bool IsBinEdited(Model.Bin binEntity)
{
using (var db = new SCMSEntities())
{
db.Bins.Attach(binEntity);
((IObjectContextAdapter)db).ObjectContext.ObjectStateManager.ChangeObjectState(binEntity, System.Data.EntityState.Modified);
if (db.SaveChanges() > 0)
{
SessionData.CurrentSession.BinList = null; return(true);
}
else
{
return(false);
}
}
}
public ActionResult LoadBin()
{
var model = new Model.Bin()
{
// Warehouses = new SelectList(SessionData.CurrentSession.WarehouseList, "Id", "Name"),
Warehouses = new SelectList(new List <Model.WareHouse>(), "Id", "Name"),
ItemPackages = new SelectList(new List <Model.ItemPackage>(), "Id", "Name"),
RefNumber = string.Format("--{0}--", Resources.BinCard_LoadBin___NewBinCard___),
PPlans = new SelectList(_binService.GetBinPPs(), "Id", "RefNumber"),
PPlansItems = new SelectList(new List <Model.ProcurementPlanItem>(), "Id", "ItemName"),
ORequests = new SelectList(_binService.GetBinORs(), "Id", "RefNumber"),
ORItemsItems = new SelectList(new List <Model.OrderRequestItem>(), "Id", "ItemName"),
RefLable = Resources.Global_String_OrderRequestNo,
RefItemLable = Resources.OrderRequest_String_OrderRequestItems
};
return(View("LoadBin", model));
}
public string GenerateUniquBCNo()
{
string code = "BC/";
string refNumber = "";
long count = 1;
var total = this.GetAll().Count();// SessionData.CurrentSession.BinList.Count();
count = total;
Model.Bin m = null;
do
{
count++;
if (count < 100000)
{
if (count < 10)
{
refNumber = code + "00000" + count;
}
if (count < 100 && count >= 10)
{
refNumber = code + "0000" + count;
}
if (count < 1000 && count >= 100)
{
refNumber = code + "000" + count;
}
if (count < 10000 && count >= 1000)
{
refNumber = code + "00" + count;
}
if (count < 100000 && count >= 10000)
{
refNumber = code + "0" + count;
}
}
m = SessionData.CurrentSession.BinList.FirstOrDefault(p => p.RefNumber == refNumber);
} while (m != null);
return(refNumber);
}
public bool IsBinAdded(Model.Bin binEntity)
{
using (var db = new SCMSEntities())
{
if (binEntity.BinType == "OR")
{
binEntity.ProcurementPlanItemId = null;
}
else
{
binEntity.OrderRequestItemId = null;
}
db.Bins.Add(binEntity);
if (db.SaveChanges() > 0)
{
SessionData.CurrentSession.BinList = null; return(true);
}
else
{
return(false);
}
}
}
public bool IsBinItemAdded(Model.BinItem binItemEntity, Model.Bin binEntity)
{
using (var db = new SCMSEntities())
{
if (binEntity != null)
{
binEntity.QTY = binItemEntity.QTYReceived;
db.Bins.Add(binEntity);
binItemEntity.BalanceStock = binItemEntity.QTYReceived;
db.BinItems.Add(binItemEntity);
}
else
{
var bin = db.Bins.FirstOrDefault(p => p.Id == binItemEntity.BinId); bin.BinType = "any";
var binitem = db.BinItems.Where(p => p.BinId == binItemEntity.BinId).OrderByDescending(k => k.IssueDate).FirstOrDefault();
if (binItemEntity.QTYReceived > 0)
{
binItemEntity.BalanceStock = binItemEntity.QTYReceived + (binitem != null ? binitem.BalanceStock : 0); bin.QTY += binItemEntity.QTYReceived;
}
else
{
binItemEntity.BalanceStock = binitem != null ? binitem.BalanceStock - binItemEntity.QTYIssued : binItemEntity.QTYIssued; bin.QTY -= binItemEntity.QTYIssued;
}
db.BinItems.Add(binItemEntity);
((IObjectContextAdapter)db).ObjectContext.ObjectStateManager.ChangeObjectState(bin, System.Data.EntityState.Modified);
}
if (db.SaveChanges() > 0)
{
SessionData.CurrentSession.BinList = null; SessionData.CurrentSession.BinItemList = null;
SessionData.CurrentSession.GoodsReceivedNoteItemList = null; SessionData.CurrentSession.ReleaseOrderItemList = null; return(true);
}
else
{
return(false);
}
}
}
public ActionResult EditBC(Model.Bin enitty)
{
_binService.IsBinEdited(enitty);
return(ManageBin(enitty.Id));
}
