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));
}
