//Inte färdigt
public bool CreateService(
int type,
int creatorId,
int serviceStatusId,
string picture,
string title,
string description,
double price,
DateTime?startDate,
DateTime?endDate,
bool timeNeeded,
int subCategoryId
)
{
DateTime createdTime = DateTime.Now;
ServiceData serviceData = new ServiceData(type, subCategoryId, creatorId, serviceStatusId, picture, createdTime, title, description, price, startDate, endDate, timeNeeded);
using (ServiceDBModel db = new ServiceDBModel())
{
try
{
db.ServiceData.Add(serviceData);
db.SaveChanges();
return(true);
}
catch (Exception)
{
Log.Error("Error");
return(false);
}
}
}
public bool ChangeContractStatus(int serviceId, int counterpartId, int serviceOwnerId, int?serviceOwnerStatus, int?counterpartStatus)
{
using (ServiceDBModel db = new ServiceDBModel())
try
{
ContractData acceptingContract = db.ContractData
.Where(item =>
(
item.ServiceId == serviceId &&
item.CounterpartId == counterpartId &&
item.ServiceOwnerId == serviceOwnerId
))
.FirstOrDefault();
if (serviceOwnerStatus != null)
{
acceptingContract.ServiceOwnerStatus = serviceOwnerStatus.GetValueOrDefault();
}
if (counterpartStatus != null)
{
acceptingContract.CounterpartStatus = counterpartStatus.GetValueOrDefault();
}
db.SaveChanges();
return(true);
}
catch (Exception)
{
Log.Error("Error");
return(false);
}
}
public List <Service> AdvancedSearch(DateRange createdTime, DateRange startDate, DateRange endDate, int creatorId, string title, string description, PriceRange price,
int serviceStatusId, List <int> serviceTypeIds, List <int> subCategoryIds)
{
SearchService searchService = new SearchService();
searchService.CreatedTime = createdTime;
searchService.StartDate = startDate;
searchService.EndDate = endDate;
searchService.CreatorID = creatorId;
searchService.Title = title;
searchService.Description = description;
searchService.Price = price;
searchService.ServiceStatusId = serviceStatusId;
searchService.ServiceTypeIds = serviceTypeIds;
searchService.SubCategoryIds = subCategoryIds;
List <Service> output = new List <Service>();
using (ServiceDBModel db = new ServiceDBModel())
{
Searcher searcher = new Searcher();
var searchResults = db.ServiceData
.ToList()
.Where(item => searcher.ObjectSearch(item, searchService))
.ToList();
output = ServiceDataListToServiceList(searchResults);
}
return(output);
}
public Service GetServiceById(int id)
{
using (ServiceDBModel db = new ServiceDBModel())
{
var serviceData = db.ServiceData
.ToList()
.Where(item => item.Id == id)
.ToList();
if (serviceData.Count == 1)
{
Service output = ServiceDataObjectToService(serviceData[0]);
if (serviceData == null)
{
return(null);
}
return(output);
}
else
{
return(null);
}
}
}
public List <Contract> GetAllContract()
{
using (ServiceDBModel db = new ServiceDBModel())
{
var contract = db.ContractData;
List <Contract> output = new List <Contract>();
output = ContractDataListToServiceList(contract.ToList());
return(output);
}
}
public List <ServiceStatusType> GetServiceStatusTypes()
{
List <ServiceStatusType> serviceStatuses = new List <ServiceStatusType>();
using (ServiceDBModel db = new ServiceDBModel())
{
List <ServiceStatusTypeData> temp = db.ServiceStatusTypeData.ToList();
foreach (ServiceStatusTypeData item in temp)
{
serviceStatuses.Add(new ServiceStatusType(item));
}
}
return(serviceStatuses);
}
public List <SubCategory> GetSubCategories()
{
List <SubCategory> subCategories = new List <SubCategory>();
using (ServiceDBModel db = new ServiceDBModel())
{
List <SubCategoryData> temp = db.SubCategoryData.ToList();
foreach (SubCategoryData item in temp)
{
subCategories.Add(new SubCategory(item));
}
}
return(subCategories);
}
public List <ContractStatus> GetContractStatusType()
{
List <ContractStatus> contractStatuses = new List <ContractStatus>();
using (ServiceDBModel db = new ServiceDBModel())
{
List <ContractStatusTypeData> temp = db.ContractStatusTypeData.ToList();
foreach (ContractStatusTypeData contractStatus in temp)
{
contractStatuses.Add(new ContractStatus(contractStatus));
}
}
return(contractStatuses);
}
public List <Category> GetCategories()
{
List <Category> categories = new List <Category>();
using (ServiceDBModel db = new ServiceDBModel())
{
List <CategoryData> temp = db.CategoryData.ToList();
foreach (CategoryData item in temp)
{
categories.Add(new Category(item));
}
}
return(categories);
}
/**
* Laddar in alla servicar och returnerar dem
*/
List <Service> IService1.LoadServices() // TODO: Ta bort?
{
List <Service> output = new List <Service>();
using (ServiceDBModel db = new ServiceDBModel())
{
var services = db.ServiceData.ToList();
foreach (var service in services)
{
Service tempService = new Service(service);
output.Add(tempService);
}
return(output);
}
}
public List <Service> GetAllServiceData()
{
using (ServiceDBModel db = new ServiceDBModel())
{
var services = db.ServiceData
.Include(s => s.ServiceModificationsData)
.Include(s => s.ServiceStatusData)
.Include(s => s.ServiceTypeData)
.Include(s => s.SubCategoryData).ToList();
List <Service> output = new List <Service>();
output = ServiceDataListToServiceList(services);
return(output);
}
}
public bool DeleteCategory(int id)
{
using (ServiceDBModel db = new ServiceDBModel())
{
try
{
CategoryData categoryToRemove = db.CategoryData.Find(id);
db.CategoryData.Remove(categoryToRemove);
db.SaveChanges();
return(true);
}
catch (Exception)
{
Log.Error("Error");
return(false);
}
}
}
public bool DeleteService(int id)
{
using (ServiceDBModel db = new ServiceDBModel())
{
try
{
ServiceData foundService = db.ServiceData.Find(id);
db.ServiceData.Remove(foundService);
db.SaveChanges();
return(true);
}
catch (Exception)
{
Log.Error("Error");
return(false);
}
}
}
public bool EditCategory(int id, string title)
{
using (ServiceDBModel db = new ServiceDBModel())
{
try
{
CategoryData categoryData = db.CategoryData.Find(id);
categoryData.Titel = title;
db.SaveChanges();
return(true);
}
catch (Exception)
{
Log.Error("Error");
return(false);
}
}
}
public bool CreateCategory(string title)
{
using (ServiceDBModel db = new ServiceDBModel())
{
try
{
CategoryData categoryData = new CategoryData();
categoryData.Titel = title;
db.CategoryData.Add(categoryData);
db.SaveChanges();
return(true);
}
catch (Exception)
{
Log.Error("Error");
return(false);
}
}
}
public bool CreateSubCategory(int parentId, string title)
{
using (ServiceDBModel db = new ServiceDBModel())
{
try
{
SubCategoryData subCategoryData = new SubCategoryData();
subCategoryData.Parent = parentId;
subCategoryData.Titel = title;
db.SubCategoryData.Add(subCategoryData);
db.SaveChanges();
return(true);
}
catch (Exception)
{
Log.Error("Error");
return(false);
}
}
}
public Contract GetContract(int serviceId, int counterpartId, int serviceOwnerId)
{
using (ServiceDBModel db = new ServiceDBModel())
try
{
ContractData getContract = db.ContractData.Where(item =>
(
item.ServiceId == serviceId &&
item.CounterpartId == counterpartId &&
item.CounterpartId == counterpartId
))
.FirstOrDefault();
return(new Contract(getContract));
}
catch (Exception)
{
Log.Error("Error");
return(null);
}
}
public bool CreateContract(int serviceId, int counterpartId, int serviceOwnerId, int contractCreatorId)
{
int serviceOwnerStatus = 0;
int counterpartStatus = 0;
if (serviceOwnerId == contractCreatorId)
{
serviceOwnerStatus = 1;
}
else if (counterpartId == contractCreatorId)
{
counterpartStatus = 1;
}
else if (counterpartId != contractCreatorId && serviceOwnerId != contractCreatorId)
{
return(false);
}
using (ServiceDBModel db = new ServiceDBModel())
{
try
{
ContractData creatingContract = new ContractData();
creatingContract.ServiceId = serviceId;
creatingContract.ServiceOwnerId = serviceOwnerId;
creatingContract.CounterpartId = counterpartId;
creatingContract.CounterpartStatus = counterpartStatus;
creatingContract.ServiceOwnerStatus = serviceOwnerStatus;
db.ContractData.Add(creatingContract);
db.SaveChanges();
return(true);
}
catch (Exception)
{
Log.Error("Error");
return(false);
}
}
}
public bool EditService(
int id,
int type,
int serviceStatusId,
string picture,
string title,
string description,
double price,
DateTime?startDate,
DateTime?endDate,
bool timeNeeded,
int subCategoryId)
{
using (ServiceDBModel db = new ServiceDBModel())
{
try
{
ServiceData foundService = db.ServiceData.Find(id);
foundService.Type = type;
foundService.ServiceStatusID = serviceStatusId;
foundService.Picture = picture;
foundService.Title = title;
foundService.Description = description;
foundService.Price = price;
foundService.StartDate = startDate;
foundService.EndDate = endDate;
foundService.TimeNeeded = timeNeeded;
foundService.Category = subCategoryId;
db.SaveChanges();
return(true);
}
catch (Exception)
{
Log.Error("Error");
return(false);
}
}
}
public bool DeleteContract(int serviceId, int counterpartId, int serviceOwnerId)
{
using (ServiceDBModel db = new ServiceDBModel())
try
{
ContractData deleteContract = db.ContractData.Where(item =>
(
item.ServiceId == serviceId &&
item.CounterpartId == counterpartId &&
item.ServiceOwnerId == serviceOwnerId
))
.FirstOrDefault();
db.ContractData.Remove(deleteContract);
db.SaveChanges();
return(true);
}
catch (Exception)
{
Log.Error("Error");
return(false);
}
}
public List <Service> Search(string searchString)
{
List <Service> output = new List <Service>();
if (!String.IsNullOrEmpty(searchString))
{
using (ServiceDBModel db = new ServiceDBModel())
{
Searcher searcher = new Searcher();
var searchResults = db.ServiceData
.ToList()
.Where(item =>
{
return(searcher.
SearchInDatabase(item.Title, item.Description, item.SubCategoryData.Titel, item.SubCategoryData.CategoryData.Titel, searchString));
}).ToList();
output = ServiceDataListToServiceList(searchResults);
return(output);
}
}
return(output);
}