public InventoryApiController()
{
context = new ApplicationDbContext();
itemService = new ItemService(context);
stkMovementService = new StockMovementService(context);
itemPriceService = new ItemPriceService(context);
requisitionService = new RequisitionService(context);
purchaseOrderService = new PurchaseOrderService(context);
}
public StockAdjustmentService(ApplicationDbContext context)
{
this.context = context;
this.statusRepository = new StatusRepository(context);
this.stockAdjustmentRepository = new StockAdjustmentRepository(context);
this.stockAdjustmentDetailRepository = new StockAdjustmentDetailRepository(context);
this.itemService = new ItemService(context);
this.inventoryRepository = new InventoryRepository(context);
this.stockMovementRepository = new StockMovementRepository(context);
this.stockMovementService = new StockMovementService(context);
}
public static void ConfigureServices(IAppRepository repository)
{
// Instantiate our services
AppSettingsService = new AppSettingsService(repository);
LocationService = new LocationService(repository);
NotificationService = new NotificationService(repository);
ProductLocationService = new ProductLocationService(repository);
ProductService = new ProductService(repository);
RoleService = new RoleService(repository);
StockMovementService = new StockMovementService(repository);
UserService = new UserService(repository);
}
public ActionResult Index(int?page)
{
int pageIndex = PagingHelper.GetPageIndex(page);
StockMovementSearchModel q = new StockMovementSearchModel();
IStockMovementService ss = new StockMovementService(Settings.Default.db);
IPagedList <StockMovement> stockMovements = ss.Search(q).ToPagedList(pageIndex, Settings.Default.pageSize);
ViewBag.Query = q;
SetMoveTypeDisplayList(null);
return(View(stockMovements));
}
public ActionResult Search([Bind(Include = "PartNr,PartNrAct, DateFrom, DateTo, MoveType")] StockMovementSearchModel q)
{
int pageIndex = 0;
int.TryParse(Request.QueryString.Get("page"), out pageIndex);
pageIndex = PagingHelper.GetPageIndex(pageIndex);
IStockMovementService ss = new StockMovementService(Settings.Default.db);
IPagedList <StockMovement> stockMovements = ss.Search(q).ToPagedList(pageIndex, Settings.Default.pageSize);
ViewBag.Query = q;
SetMoveTypeDisplayList(q.MoveType);
return(View("Index", stockMovements));
}
public void Export([Bind(Include = "PartNr, PartNrAct, DateFrom, DateTo, MoveType")] StockMovementSearchModel q)
{
IStockMovementService sms = new StockMovementService(Settings.Default.db);
List <StockMovement> stockMovements = sms.Search(q).ToList();
ViewBag.Query = q;
MemoryStream ms = new MemoryStream();
using (StreamWriter sw = new StreamWriter(ms, Encoding.UTF8))
{
List <string> head = new List <string>
{
"N0.", "PartNr", "Quantity", "FIFO", "MoveType", "SouceDoc", "CreatedAt"
};
sw.WriteLine(string.Join(Settings.Default.csvDelimiter, head));
for (var i = 0; i < stockMovements.Count; i++)
{
List <string> ii = new List <string>();
ii.Add((i + 1).ToString());
ii.Add(stockMovements[i].partNr);
ii.Add(stockMovements[i].quantity.ToString());
ii.Add(stockMovements[i].fifoDisplay);
ii.Add(stockMovements[i].typeDisplay);
ii.Add(stockMovements[i].sourceDoc == null ? string.Empty : stockMovements[i].sourceDoc.ToString());
ii.Add(stockMovements[i].createdAtDisplay);
sw.WriteLine(string.Join(Settings.Default.csvDelimiter, ii.ToArray()));
}
}
var filename = "StockMovements" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".csv";
var contenttype = "text/csv";
Response.Clear();
Response.ContentEncoding = Encoding.UTF8;
Response.ContentType = contenttype;
Response.AddHeader("content-disposition", "attachment;filename=" + filename);
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.BinaryWrite(ms.ToArray());
Response.End();
}
public ActionResult JsonSearch([Bind(Include = "PartNr, DateFrom, DateTo, MoveType")] StockMovementSearchModel q)
{
int pageIndex = 0;
int.TryParse(Request.QueryString.Get("page"), out pageIndex);
pageIndex = PagingHelper.GetPageIndex(pageIndex);
if (q.DateFrom.HasValue)
{
q.DateFrom = q.DateFrom.Value.Date;
}
if (q.DateTo.HasValue)
{
q.DateTo = q.DateTo.Value.Date.AddDays(1).AddMilliseconds(-1);
}
ViewBag.Query = q;
IStockMovementService ss = new StockMovementService(Settings.Default.db);
IPagedList <StockMovement> moves = ss.Search(q).ToPagedList(pageIndex, Settings.Default.pageSize);
return(Json(moves.ToList(), JsonRequestBehavior.AllowGet));
}
public void TestInitialize()
{
context = new ApplicationDbContext();
stockmovementService = new StockMovementService(context);
itemService = new ItemService(context);
stockmovementRepository = new StockMovementRepository(context);
ddRepository = new DisbursementDetailRepository(context);
sadRepository = new StockAdjustmentDetailRepository(context);
dodRepository = new DeliveryOrderDetailRepository(context);
disbursementRepository = new DisbursementRepository(context);
doRepository = new DeliveryOrderRepository(context);
saRepository = new StockAdjustmentRepository(context);
//create new test object and save into db
StockMovement sm = new StockMovement()
{
StockMovementId = IdService.GetNewStockMovementId(context),
DisbursementId = "TEST",
StockAdjustmentId = "TEST",
DeliveryOrderNo = "TEST",
Item = context.Item.Where(x => x.ItemCode == "C003").First(),
CreatedDateTime = DateTime.Now,
OriginalQuantity = 1,
AfterQuantity = 2
};
stockmovementRepository.Save(sm);
//create new disbursement object and save into db
Disbursement disbursement = new Disbursement();
if (disbursementRepository.FindById("TEST") == null)
{
disbursement.DisbursementId = "TEST";
disbursement.CreatedDateTime = DateTime.Now;
}
else
{
disbursement = disbursementRepository.FindById("TEST");
}
disbursementRepository.Save(disbursement);
//create new DisbursementDetail object and save into db
DisbursementDetail detail = new DisbursementDetail()
{
DisbursementId = "TEST",
Item = context.Item.First(),
PlanQuantity = 3,
ActualQuantity = 3
};
ddRepository.Save(detail);
//create new DO object and save into db
DeliveryOrder d = new DeliveryOrder();
if (doRepository.FindById("TEST") == null)
{
d.DeliveryOrderNo = "TEST";
d.CreatedDateTime = DateTime.Now;
}
else
{
d = doRepository.FindById("TEST");
}
doRepository.Save(d);
//create new DO detail object and save into db
DeliveryOrderDetail dod = new DeliveryOrderDetail()
{
DeliveryOrder = d,
Item = context.Item.First(),
PlanQuantity = 4,
ActualQuantity = 4
};
dodRepository.Save(dod);
//create new SA object and save into db
StockAdjustment SA = new StockAdjustment();
if (saRepository.FindById("TEST") == null)
{
SA.StockAdjustmentId = "TEST";
SA.CreatedDateTime = DateTime.Now;
}
else
{
SA = saRepository.FindById("TEST");
}
saRepository.Save(SA);
//create new SA detail object and save into db
StockAdjustmentDetail SADetail = new StockAdjustmentDetail()
{
StockAdjustment = SA,
Item = context.Item.First(),
OriginalQuantity = 2,
AfterQuantity = 4
};
sadRepository.Save(SADetail);
}
public void TestInitialize()
{
context = new ApplicationDbContext();
stockmovementRepository = new StockMovementRepository(context);
stockmovementService = new StockMovementService(context);
}
