/// <summary>
/// Executes code that will insert Invoiced Items into Movement.
/// </summary>
/// <param name="invoice"></param>
public void Discount_Items_Origin(item_transfer_detail item_transfer_detail, int ID_BranchOrigin, int ID_BranchDestination, bool movebytruck)
{
entity.Brillo.Logic.Stock stock = new Brillo.Logic.Stock();
if (item_transfer_detail.item_product != null)
{
if (movebytruck)
{
app_currencyfx app_currencyfx = base.app_currencyfx.Where(x => x.app_currency.is_active).FirstOrDefault();
app_location app_location = base.app_location.Where(x => x.id_branch == ID_BranchOrigin && x.is_default).FirstOrDefault();
List <entity.Brillo.StockList> Items_InStockLIST;
if (item_transfer_detail.movement_id != null)
{
entity.Brillo.Stock stockBrillo = new Brillo.Stock();
Items_InStockLIST = stockBrillo.ScalarMovement(base.item_movement.Where(x => x.id_movement == item_transfer_detail.movement_id).FirstOrDefault());
}
else
{
entity.Brillo.Stock stockBrillo = new Brillo.Stock();
Items_InStockLIST = stockBrillo.List(app_location.app_branch, app_location, item_transfer_detail.item_product);
}
List <item_movement> item_movement_originList;
item_movement_originList = stock.DebitOnly_MovementLIST(this, Items_InStockLIST, Status.Stock.InStock, App.Names.Transfer, item_transfer_detail.id_transfer, item_transfer_detail.id_transfer_detail, app_currencyfx, item_transfer_detail.item_product, app_location,
item_transfer_detail.quantity_origin, item_transfer_detail.item_transfer.trans_date, stock.comment_Generator(App.Names.Transfer, item_transfer_detail.item_transfer.number != null ? item_transfer_detail.item_transfer.number.ToString() : "", ""));
base.item_movement.AddRange(item_movement_originList);
item_movement item_movement_Dest;
app_currencyfx app_currencyfxdest = base.app_currencyfx.Where(x => x.app_currency.is_active).FirstOrDefault();
app_location app_locationdest = base.app_location.Where(x => x.id_branch == ID_BranchDestination && x.is_default).FirstOrDefault();
item_movement_Dest = stock.CreditOnly_Movement(
Status.Stock.InStock,
App.Names.Transfer,
item_transfer_detail.id_transfer,
item_transfer_detail.id_transfer_detail,
app_currencyfxdest,
item_transfer_detail.item_product,
app_locationdest,
item_transfer_detail.quantity_origin,
item_transfer_detail.item_transfer.trans_date,
0,
stock.comment_Generator(App.Names.Transfer, item_transfer_detail.item_transfer.number != null ? item_transfer_detail.item_transfer.number.ToString() : "", ""),
null);
base.item_movement.Add(item_movement_Dest);
}
else
{
app_currencyfx app_currencyfx = base.app_currencyfx.Where(x => x.app_currency.is_active).FirstOrDefault();
app_location app_location = base.app_location.Where(x => x.id_branch == ID_BranchOrigin && x.is_default).FirstOrDefault();
List <entity.Brillo.StockList> Items_InStockLIST;
if (item_transfer_detail.movement_id != null)
{
entity.Brillo.Stock stockBrillo = new Brillo.Stock();
Items_InStockLIST = stockBrillo.ScalarMovement(base.item_movement.Where(x => x.id_movement == item_transfer_detail.movement_id).FirstOrDefault());
}
else
{
entity.Brillo.Stock stockBrillo = new Brillo.Stock();
Items_InStockLIST = stockBrillo.List(app_location.app_branch, app_location, item_transfer_detail.item_product);
}
///Debit Movement from Origin.
List <item_movement> item_movement_originList;
item_movement_originList = stock.DebitOnly_MovementLIST(this, Items_InStockLIST, Status.Stock.InStock, App.Names.Transfer, item_transfer_detail.id_transfer, item_transfer_detail.id_transfer_detail, app_currencyfx, item_transfer_detail.item_product, app_location,
item_transfer_detail.quantity_origin, item_transfer_detail.item_transfer.trans_date, stock.comment_Generator(App.Names.Transfer, item_transfer_detail.item_transfer.number != null ? item_transfer_detail.item_transfer.number.ToString() : "", ""));
base.item_movement.AddRange(item_movement_originList);
}
}
}
public void Approve()
{
OrderDB orderdb = new OrderDB();
foreach (item_request item_request in base.item_request.Local.Where(x =>
x.status != Status.Documents_General.Approved &&
x.IsSelected))
{
item_transfer item_transfer = new item_transfer();
item_transfer.status = Status.Transfer.Pending;
entity.Properties.Settings setting = new Properties.Settings();
item_transfer.user_requested = base.security_user.Where(x => x.id_user == CurrentSession.Id_User).FirstOrDefault();
item_transfer.id_item_request = item_request.id_item_request;
if (base.app_department.FirstOrDefault() != null)
{
item_transfer.id_department = base.app_department.FirstOrDefault().id_department;
}
if (base.app_document_range.Where(x => x.app_document.id_application == App.Names.Movement).FirstOrDefault() != null)
{
item_transfer.id_range = base.app_document_range.Where(x => x.app_document.id_application == App.Names.Movement).FirstOrDefault().id_range;
}
item_transfer item_transfertrans = new item_transfer();
item_transfertrans.status = Status.Transfer.Pending;
item_transfertrans.user_requested = base.security_user.Where(x => x.id_user == CurrentSession.Id_User).FirstOrDefault();
item_transfertrans.id_item_request = item_request.id_item_request;
if (base.app_department.FirstOrDefault() != null)
{
item_transfertrans.id_department = base.app_department.FirstOrDefault().id_department;
}
if (base.app_document_range.Where(x => x.app_document.id_application == App.Names.Movement).FirstOrDefault() != null)
{
item_transfertrans.id_range = base.app_document_range.Where(x => x.app_document.id_application == App.Names.Movement).FirstOrDefault().id_range;
}
purchase_tender purchase_tender = new purchase_tender();
purchase_tender.status = Status.Documents_General.Pending;
purchase_tender.id_department = item_request.id_department;
purchase_tender.name = item_request.name;
purchase_tender.code = 000;
purchase_tender.trans_date = item_request.request_date;
purchase_tender.comment = item_request.comment;
int Line = 0;
if (production_line.FirstOrDefault() != null)
{
Line = production_line.FirstOrDefault().id_production_line;
}
production_order production_order = orderdb.New(item_request.name, production_order.ProductionOrderTypes.Fraction, Line);
production_order.id_project = item_request.id_project;
production_execution production_execution = new production_execution();
foreach (item_request_detail item_request_detail in item_request.item_request_detail)
{
foreach (item_request_decision item in item_request_detail.item_request_decision)
{
//if (item.IsSelected == true)
//{
if (item.decision == entity.item_request_decision.Decisions.Movement)
{
// ProductTransferDB ProductTransferDB = new entity.ProductTransferDB();
// item_transfer _item_transfer = new entity.item_transfer();
item_transfer.status = Status.Transfer.Pending;
item_transfer.IsSelected = true;
item_transfer.State = EntityState.Added;
item_transfer.user_requested = base.security_user.Where(x => x.id_user == CurrentSession.Id_User).FirstOrDefault();
item_transfer.id_item_request = item_request.id_item_request;
if (base.app_department.FirstOrDefault() != null)
{
item_transfer.id_department = base.app_department.FirstOrDefault().id_department;
}
if (base.app_document_range.Where(x => x.app_document.id_application == App.Names.Movement).FirstOrDefault() != null)
{
item_transfer.id_range = base.app_document_range.Where(x => x.app_document.id_application == App.Names.Movement).FirstOrDefault().id_range;
}
int id_location = (int)item.id_location;
item_transfer.app_location_origin = base.app_location.Where(x => x.id_location == id_location).FirstOrDefault();
item_transfer.app_branch_origin = base.app_location.Where(x => x.id_location == id_location).FirstOrDefault().app_branch;
item_transfer.comment = "Transfer item Request from " + item.decision.ToString();
//Create Transfer Detail in DB.
item_transfer_detail item_transfer_detail = new item_transfer_detail();
item_transfer_detail.id_item_product = item_request_detail.item.item_product.FirstOrDefault().id_item_product;
item_transfer_detail.item_product = base.item_product.Where(x => x.id_item_product == item_transfer_detail.id_item_product).FirstOrDefault();
item_transfer_detail.quantity_origin = item.quantity;
item_transfer_detail.quantity_destination = item.quantity;
item_transfer_detail.movement_id = item.movement_id;
if (item_request_detail.id_project_task != null)
{
//Transfer related to Project because there is a Project.
item_transfer_detail.id_project_task = item_request_detail.id_project_task;
int id_branch = (int)base.projects.Where(x => x.id_project == item_request_detail.project_task.id_project).FirstOrDefault().id_branch;
item_transfer.app_location_destination = base.app_branch.Where(x => x.id_branch == id_branch).FirstOrDefault().app_location.Where(x => x.is_default).FirstOrDefault();
item_transfer.app_branch_destination = base.app_branch.Where(x => x.id_branch == id_branch).FirstOrDefault();
item_transfer.id_project = item_request_detail.project_task.id_project;
}
if (item_request_detail.id_sales_order_detail != null)
{
item_transfer.app_location_destination = base.app_branch.Where(x => x.id_branch == item_request.sales_order.app_branch.id_branch).FirstOrDefault().app_location.Where(x => x.is_default).FirstOrDefault();
item_transfer.app_branch_destination = base.app_branch.Where(x => x.id_branch == item_request.sales_order.app_branch.id_branch).FirstOrDefault();
}
if (item_request_detail.id_order_detail != null)
{
//Get Production Line
int id_production_line = base.production_order_detail.Where(x => x.id_order_detail == item_request_detail.id_order_detail).FirstOrDefault().production_order.id_production_line;
//Get Location based on Line
app_location app_location = base.production_line.Where(x => x.id_production_line == id_production_line).FirstOrDefault().app_location;
item_transfer.app_location_destination = app_location;
//Get Branch based on Location
item_transfer.app_branch_destination = base.app_branch.Where(x => x.id_branch == app_location.id_branch).FirstOrDefault();
}
foreach (item_request_dimension item_request_dimension in item_request_detail.item_request_dimension)
{
item_transfer_dimension item_transfer_dimension = new item_transfer_dimension();
item_transfer_dimension.id_dimension = item_request_dimension.id_dimension;
item_transfer_dimension.value = item_request_dimension.value;
item_transfer_detail.item_transfer_dimension.Add(item_transfer_dimension);
}
item_transfer.item_transfer_detail.Add(item_transfer_detail);
item_transfer.transfer_type = entity.item_transfer.Transfer_type.movemnent;
base.item_transfer.Add(item_transfer);
// ProductTransferDB.SaveChanges();
}
else if (item.decision == entity.item_request_decision.Decisions.Transfer)
{
int id_location = (int)item.id_location;
item_transfertrans.app_location_origin = base.app_location.Where(x => x.id_location == id_location).FirstOrDefault();
item_transfertrans.app_branch_origin = base.app_location.Where(x => x.id_location == id_location).FirstOrDefault().app_branch;
item_transfertrans.comment = "Transfer item Request from " + item.decision.ToString();
if (item_request_detail.id_project_task != null)
{
int id_branch = (int)base.projects.Where(x => x.id_project == item_request_detail.project_task.id_project).FirstOrDefault().id_branch;
item_transfertrans.app_location_destination = base.app_branch.Where(x => x.id_branch == id_branch).FirstOrDefault().app_location.Where(x => x.is_default).FirstOrDefault();
item_transfertrans.app_branch_destination = base.app_branch.Where(x => x.id_branch == id_branch).FirstOrDefault();
item_transfertrans.id_project = item_request_detail.project_task.id_project;
}
if (item_request_detail.id_sales_order_detail != null)
{
item_transfertrans.app_location_destination = item_request.sales_order.app_branch.app_location.Where(x => x.is_default).FirstOrDefault();
item_transfertrans.app_branch_destination = item_request.sales_order.app_branch;
}
if (item_request_detail.id_order_detail != null)
{
if (base.production_order_detail.Where(x => x.id_order_detail == item_request_detail.id_order_detail).FirstOrDefault().project_task != null)
{
int id_project = base.production_order_detail.Where(x => x.id_order_detail == item_request_detail.id_order_detail).FirstOrDefault().project_task.id_project;
int id_branch = (int)base.projects.Where(x => x.id_project == id_project).FirstOrDefault().id_branch;
item_transfertrans.app_location_destination = base.app_branch.Where(x => x.id_branch == id_branch).FirstOrDefault().app_location.Where(x => x.is_default).FirstOrDefault();
item_transfertrans.app_branch_destination = base.app_branch.Where(x => x.id_branch == id_branch).FirstOrDefault();
}
}
item_transfer_detail item_transfer_detail = new item_transfer_detail();
item_transfer_detail.id_item_product = item_request_detail.item.item_product.FirstOrDefault().id_item_product;
if (item_request_detail.project_task != null)
{
item_transfer_detail.id_project_task = item_request_detail.project_task.id_project_task;
}
foreach (item_request_dimension item_request_dimension in item_request_detail.item_request_dimension)
{
item_transfer_dimension item_transfer_dimension = new item_transfer_dimension();
item_transfer_dimension.id_dimension = item_request_dimension.id_dimension;
item_transfer_dimension.value = item_request_dimension.value;
item_transfer_detail.item_transfer_dimension.Add(item_transfer_dimension);
}
item_transfer_detail.quantity_origin = item.quantity;
item_transfer_detail.quantity_destination = item.quantity;
item_transfer_detail.movement_id = item.movement_id;
item_transfertrans.item_transfer_detail.Add(item_transfer_detail);
item_transfertrans.transfer_type = entity.item_transfer.Transfer_type.transfer;
}
else if (item.decision == entity.item_request_decision.Decisions.Production)
{
production_order_detail production_order_detail = new production_order_detail();
production_order_detail.name = item_request_detail.item.name;
production_order_detail.quantity = item.quantity;
production_order_detail.status = Status.Production.Pending;
production_order_detail.is_input = false;
production_order_detail.id_item = item_request_detail.item.id_item;
if (item.item_request_detail.id_project_task != null)
{
production_order_detail.id_project_task = item.item_request_detail.id_project_task;
}
foreach (item_request_dimension item_request_dimension in item_request_detail.item_request_dimension)
{
production_order_dimension production_order_dimension = new production_order_dimension();
production_order_dimension.id_dimension = item_request_dimension.id_dimension;
production_order_dimension.id_measurement = item_request_dimension.id_measurement;
production_order_dimension.value = item_request_dimension.value;
production_order_detail.production_order_dimension.Add(production_order_dimension);
}
production_order.production_order_detail.Add(production_order_detail);
production_execution.production_order = production_order;
production_execution.id_production_line = production_order.id_production_line;
production_execution.trans_date = DateTime.Now;
}
else
{
if (item_request_detail.id_project_task != null)
{
if (base.projects.Where(x => x.id_project == item_request_detail.project_task.id_project).FirstOrDefault().id_branch != null)
{
int id_branch = (int)base.projects.Where(x => x.id_project == item_request_detail.project_task.id_project).FirstOrDefault().id_branch;
purchase_tender.app_branch = base.app_branch.Where(x => x.id_branch == id_branch).FirstOrDefault();
}
else
{
purchase_tender.app_branch = base.app_branch.Where(x => x.can_invoice == true && x.can_stock == true).FirstOrDefault();
}
}
if (item_request_detail.id_sales_order_detail != null)
{
purchase_tender.app_branch = item_request.sales_order.app_branch;
}
if (item_request_detail.id_order_detail != null)
{
if (base.production_order_detail.Where(x => x.id_order_detail == item_request_detail.id_order_detail).FirstOrDefault() != null)
{
if (base.production_order_detail.Where(x => x.id_order_detail == item_request_detail.id_order_detail).FirstOrDefault().project_task != null)
{
int id_project = base.production_order_detail.Where(x => x.id_order_detail == item_request_detail.id_order_detail).FirstOrDefault().project_task.id_project;
if (base.projects.Where(x => x.id_project == id_project).FirstOrDefault() != null)
{
int id_branch = (int)base.projects.Where(x => x.id_project == id_project).FirstOrDefault().id_branch;
if (base.app_branch.Where(x => x.id_branch == id_branch).FirstOrDefault() != null)
{
purchase_tender.id_project = item_request_detail.project_task.id_project;
purchase_tender.app_branch = base.app_branch.Where(x => x.id_branch == id_branch).FirstOrDefault();
}
}
}
}
}
else
{
purchase_tender.app_branch = base.app_branch.Where(x => x.id_branch == CurrentSession.Id_Branch).FirstOrDefault();
}
purchase_tender_item purchase_tender_item = new purchase_tender_item();
purchase_tender_item.id_item = item_request_detail.id_item;
purchase_tender_item.item_description = item_request_detail.comment;
purchase_tender_item.quantity = item.quantity;
foreach (item_request_dimension item_request_dimension in item_request_detail.item_request_dimension)
{
purchase_tender_dimension purchase_tender_dimension = new purchase_tender_dimension();
purchase_tender_dimension.id_dimension = item_request_dimension.id_dimension;
purchase_tender_dimension.id_measurement = item_request_dimension.id_measurement;
purchase_tender_dimension.value = item_request_dimension.value;
purchase_tender_item.purchase_tender_dimension.Add(purchase_tender_dimension);
}
purchase_tender.purchase_tender_item_detail.Add(purchase_tender_item);
}
item_request.status = Status.Documents_General.Approved;
//}
}
}
if (purchase_tender.purchase_tender_item_detail.Count() > 0)
{
base.purchase_tender.Add(purchase_tender);
}
if (item_transfer.item_transfer_detail.Count() > 0)
{
base.item_transfer.Add(item_transfer);
}
if (item_transfertrans.item_transfer_detail.Count() > 0)
{
base.item_transfer.Add(item_transfertrans);
}
if (production_order.production_order_detail.Count() > 0)
{
orderdb.production_order.Add(production_order);
orderdb.production_execution.Add(production_execution);
}
}
orderdb.SaveChanges();
SaveChanges();
}
/// <summary>
/// Executes code that will insert Invoiced Items into Movement.
/// </summary>
/// <param name="invoice"></param>
public void Credit_Items_Destination(item_transfer_detail item_transfer_detail, int ID_BranchOrigin, int ID_BranchDestination, bool MoveByTruck)
{
entity.Brillo.Logic.Stock stock = new Brillo.Logic.Stock();
app_currencyfx app_currencyfx = base.app_currencyfx.Where(x => x.app_currency.is_priority && x.is_active).FirstOrDefault();
app_location app_location_dest = base.app_location.Where(x => x.id_branch == ID_BranchDestination && x.is_default).FirstOrDefault();
if (MoveByTruck)
{
List <entity.Brillo.StockList> Items_InStockLIST;
entity.Brillo.Stock stockBrillo = new Brillo.Stock();
Items_InStockLIST = stockBrillo.MovementForTransfer(item_transfer_detail.id_transfer_detail, item_transfer_detail.id_item_product);
List <item_movement> item_movement_LIST = new List <entity.item_movement>();
///Discount From Destination. Because merchendice is returned to Origin, so it must be discounted from Destintation.
item_movement_LIST =
stock.DebitOnly_MovementLIST(this, Items_InStockLIST, Status.Stock.InStock, App.Names.Transfer, item_transfer_detail.id_transfer, item_transfer_detail.id_transfer_detail,
app_currencyfx, item_transfer_detail.item_product, app_location_dest, item_transfer_detail.quantity_destination,
item_transfer_detail.item_transfer.trans_date, stock.comment_Generator(App.Names.Transfer, item_transfer_detail.item_transfer.number != null ? item_transfer_detail.item_transfer.number.ToString() : "", ""));
base.item_movement.AddRange(item_movement_LIST);
app_location app_location_origin = base.app_location.Where(x => x.id_branch == ID_BranchOrigin && x.is_default).FirstOrDefault();
//Credit in Origin only if it is MoveByTruck.
item_movement item_movement_origin;
item_movement_origin =
stock.CreditOnly_Movement(
Status.Stock.InStock,
App.Names.Transfer,
item_transfer_detail.id_transfer,
item_transfer_detail.id_transfer_detail,
app_currencyfx,
item_transfer_detail.item_product,
app_location_origin,
item_transfer_detail.quantity_destination,
item_transfer_detail.item_transfer.trans_date,
0,
stock.comment_Generator(App.Names.Transfer, item_transfer_detail.item_transfer.number != null ? item_transfer_detail.item_transfer.number.ToString() : "", ""),
null
);
base.item_movement.Add(item_movement_origin);
}
else
{
//Credit Destination.
item_movement item_movement_dest;
List <item_movement> Items_InStockLIST = base.item_movement.Where(x => x.id_transfer_detail == item_transfer_detail.id_transfer_detail &&
x.id_item_product == item_transfer_detail.id_item_product && x.debit > 0).ToList();
int count = 1;
if (Items_InStockLIST.Count() > 0)
{
count = Items_InStockLIST.Count();
}
item_movement parent_item_movement = Items_InStockLIST.FirstOrDefault();
item_movement_dest =
stock.CreditOnly_Movement(
Status.Stock.InStock,
App.Names.Transfer,
item_transfer_detail.id_transfer,
item_transfer_detail.id_transfer_detail,
app_currencyfx,
item_transfer_detail.item_product,
app_location_dest,
item_transfer_detail.quantity_destination,
item_transfer_detail.item_transfer.trans_date,
Items_InStockLIST.Sum(x => (x.item_movement_value.Sum(y => y.unit_value) / (x.item_movement_value.Count() != 0 ? x.item_movement_value.Count() : 1))) / count,
stock.comment_Generator(App.Names.Transfer, item_transfer_detail.item_transfer.number != null ? item_transfer_detail.item_transfer.number.ToString() : "", ""),
null
);
item_movement_dest._parent = Items_InStockLIST.FirstOrDefault();
base.item_movement.Add(item_movement_dest);
}
}
