private string ref_source(DateTime WorkingDate, AFN_INVENTARIO curr_fin_clp, DateTime PurchaseDate)
{
if (WorkingDate == PurchaseDate)
{
return(_ref_purchase);
}
else
{
if (curr_fin_clp.cod_estado == 1)
{
if (curr_fin_clp.ingresado_por.Contains("SALDO_INICIAL"))
{
return("MIG");
}
else
{
return("TRASPASO_MIG");
}
}
else if (curr_fin_clp.cod_estado == 2)
{
return(_ref_sales + "_MIG");
}
else
{
return(_ref_disposal + "_MIG");
}
}
}
public TRANSACTION_HEADER TRANSACTION_HEAD_NEW(SV_PART article_part, AFN_INVENTARIO source) //para migracion
{
DateTime PurchaseDate = (from a in _context.BATCHS_ARTICLES
join b in _context.PARTS on a.id equals b.article_id
where b.id == article_part.id
select a.purchase_date).First();
var head = new TRANSACTION_HEADER();
head.article_part_id = article_part.id;
head.head_index = GetNextHeadIndex(article_part.id);
head.trx_ini = source.fecha_inicio;
head.trx_end = (DateTime)source.fecha_fin;
head.ref_source = ref_source(source.fecha_inicio, source, PurchaseDate);
head.zone_id = zonas.ByCode(source.zona).id;
head.subzone_id = (int)source.subzona + 1;
head.kind_id = Clases.ByCode(source.clase).id;
head.subkind_id = subclases.ByCode(source.subclase).id;
head.category_id = categorias.ByCode(source.categoria).id;
head.user_own = source.ingresado_por;
head.method_revalue_id = 1;
int cGest;
if (Int32.TryParse(source.gestion.ToString(), out cGest))
{
head.manage_id = cGest;
}
else
{
head.manage_id = null;
}
_context.TRANSACTIONS_HEADERS.AddObject(head);
_context.SaveChanges();
if (head.id == 0)
{
_context.ObjectStateManager.ChangeObjectState(head, System.Data.EntityState.Added);
}
_load_transactions_headers();
return(head);
}
