public ObservableCollection <CustomerData> GetSalesManCustomerList(int SalesManId) { using (var db = new AppSalesMan2DbContext()) { var customerDatas = CustomerDatas.Where(x => x.SalesManID == SalesManId); foreach (var item in customerDatas) { CustomerList.Add(new CustomerData() { CompanyID = item.CompanyID, Name = item.Name, SAP = item.SAP, Industry = item.Industry, Logistic = item.Logistic, IFA = item.IFA, Postcode = item.Postcode, City = item.City, SalesManID = item.SalesManID, RequestForChange = item.RequestForChange }); } } return(CustomerList); }
public ObservableCollection <CustomerData> GetAllCustomerList() { using (var db = new AppSalesMan2DbContext()) { var AllCustomer = CustomerDatas; foreach (var item in AllCustomer) { AllCustomers.Add(new CustomerData() { CompanyID = item.CompanyID, Name = item.Name, SAP = item.SAP, Industry = item.Industry, Logistic = item.Logistic, IFA = item.IFA, Postcode = item.Postcode, City = item.City, SalesManID = item.SalesManID, RequestForChange = item.RequestForChange }); } } return(AllCustomers); }
public ObservableCollection <CustomersVolumenData> GetCustomerVolumen(int SalesManId) { ObservableCollection <CustomersVolumenData> VolumenData = new ObservableCollection <CustomersVolumenData>(); using (var db = new AppSalesMan2DbContext()) { var CustomerVolumen = CustomerDatas.Where(x => x.SalesManId == SalesManId); foreach (var item in CustomerVolumen) { VolumenData.Add(new CustomersVolumenData() { Year = item.Year, Month = item.Month, // SAP = item.SAP, CustomerId = item.CustomerId, CustomerName = item.CustomerName, BV = item.BV, OI = item.OI, Rev = item.Rev, }); } } return(VolumenData); }
protected override void OnStartup(StartupEventArgs e) { base.OnStartup(e); using var dbContext = new AppSalesMan2DbContext(); dbContext.Database.EnsureCreated(); }
public void AddRequest(ChangeRequestData Request) { using (var db = new AppSalesMan2DbContext()) { changeRequests.Add(Request); SaveChanges(); } }
public SalesMansData GetSalesMans(string FirstName, string LastName, string Password) { using (var db = new AppSalesMan2DbContext()) { var salesman = SalesMansDatas.Single(x => x.FirstName == FirstName & x.LastName == LastName & x.Password == Password); return(salesman); } }
public PlansData GetSalesManPlans(int Id) { using (var db = new AppSalesMan2DbContext()) { var Plans = PlansDatas.Single(x => x.SalesManId == Id); return(Plans); } }
public void ChangeRequest(CustomerData customerData) { using (var db = new AppSalesMan2DbContext()) { var Request = CustomerDatas.Where(x => x.CompanyID == customerData.CompanyID).FirstOrDefault(); Request.RequestForChange = true; SaveChanges(); } }
public double GetCumulatedVolumen(int SalesManID) { using (var db = new AppSalesMan2DbContext()) { var WonOpp = wonOppDatas.Where(x => x.SalesManId == SalesManID); foreach (var item in WonOpp) { if (item.Accepted == true) { CumulatedVolumen += item.WonOppVolumen; } } } return(CumulatedVolumen); }
public ObservableCollection <IndirectData> GetIndirectYearAndQuater(int SalesManId, int Year, int Quater) { using (var db = new AppSalesMan2DbContext()) { var Indirect = IndirectDatas.Where(x => x.SalesManId == SalesManId && x.Year == Year && x.Quarter == Quater); foreach (var item in Indirect) { IndirectVolumenPerQuarter.Add(new IndirectData() { DystrCustomer = item.DystrCustomer, Volumen = item.Volumen }); } } return(IndirectVolumenPerQuarter); }
public ObservableCollection <IndirectData> GetAllInDirect(int SalesManId, int Year) { using (var db = new AppSalesMan2DbContext()) { var Indirect = IndirectDatas.Where(x => x.SalesManId == SalesManId && x.Year == Year); foreach (var item in Indirect) { IndirectVolumenAll.Add(new IndirectData() { DystrCustomer = item.DystrCustomer, Volumen = item.Volumen, Quarter = item.Quarter }); } } return(IndirectVolumenAll); }
public ObservableCollection <ChangeRequestData> GetRequstList(int SalesManId) { using (var db = new AppSalesMan2DbContext()) { var List = changeRequests.Where(x => x.SalesManId == SalesManId); foreach (var item in List) { RequestList.Add(new ChangeRequestData() { CompanyID = item.CompanyID, Parameter = item.Parameter, NewParameter = item.NewParameter, Status = item.Status }); } } return(RequestList); }
public void UpdateData(SalesMansData salesMansData) { using (var db = new AppSalesMan2DbContext()) { var FoundSalesMan = SalesMansDatas.Where(x => x.SalesManID == salesMansData.SalesManID).FirstOrDefault(); if (FoundSalesMan == null) { return; } #region Mapowanie na SalesManData FoundSalesMan.FirstName = salesMansData.FirstName; FoundSalesMan.LastName = salesMansData.LastName; FoundSalesMan.Email = salesMansData.Email; FoundSalesMan.Department = salesMansData.Department; FoundSalesMan.Menager = salesMansData.Menager; FoundSalesMan.Phonenumber = salesMansData.Phonenumber; FoundSalesMan.Password = salesMansData.Password; #endregion SaveChanges(); } }
public ObservableCollection <WonOppData> GetWonOppData(int SalesManID) { ObservableCollection <WonOppData> wonOppData = new ObservableCollection <WonOppData>(); using (var db = new AppSalesMan2DbContext()) { var WonOpp = wonOppDatas.Where(x => x.SalesManId == SalesManID); foreach (var item in WonOpp) { wonOppData.Add(new WonOppData() { WonOppId = item.WonOppId, SalesManId = item.SalesManId, WonOppName = item.WonOppName, WonOppEndCustomer = item.WonOppEndCustomer, EstimatedOIDate = item.EstimatedOIDate, WonOppVolumen = item.WonOppVolumen, Accepted = item.Accepted }); } } return(wonOppData); }