public void Generate_ProductMovement()
{
///Delete all Movements.
if (base.item_movement.Where(x => x.id_company == CurrentSession.Id_Company).Count() > 0)
{
base.item_movement.RemoveRange(base.item_movement.Where(x => x.id_company == CurrentSession.Id_Company).ToList());
base.SaveChanges();
}
///Purchase
List <purchase_invoice> purchaseLIST = purchase_invoice
.Where(x =>
x.id_company == CurrentSession.Id_Company &&
x.status == Status.Documents_General.Approved
).ToList();
foreach (purchase_invoice purchase in purchaseLIST.OrderBy(y => y.trans_date))
{
using (PurchaseInvoiceDB PurchaseDB = new PurchaseInvoiceDB())
{
purchase.IsSelected = true;
PurchaseDB.Insert_Items_2_Movement(purchase);
PurchaseDB.SaveChanges();
}
}
using (ImpexDB ImpexDB = new ImpexDB())
{
ImpexDB.impex.Load();
foreach (impex impex in ImpexDB.impex.Local.Where(x => x.status == Status.Documents_General.Approved))
{
impex.IsSelected = true;
impex.status = Status.Documents_General.Pending;
ImpexDB.ApproveImport();
}
}
DateTime StartDate = DateTime.Now.AddMonths(-6);
DateTime EndDate = DateTime.Now;
foreach (DateTime day in EachDay(StartDate, EndDate))
{
if (base.item_inventory.Any(x => x.trans_date.Day == day.Day && x.trans_date.Month == day.Month))
{
///Inventory
using (InventoryDB InventoryDB = new InventoryDB())
{
List <item_inventory> item_inventoryLIST = InventoryDB.item_inventory.Where(x =>
x.id_company == CurrentSession.Id_Company &&
x.trans_date.Day == day.Day && x.trans_date.Month == day.Month &&
x.status == Status.Documents.Issued).ToList();
foreach (item_inventory inventory in item_inventoryLIST.OrderBy(y => y.trans_date))
{
if (inventory.status == Status.Documents.Issued)
{
inventory.status = Status.Documents.Pending;
inventory.IsSelected = true;
}
foreach (item_inventory_detail item_inventory_detail in inventory.item_inventory_detail)
{
if (item_inventory_detail.value_counted > 0)
{
item_inventory_detail.IsSelected = true;
}
}
InventoryDB.Approve();
}
}
}
if (base.item_transfer.Any(x => x.trans_date.Day == day.Day && x.trans_date.Month == day.Month))
{
///Transfers & Movement
using (ProductTransferDB ProductTransferDB = new ProductTransferDB())
{
List <item_transfer> item_transferLIST = ProductTransferDB.item_transfer.Where(x => x.id_company == CurrentSession.Id_Company &&
x.trans_date.Day == day.Day && x.trans_date.Month == day.Month &&
x.status == Status.Transfer.Approved).ToList();
foreach (item_transfer transfer in item_transferLIST.OrderBy(y => y.trans_date))
{
transfer.IsSelected = true;
foreach (item_transfer_detail detail in transfer.item_transfer_detail)
{
detail.status = Status.Documents_General.Pending;
detail.IsSelected = true;
}
ProductTransferDB.SaveChanges();
ProductTransferDB.ApproveOrigin(transfer.app_branch_origin.id_branch, transfer.app_branch_destination.id_branch, false);
ProductTransferDB.ApproveDestination(transfer.app_branch_origin.id_branch, transfer.app_branch_destination.id_branch, false);
transfer.IsSelected = false;
}
}
}
}
List <sales_invoice> sales_invoiceLIST = base.sales_invoice.Where(x => x.id_company == CurrentSession.Id_Company && x.status == Status.Documents_General.Approved).ToList();
foreach (sales_invoice sales in sales_invoiceLIST.OrderBy(y => y.trans_date))
{
///Sales
using (SalesInvoiceDB SalesInvoiceDB = new SalesInvoiceDB())
{
sales_invoice sales_invoice = SalesInvoiceDB.sales_invoice.Where(x => x.id_sales_invoice == sales.id_sales_invoice).FirstOrDefault();
SalesInvoiceDB.Insert_Items_2_Movement(sales_invoice);
SalesInvoiceDB.SaveChanges();
}
}
}