private void GetCompanyData() { ServiceProviderData Data = new ServiceProviderData(); Data = Datahandler.QueryServiceProviderData(); ServiceProviderId = Data.Id; CompanyName = Data.CompanyName; Address = Data.Address; Zip = Data.Zip; City = Data.City; Phone = Data.Phone; CntCompletedOrders = Data.CntCompletedOrders; CntOpenOrders = Data.CntOpenOrders; SumTargetedSales = Data.SumTargetedSales; CntOpenOrdersThisMonth = Data.CntOpenOrdersThisMonth; CntUnconfirmedOrders = Data.CntUnconfirmedOrders; }
public bool UpdateServiceProviderData(ServiceProviderData ServiceProvider) { service_provider OrignialServiceProvider = (from sp in dbContext.service_provider where sp.Id == ServiceProvider.Id select sp).FirstOrDefault(); if (OrignialServiceProvider != null) { OrignialServiceProvider.address_1 = ServiceProvider.Address; OrignialServiceProvider.city = ServiceProvider.City; OrignialServiceProvider.createdAt = DateTime.Now; OrignialServiceProvider.phone_1 = ServiceProvider.Phone; OrignialServiceProvider.zip = ServiceProvider.Zip; dbContext.SaveChanges(); return(true); } return(false); }
private void UpdateCompanyData() { ServiceProviderData Data = new ServiceProviderData(); Data.Id = ServiceProviderId; Data.CompanyName = CompanyName; Data.Address = Address; Data.Zip = Zip; Data.City = City; Data.Phone = Phone; Data.CntCompletedOrders = CntCompletedOrders; Data.CntOpenOrders = CntOpenOrders; Data.SumTargetedSales = SumTargetedSales; if (Datahandler.UpdateServiceProviderData(Data)) { MessageBox.Show("Update erfolgreich ausgeführt."); } else { MessageBox.Show("Update fehlgeschlagen."); } }
public ServiceProviderData QueryServiceProviderData() { dbContext = new DbServiceProviderAppEntities(); //prüfen ob jemand und wenn ja, wer angemeldet ist DateTime LastGuiltyLogIn = DateTime.Now.AddHours(-4800); //ToDo: LastLogIn noch ändern!!! var CheckQuery = from li in dbContext.spa_log_in where li.last_login > LastGuiltyLogIn && li.is_logged_in == "Y" orderby li.last_login descending select li; if (CheckQuery.ToList().Count() == 1) { int UserId = CheckQuery.ToList()[0].user_id; //STAMMDATEN: var MasterDataQuery = from sp in dbContext.service_provider where sp.Id == UserId select new ServiceProviderData { Id = sp.Id, CompanyName = sp.company_name, Address = sp.address_1, City = sp.city, Zip = sp.zip, Phone = sp.phone_1 }; ServiceProviderData RetVal = MasterDataQuery.FirstOrDefault(); //ABGESCHLOSSENE AUFTRÄGE: var CntCompletedOrdersQuery = from oi in dbContext.order_item join s in dbContext.service on oi.service_id equals s.Id join sp in dbContext.service_provider on s.service_provider_id equals sp.Id where sp.Id == UserId && oi.is_finished == "Y" && oi.is_confirmed == "Y" select oi; RetVal.CntCompletedOrders = CntCompletedOrdersQuery.ToList().Count(); //OFFENE AUFTRÄGE: var CntOpenOrdersQuery = from oi in dbContext.order_item join s in dbContext.service on oi.service_id equals s.Id join sp in dbContext.service_provider on s.service_provider_id equals sp.Id where sp.Id == UserId && oi.is_finished == "N" && oi.is_confirmed == "Y" select oi; RetVal.CntOpenOrders = CntOpenOrdersQuery.ToList().Count(); //LUKRIERTER UMSATZ double SumTargetedSales = 0; foreach (var orderitem in CntCompletedOrdersQuery.ToList()) { SumTargetedSales += orderitem.final_price_with_tax; } RetVal.SumTargetedSales = SumTargetedSales; //Unbestätigte Aufträge var CntUnconfirmedOrdersQuery = from oi in dbContext.order_item join s in dbContext.service on oi.service_id equals s.Id join sp in dbContext.service_provider on s.service_provider_id equals sp.Id where sp.Id == UserId && (oi.is_confirmed == "N" || oi.is_confirmed == null) select oi; RetVal.CntUnconfirmedOrders = CntUnconfirmedOrdersQuery.ToList().Count(); //angenommene Aufträge diese Woche int ThisMonth = DateTime.Now.Month; var CntOpenOrdersThisMonthQuery = from oi in dbContext.order_item join s in dbContext.service on oi.service_id equals s.Id join sp in dbContext.service_provider on s.service_provider_id equals sp.Id where sp.Id == UserId && oi.is_finished == "N" && oi.is_confirmed == "Y" && oi.preferred_date_time.Month == ThisMonth select oi; RetVal.CntOpenOrdersThisMonth = CntOpenOrdersThisMonthQuery.ToList().Count(); return(RetVal); } return(null); }