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