public List <ViewCountPlanDetailItem> GetByPlanAndProduct(int plan, string product)
{
List <ViewCountPlanDetailItem> items = new List <ViewCountPlanDetailItem>();
var details = new ViewCountPlanDetailItem();
var qry = "SELECT CP.Id, CP.CountPlanId, CP.UserCode, CP.DateCreated, CP.Quantity, CP.ProductCode, CP.Count, PR.Description ";
qry += " FROM countPlanDetailItem CP INNER JOIN ";
qry += " Product PR ON CP.ProductCode = PR.Code";
qry += " WHERE CP.CountPlanId = '" + plan + "' AND CP.ProductCode = '" + product + "'";
var list = context.Database.SqlQuery <ViewCountPlanDetailItem>(qry).ToList();
if (!list.Any())
{
list = new List <ViewCountPlanDetailItem>();
//var existProductAndPlan = context.CountPlanDetails.Any(a => a.CountPlanId == plan && a.ProductCode == product);
var descriptionProduct = (from cpd in context.CountPlanDetails
join pro in context.Products on cpd.ProductCode equals pro.Code
where cpd.CountPlanId == plan && cpd.ProductCode == product
select new
{
_DescriptionProduct = pro.Description
}).FirstOrDefault();
//context.Products.FirstOrDefault(a => a.Code == product);
if (descriptionProduct != null)
{
list.Add(new ViewCountPlanDetailItem()
{
CountPlanId = plan,
ProductCode = product,
Quantity = 0,
Description = descriptionProduct._DescriptionProduct
});
}
else
{
list = null;
}
}
return(list);
}
private void AddItem()
{
var details = new ViewCountPlanDetailItem();
details.CountPlanId = PlanId;
details.UserCode = User;
details.DateCreated = DateTime.Now.ToString("dd/MM/yyyy hh:mm");
details.Quantity = AddQuantity;
details.ProductCode = ProductCode;
details.Count = LastRowCount + 1;
CountProduct = CountProduct + AddQuantity;
NewDetails.Add(details);
int countItemsDetail = _details.Count == 0 ? 1 : _details.Count;
if (Details.Count == 1)
{
HeightList = (countItemsDetail * 60) + (countItemsDetail * 15);
}
else
{
HeightList = (countItemsDetail * 40) + (countItemsDetail * 12);
}
//HeightList = (countItemsDetail*40) + (countItemsDetail*10);
Details.Add(details);
//else
//{
// await App.Current.MainPage.DisplayAlert("TSHIRT - Error", "Ingrese un valor Númerico", "OK");
//}
AddQuantity = 0;
App.Current.MainPage.Navigation.NavigationStack.Last().FindByName <Entry>("EntrQuantity").Focus();
}
