public static List <OITM_Articles> GetGenericBranchArticles(OWHS_Branch branch)
{
lock (Extensions.Locker)
{
var db = ContextFactory.GetDBContext();
return
(branch.OITW_BranchArticles.Join(db.OITM_Articles,
ba => ba.ItemCode, a => a.ItemCode,
(ba, a) => new { branchArticle = ba, article = a })
.Select(obj => obj.article).ToList());
}
}
public static ObservableCollection <WTQ1_TransferRequestDetails> GetFilteredTransferRequestDetails(OWHS_Branch selectedBranchStore, OWTQ_TransferRequest transferRequest = null)
{
lock (Extensions.Locker)
{
var db = ContextFactory.GetDBContext();
//de la branch
var branchDetails = (
from t2 in db.OITW_BranchArticles // sucursal a la que se le pide
join t1 in db.OITW_BranchArticles on t2.ItemCode equals t1.ItemCode //sucursal que pide
join t0 in db.OITM_Articles on t2.ItemCode equals t0.ItemCode
join t3 in db.UCategories on t0.U_categoria equals t3.Code
join t4 in db.UWarehouseOrders on t3.Code equals t4.IdCategory
where !string.IsNullOrEmpty(t0.TemplateL) && t0.TemplateL.ToLower().Contains("y") && t4.Whscode == selectedBranchStore.WhsCode &&
t0.validFor.Contains("Y") && t1.Locked.Contains("N") && t2.Locked.Contains("N") && t0.InvntItem.Contains("Y") && //Todos los filtros de los articulos
t1.WhsCode == Config.WhsCode &&
t2.WhsCode == selectedBranchStore.WhsCode
select new
{
WhsCode = Config.WhsCode,
InvntryUom = t0.InvntryUom,
ItemCode = t2.ItemCode,
ItemName = t0.ItemName,
OnHand1 = t1.OnHand1 ?? 0,
Line = t3 != null ? t3.Name : string.Empty,
LineCode = t3 != null ? t3.Code : string.Empty,
Quantity = 0
}).ToList();
if (transferRequest.IdTransferRequestL > 0)
{
var collection = (from trd in branchDetails
join strd in transferRequest.WTQ1_TransferRequestDetails
on trd.ItemCode equals strd.ItemCode into jtrds
from jtrd in jtrds.DefaultIfEmpty()
select new
{
ItemCode = trd.ItemCode,
Quantity = jtrd != null ? jtrd.Quantity : trd.Quantity,
WhsCode = trd.WhsCode,
ItemName = trd.ItemName,
InvntryUom = trd.InvntryUom,
OnHand1 = trd.OnHand1,
Line = trd.Line,
LineCode = trd.LineCode,
CreatedDateL = jtrd != null ? jtrd.CreatedDateL : DateTime.Now,
CreatedByL = jtrd != null ? jtrd.CreatedByL : Config.CurrentUser,
ModifiedByL = jtrd != null ? jtrd.ModifiedByL : Config.CurrentUser,
ModifiedDateL = jtrd != null ? jtrd.ModifiedDateL : DateTime.Now,
}).ToList();
var savedDetils = collection.Select(v => new WTQ1_TransferRequestDetails()
{
ItemCode = v.ItemCode,
Quantity = v.Quantity,
WhsCode = v.WhsCode,
ItemName = v.ItemName,
InvntryUom = v.InvntryUom,
OnHand1 = v.OnHand1,
Line = v.Line,
LineCode = v.LineCode,
CreatedDateL = v.CreatedDateL,
CreatedByL = v.CreatedByL,
ModifiedByL = v.ModifiedByL,
ModifiedDateL = v.ModifiedDateL
}).ToList();
return(new ObservableCollection <WTQ1_TransferRequestDetails>(savedDetils));
}
var details = branchDetails.Select(v => new WTQ1_TransferRequestDetails()
{
InvntryUom = v.InvntryUom,
ItemCode = v.ItemCode,
ItemName = v.ItemName,
OnHand1 = v.OnHand1,
Line = v.Line,
LineCode = v.LineCode,
Quantity = v.Quantity
}).ToList();
return(new ObservableCollection <WTQ1_TransferRequestDetails>(details));
}
}
public static List <OITM_Articles> GetBranchArticles(OWHS_Branch branch)
{
var loop = branch.OITW_BranchArticles;
return(loop.Select(ba => ba.OITM_Articles).ToList());
}