public IEnumerable <ViewSupplier> ListViewSupByCityName(string cityName) { using (var cmd = _con.CreateCommand()) { cmd.CommandText = "select SupplierName, SupplierICity from Supplier where SupplierICity like @cityName"; SqlParameter parameter = new SqlParameter() { Value = cityName, ParameterName = "@cityName" }; cmd.Parameters.Add(parameter); using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { ViewSupplier sprod = new ViewSupplier(); sprod.SupplierName = reader["SupplierName"].ToString(); sprod.SupplierCity = reader["SupplierICity"].ToString(); yield return(sprod); } } } }
public MemoryView() { InitializeComponent(); Supplier = new ViewSupplier <MemoryViewContext>(ViewSelect); FrameList.SelectionChanged += FrameList_SelectionChanged; }
public MessageView() { InitializeComponent(); Supplier = new ViewSupplier <Messenger>(ViewSelect); Supplier.AllowNoSelection = true; ShowTypeIDColumn.IsChecked = false; TypeIDColumn.Visibility = Visibility.Collapsed; ShowTypeIDColumn.Click += (sender, e) => { TypeIDColumn.Visibility = (ShowTypeIDColumn.IsChecked ?? false) ? Visibility.Visible : Visibility.Collapsed; }; }
public ActionResult VisitDetails(int id) { @ViewBag.YesNo = new List <string>() { "Brak danych", "Tak", "Nie", "Nie dotyczy" }; var visitDetails = new VisitDetailsViewModel(); @ViewBag.Provinces = context.Provinces.ToList(); @ViewBag.Districts = context.Districts.ToList(); var visit = context.Visits.SingleOrDefault(v => v.Id == id); if (visit == null) { return(HttpNotFound()); } var data = context.BusinessDatas.Single(d => d.BusinessId == visit.BusinessId); visitDetails.Data = Utils.ClientData.GetClientDetails(data, context); var step1 = context.ClientSteps1.OrderByDescending(c => c.Id).FirstOrDefault(c => c.VisitId == id); var step2 = context.ClientSteps2.Include(s => s.Assortment).Include(s => s.Assortment.Package).Include(s => s.Assortment.PartOfCement).OrderByDescending(c => c.Id).FirstOrDefault(c => c.VisitId == id); var step3 = context.ClientSteps3.Include(s => s.Manufacturers).Include(s => s.ManufacturersGroups).Include(s => s.Suppliers).OrderByDescending(c => c.Id).FirstOrDefault(c => c.VisitId == id); var step3_5 = context.ClientSteps3_5.Include(s => s.Distributors).Include(s => s.Manufacturers).Include(s => s.ManufacturersGroups).OrderByDescending(c => c.Id).FirstOrDefault(c => c.VisitId == id); var step4 = context.ClientSteps4.OrderByDescending(c => c.Id).FirstOrDefault(c => c.VisitId == id); var step5 = context.ClientSteps5.OrderByDescending(c => c.Id).FirstOrDefault(c => c.VisitId == id); var step7 = context.ClientSteps7.Include(s => s.LaxTypes).Include(s => s.PackedTypes).OrderByDescending(c => c.Id).FirstOrDefault(c => c.VisitId == id); visitDetails.VisitId = visit.Id; visitDetails.MainMarketSegment = context.MarketSegments.SingleOrDefault(m => m.Id == visit.MainMarketSegmentId).Name; visitDetails.VisitDate = visit.VisitDate.ToString("yyyy-MM-dd"); visitDetails.VisitComments = visit.Comments; if (step1 != null) { foreach (var ms in step1.VisitMarketSegments) { if (ms.MarketSegmentId != 0) { ms.MarketSegment = context.MarketSegments.Single(s => s.Id == ms.MarketSegmentId); } } visitDetails.MarketSegments = step1.VisitMarketSegments; visitDetails.Branches = step1.Branches; } if (step2 != null) { visitDetails.Assortment = step2.Assortment; if (step2.LaxTypes != null) { foreach (VisitLaxType t in step2.LaxTypes) { if (t.Id != 0) { t.LaxType = context.LaxCementTypes.Single(p => p.Id == t.LaxTypeId); } } visitDetails.VisitLaxTypes = step2.LaxTypes; } if (step2.PackedTypes != null) { foreach (VisitPackedType t in step2.PackedTypes) { if (t.PackedTypeId != 0) { t.PackedType = context.PackedCementTypes.Single(p => p.Id == t.PackedTypeId); } } visitDetails.VisitPackedTypes = step2.PackedTypes; } } if (step4 != null) { visitDetails.Logistic = step4.Logistic; visitDetails.UnloadTypes = new List <string>(); foreach (VisitUnloadType t in step4.UnloadTypes) { if (t.UnloadTypeId != 0) { var type = context.UnloadTypes.Single(u => u.Id == t.UnloadTypeId).Name; visitDetails.UnloadTypes.Add(type); } } } if (step5 != null) { visitDetails.Clients = new List <KeyValuePair <string, int> >(); foreach (VisitClients c in step5.Clients) { if (c.ClientId != 0) { var client = context.Clients.Single(v => v.Id == c.ClientId); var cl = new KeyValuePair <string, int>(client.Name, c.Percent); visitDetails.Clients.Add(cl); } } } if (step7 != null) { visitDetails.LaxPrices = new List <ViewPrice>(); if (step7.LaxTypes != null) { foreach (ClientLax c in step7.LaxTypes) { var price = new ViewPrice(); price.Buy = c.BuyPrice; price.Sell = c.SellPrice; if (c.PriceType == 1) { price.Type = "Brak danych"; } if (c.PriceType == 2) { price.Type = "Loco"; } if (c.PriceType == 3) { price.Type = "Franco"; } if (c.CementId != 0) { price.Name = context.LaxCementTypes.Single(t => t.Id == c.CementId).Name; } visitDetails.LaxPrices.Add(price); } } visitDetails.PackedPrices = new List <ViewPrice>(); if (step7.PackedTypes != null) { foreach (ClientPacked c in step7.PackedTypes) { var price = new ViewPrice(); price.Buy = c.BuyPrice; price.Sell = c.SellPrice; if (c.PriceType == 1) { price.Type = "Brak danych"; } if (c.PriceType == 2) { price.Type = "Loco"; } if (c.PriceType == 3) { price.Type = "Franco"; } if (c.CementId != 0) { price.Name = context.PackedCementTypes.Single(t => t.Id == c.CementId).Name; } visitDetails.PackedPrices.Add(price); } } } if (step3 != null) { visitDetails.Cooperation = step3.Cooperation; visitDetails.Suppliers = new List <ViewSupplier>(); if (step3.Suppliers != null && step3.Cooperation) { foreach (VisitSupplier s in step3.Suppliers) { var sup = new ViewSupplier(); if (s.SupplierId != 0) { sup.Name = context.Suppliers.Single(ss => ss.Id == s.SupplierId).Name; } sup.Text = s.Text; visitDetails.Suppliers.Add(sup); } } visitDetails.Step3Manufs = new List <ViewManufacturer>(); if (step3.Manufacturers != null) { foreach (VisitManufacturers s in step3.Manufacturers) { if (s.GroupId == 0) { var sup = new ViewManufacturer(); if (s.ManufacturerId != 0) { sup.Name = context.Manufacturers.Single(ss => ss.Id == s.ManufacturerId).Name; } sup.Percent = s.Percent; visitDetails.Step3Manufs.Add(sup); } } } visitDetails.Step3ManufsGroups = new List <ViewManGroup>(); if (step3.ManufacturersGroups != null) { foreach (VisitManufacturersGroup g in step3.ManufacturersGroups) { var gr = new ViewManGroup(); if (g.ManufacturersGroupId != 0) { gr.Name = context.ManufacturersGroups.Single(a => a.Id == g.ManufacturersGroupId).Name; } gr.Percent = step3.Manufacturers.Any(m => m.GroupId == g.ManufacturersGroupId) ? 0 : g.Percent; gr.Manufacturers = new List <ViewManufacturer>(); foreach (VisitManufacturers s in step3.Manufacturers) { if (s.GroupId == g.ManufacturersGroupId) { var sup = new ViewManufacturer(); if (s.ManufacturerId != 0) { sup.Name = context.Manufacturers.Single(ss => ss.Id == s.ManufacturerId).Name; } sup.Percent = s.Percent; gr.Percent += s.Percent; gr.Manufacturers.Add(sup); } } visitDetails.Step3ManufsGroups.Add(gr); } } } if (step3_5 != null) { if (step3_5.ReceiptId != 0) { visitDetails.RecType = context.Receipts.Single(r => r.Id == step3_5.ReceiptId).Name; } visitDetails.Manufs = new List <ViewManufacturer>(); if (step3_5.Manufacturers != null) { foreach (VisitManufacturers s in step3_5.Manufacturers) { if (s.GroupId == 0) { var sup = new ViewManufacturer(); if (s.ManufacturerId != 0) { sup.Name = context.Manufacturers.Single(ss => ss.Id == s.ManufacturerId).Name; } sup.Percent = s.Percent; visitDetails.Manufs.Add(sup); } } } visitDetails.ManGroups = new List <ViewManGroup>(); if (step3_5.ManufacturersGroups != null) { foreach (VisitManufacturersGroup g in step3_5.ManufacturersGroups) { var gr = new ViewManGroup(); if (g.ManufacturersGroupId != 0) { gr.Name = context.ManufacturersGroups.Single(a => a.Id == g.ManufacturersGroupId).Name; } gr.Percent = g.Percent; gr.Manufacturers = new List <ViewManufacturer>(); foreach (VisitManufacturers s in step3_5.Manufacturers) { if (s.GroupId == g.ManufacturersGroupId) { var sup = new ViewManufacturer(); if (s.ManufacturerId != 0) { sup.Name = context.Manufacturers.Single(ss => ss.Id == s.ManufacturerId).Name; } sup.Percent = s.Percent; gr.Manufacturers.Add(sup); } } visitDetails.ManGroups.Add(gr); } } if (step3_5.Distributors != null) { visitDetails.Distributors = new List <DistributorViewModel>(); foreach (VisitDistributor d in step3_5.Distributors) { var dist = new DistributorViewModel(); dist.IsMarket = false; if (d.DistributorId != 0) { var dd = context.Distributors.Single(dis => dis.Id == d.DistributorId); dist.Name = dd.Name; dist.IsMarket = dd.IsMarket; if (dd.IsMarket && d.MarketAddressId != null && d.MarketAddressId > 0) { dist.Address = d.MarketAddress; } } dist.Percent = d.Percent; if (d.Manufacturers != null) { dist.Manufacturers = new List <ViewManufacturer>(); foreach (VisitDistManufacturer m in d.Manufacturers) { var man = new ViewManufacturer(); if (m.ManufacturerId != 0) { man.Name = context.Manufacturers.Single(mm => mm.Id == m.ManufacturerId).Name; } man.Percent = m.Percent; dist.Manufacturers.Add(man); } } if (d.ManufacturersGroups != null) { dist.Groups = new List <ViewManGroup>(); foreach (VisitDistManufacturersGroup g in d.ManufacturersGroups) { var gr = new ViewManGroup(); if (g.ManufacturersGroupId != 0) { gr.Name = context.ManufacturersGroups.Single(gg => gg.Id == g.ManufacturersGroupId).Name; } gr.Percent = g.Percent; if (g.Mans != null && g.Mans.Count > 0) { gr.Percent = 0; gr.Manufacturers = new List <ViewManufacturer>(); foreach (var gm in g.Mans) { var vm = new ViewManufacturer(); if (gm.ManufacturerId != 0) { vm.Name = context.Manufacturers.Single(mm => mm.Id == gm.ManufacturerId).Name; } vm.Percent = gm.Percent; gr.Percent += gm.Percent; gr.Manufacturers.Add(vm); } } dist.Groups.Add(gr); } } visitDetails.Distributors.Add(dist); } } } visitDetails.Step4 = step4; visitDetails.Step5 = step5; visitDetails.Step6 = context.ClientSteps6.OrderByDescending(c => c.Id).FirstOrDefault(c => c.VisitId == id); visitDetails.Step7 = step7; visitDetails.Step8 = context.ClientSteps8.OrderByDescending(c => c.Id).FirstOrDefault(c => c.VisitId == id); return(View(visitDetails)); }