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