public static List <DataModels.ClientProfile> GetClientProfileById(int id, bool withCarsFollowed)
{
var db = new ITAPPCarWorkshopServiceDBEntities();
if (withCarsFollowed)
{
ClientProfile clientProfile;
var ListCarsFollowed = new List <DataModels.CarProfileModel>();
mutex.WaitOne();
clientProfile = new ClientProfile(db.Client_Profiles.FirstOrDefault(n => n.Client_ID == id));
foreach (Cars_followed Car in db.Cars_followed.Where(car => car.Client_ID == id))
{
ListCarsFollowed.Add(new CarProfileModel(Car.Car_Profiles));
}
mutex.ReleaseMutex();
clientProfile.CarsFollowedByClient = ListCarsFollowed;
var list = new List <ClientProfile>();
list.Add(clientProfile);
return(list);
}
else
{
ClientProfile clientProfile;
mutex.WaitOne();
clientProfile = new ClientProfile(db.Client_Profiles.FirstOrDefault(n => n.Client_ID == id));
mutex.ReleaseMutex();
var list = new List <ClientProfile>();
list.Add(clientProfile);
return(list);
}
}
public static bool DeleteClientProfileFromDB(int ClientProfileID)
{
var db = new ITAPPCarWorkshopServiceDBEntities();
bool profileExists = false;
mutex.WaitOne();
if (!CheckIfClientProfileExists(ClientProfileID))
{
profileExists = false;
mutex.ReleaseMutex();
return(profileExists);
}
try
{
Client_Profiles ClientProfileEntity = db.Client_Profiles.FirstOrDefault(n => n.Client_ID == ClientProfileID);
db.Client_Profiles.Remove(ClientProfileEntity);
db.SaveChanges();
mutex.ReleaseMutex();
return(true);
}
catch (Exception e)
{
mutex.ReleaseMutex();
return(false);
}
}
public static bool ModifyExistingClientProfile(DataModels.ClientProfile ClientProfileModel)
{
var db = new ITAPPCarWorkshopServiceDBEntities();
bool profileExists = false;
mutex.WaitOne();
if (!CheckIfClientProfileExists(ClientProfileModel))
{
profileExists = false;
mutex.ReleaseMutex();
return(profileExists);
}
try
{
Client_Profiles ClientProfileEntity = db.Client_Profiles.FirstOrDefault(n => n.Client_ID == ClientProfileModel.ClientID);
ClientProfileEntity.Client_name = ClientProfileModel.ClientName;
ClientProfileEntity.Client_surname = ClientProfileModel.ClientSurname;
ClientProfileEntity.Client_phone_number = ClientProfileModel.ClientPhoneNumber;
db.SaveChanges();
mutex.ReleaseMutex();
return(true);
}
catch (Exception e)
{
mutex.ReleaseMutex();
return(false);
}
}
public static HttpResponseMessage DeleteCarBrandById(int brandId)
{
HttpResponseMessage result = new HttpResponseMessage(System.Net.HttpStatusCode.Forbidden);
result.Content = new StringContent("Brand does not exists in DB.");
mutex.WaitOne();
if (!CheckIfCarBrandAlreadyExsistsInDB(brandId))
{
mutex.ReleaseMutex();
return(result);
}
var db = new ITAPPCarWorkshopServiceDBEntities();
Car_Brands carBrandToDelete;
carBrandToDelete = db.Car_Brands.FirstOrDefault(brand => brand.Brand_ID == brandId);
db.Car_Brands.Remove(carBrandToDelete);
db.SaveChanges();
mutex.ReleaseMutex();
result = new HttpResponseMessage(System.Net.HttpStatusCode.Accepted);
result.Content = new StringContent("Brand was probably deleted.");
return(result);
}
public IEnumerable <Workshop_Comments> Get_all_comments_from_Workshop_ID([FromUri] int ID)
{
using (var db = new ITAPPCarWorkshopServiceDBEntities())
{
return(db.Workshop_Comments.Where(p => p.Workshop_ID == ID));
}
}
public static HttpResponseMessage ModifyCarBrand(DataModels.CarBrandModel carBrand)
{
HttpResponseMessage result = new HttpResponseMessage(System.Net.HttpStatusCode.Forbidden);
result.Content = new StringContent("Brand does not exists in DB.");
carBrand.BrandName = AdjustCarBrandName(carBrand.BrandName);
mutex.WaitOne();
if (!CheckIfCarBrandAlreadyExsistsInDB(carBrand.BrandName))
{
mutex.ReleaseMutex();
return(result);
}
var db = new ITAPPCarWorkshopServiceDBEntities();
Car_Brands exsistingCarBrand;
exsistingCarBrand = db.Car_Brands.FirstOrDefault(brand => brand.Brand_Name == carBrand.BrandName);
exsistingCarBrand.Brand_Name = carBrand.BrandName;
db.SaveChanges();
mutex.ReleaseMutex();
result = new HttpResponseMessage(System.Net.HttpStatusCode.Accepted);
result.Content = new StringContent("Brand was probably modified.");
return(result);
}
private static bool CheckIfCommentCanBeAdded(Workshop_Comments comment)
{
// TODO:
// Check if there is any sense in here
// I have no idea if it works correctly xD
var mustBeOlderThat = DateTime.Now.AddDays(-minTimeBetweenCommentsInDays);
var db = new ITAPPCarWorkshopServiceDBEntities();
if (!db.Workshop_Comments.Any(n => n.Workshop_ID == comment.Workshop_ID && n.Client_ID == comment.Client_ID))
{
return(true);
}
var list = db.Workshop_Comments.Where(n => n.Workshop_ID == comment.Workshop_ID && n.Client_ID == comment.Client_ID).OrderByDescending(n => n.Comment_date).ToList();
var lastCommentDate = list.First().Comment_date;
if (lastCommentDate < mustBeOlderThat)
{
return(true);
}
return(false);
}
public Workshop_Comments Get_comment([FromUri] int ID)
{
using (var db = new ITAPPCarWorkshopServiceDBEntities())
{
return(db.Workshop_Comments.FirstOrDefault(p => p.Comment_ID == ID));
}
}
public IEnumerable <Workshop_Employees> Get_all_employees(int ID)
{
using (var db = new ITAPPCarWorkshopServiceDBEntities())
{
return(db.Workshop_Employees.Where(p => p.Workshop_ID == ID));
}
}
public Workshop_Employees Get_employee(int ID)
{
using (var db = new ITAPPCarWorkshopServiceDBEntities())
{
return(db.Workshop_Employees.FirstOrDefault(p => p.Workshop_empoyee_ID == ID));
}
}
public Workshop_Opening_Hours Get_oppenting_houers(int ID)
{
using (var db = new ITAPPCarWorkshopServiceDBEntities())
{
return(db.Workshop_Opening_Hours.FirstOrDefault(p => p.Workshop_ID == ID));
}
}
public static HttpResponseMessage AddNewCarBrand(DataModels.CarBrandModel carBrand)
{
HttpResponseMessage result = new HttpResponseMessage(System.Net.HttpStatusCode.Forbidden);
result.Content = new StringContent("Car already exisits");
carBrand.BrandName = AdjustCarBrandName(carBrand.BrandName);
mutex.WaitOne();
if (CheckIfCarBrandAlreadyExsistsInDB(carBrand.BrandName))
{
mutex.ReleaseMutex();
return(result);
}
var db = new ITAPPCarWorkshopServiceDBEntities();
db.Car_Brands.Add(carBrand.MakeCarBrandEntityFromCarBrandModel());
db.SaveChanges();
mutex.ReleaseMutex();
result = new HttpResponseMessage(System.Net.HttpStatusCode.Accepted);
result.Content = new StringContent("Brand was added to DB.");
return(result);
}
private static bool CheckIfUserExistsPrivate(string userEmail)
{
var db = new ITAPPCarWorkshopServiceDBEntities();
userEmail = UserEmailAdjustment(userEmail);
return(db.Users.Any(user => user.User_email.ToLower().Equals(userEmail)));
}
private static bool CheckIfWorkshopProfileExistsByName(string name)
{
var db = new ITAPPCarWorkshopServiceDBEntities();
name = PrepareToCompare(name);
return(db.Workshop_Profiles.Any(workshop => workshop.Workshop_name.ToLower().Equals(name)));
}
private static bool CheckIfWorkshopProfileExistsByCity(string city)
{
var db = new ITAPPCarWorkshopServiceDBEntities();
city = PrepareToCompare(city);
return(db.Workshop_Profiles.Any(workshop => workshop.Workshop_address_city.ToLower().Equals(city)));
}
private static bool CheckIfWorkshopProfileExistsByNIP(string NIP)
{
var db = new ITAPPCarWorkshopServiceDBEntities();
NIP = PrepareToCompare(NIP);
return(db.Workshop_Profiles.Any(workshop => workshop.Workshop_NIP.Equals(NIP)));
}
static public List <DataModels.CarServiceModel> GetListOfCarService()
{
var db = new ITAPPCarWorkshopServiceDBEntities();
List <DataModels.CarServiceModel> returnList;
mutex.WaitOne();
returnList = DataModels.CarServiceModel.ListOfEntityToListOfModels(db.Car_Services.ToList());
mutex.ReleaseMutex();
return(returnList);
}
static public DataModels.CarServiceModel GetListByID(int ID)
{
var db = new ITAPPCarWorkshopServiceDBEntities();
Car_Services returnValue;
mutex.WaitOne();
returnValue = db.Car_Services.First(service => service.Service_ID == ID);
mutex.ReleaseMutex();
return(new DataModels.CarServiceModel(returnValue));
}
private static bool TryToLogIn(DataModels.UserModel user)
{
bool result = false;
var db = new ITAPPCarWorkshopServiceDBEntities();
result = db.Users.Any(n => n.User_email.Equals(user.UserEmail) && n.User_password.Equals(user.UserPassword));
return(result);
}
public static DataModels.CarBrandModel GetCarBrandById(int carBrandId)
{
DataModels.CarBrandModel carBrand;
var db = new ITAPPCarWorkshopServiceDBEntities();
mutex.WaitOne();
carBrand = new DataModels.CarBrandModel(db.Car_Brands.FirstOrDefault(car_brand => car_brand.Brand_ID == carBrandId));
mutex.ReleaseMutex();
return(carBrand);
}
public Response_String Add_workshop_employee([FromBody] Workshop_Employees New_Employee)
{
using (var db = new ITAPPCarWorkshopServiceDBEntities())
{
db.Workshop_Employees.Add(New_Employee);
db.SaveChanges();
return(new Response_String()
{
Response = "Item was added"
});
}
}
public static List <Workshop_Comments> GetComments(int workshopId)
{
mutex.WaitOne();
var db = new ITAPPCarWorkshopServiceDBEntities();
List <Workshop_Comments> list = null;
list = db.Workshop_Comments.Where(n => n.Workshop_ID == workshopId).OrderByDescending(n => n.Comment_date).ToList();
mutex.ReleaseMutex();
return(list);
}
public Response_String Add_Comment([FromBody] Workshop_Comments New_Comment)
{
using (var db = new ITAPPCarWorkshopServiceDBEntities())
{
db.Workshop_Comments.Add(New_Comment);
db.SaveChanges();
return(new Response_String()
{
Response = "Item was added"
});
}
}
public static List <DataModels.WorkshopProfileModel> GetWorkshopsByCityAndName(string city, string name)
{
var db = new ITAPPCarWorkshopServiceDBEntities();
city = PrepareToCompare(city);
name = PrepareToCompare(name);
mutex.WaitOne();
if (city.Length >= minimumCityLength && name.Length >= minimumNameLength)
{
var list = db.Workshop_Profiles.Where(n => n.Workshop_address_city.Replace(" ", string.Empty).ToLower().Equals(city) && n.Workshop_name.ToLower().Replace(" ", string.Empty).Contains(name)).ToList();
mutex.ReleaseMutex();
var ListOfModels = DataModels.WorkshopProfileModel.MakeModelsListFromEntitiesList(list);
foreach (DataModels.WorkshopProfileModel Connection in ListOfModels)
{
foreach (Workshop_Brand_Connections conn in db.Workshop_Brand_Connections.Where(con => con.Workshop_ID == Connection.WorkshopID))
{
Connection.BrandsList.Add(new DataModels.CarBrandModel(db.Car_Brands.FirstOrDefault(Brand => Brand.Brand_ID == conn.Car_brand_ID)));
}
}
return(ListOfModels);
}
if (city.Length >= minimumCityLength)
{
var list = db.Workshop_Profiles.Where(n => n.Workshop_address_city.ToLower().Replace(" ", string.Empty).Equals(city)).ToList();
mutex.ReleaseMutex();
var ListOfModels = DataModels.WorkshopProfileModel.MakeModelsListFromEntitiesList(list);
foreach (DataModels.WorkshopProfileModel Connection in ListOfModels)
{
foreach (Workshop_Brand_Connections conn in db.Workshop_Brand_Connections.Where(con => con.Workshop_ID == Connection.WorkshopID))
{
Connection.BrandsList.Add(new DataModels.CarBrandModel(db.Car_Brands.FirstOrDefault(Brand => Brand.Brand_ID == conn.Car_brand_ID)));
}
}
return(ListOfModels);
}
if (name.Length >= minimumNameLength)
{
var list = db.Workshop_Profiles.Where(n => n.Workshop_name.ToLower().Replace(" ", string.Empty).Contains(name)).ToList();
mutex.ReleaseMutex();
var ListOfModels = DataModels.WorkshopProfileModel.MakeModelsListFromEntitiesList(list);
foreach (DataModels.WorkshopProfileModel Connection in ListOfModels)
{
foreach (Workshop_Brand_Connections conn in db.Workshop_Brand_Connections.Where(con => con.Workshop_ID == Connection.WorkshopID))
{
Connection.BrandsList.Add(new DataModels.CarBrandModel(db.Car_Brands.FirstOrDefault(Brand => Brand.Brand_ID == conn.Car_brand_ID)));
}
}
return(ListOfModels);
}
mutex.ReleaseMutex();
return(new List <DataModels.WorkshopProfileModel>());
}
private static bool CheckIfCarBrandAlreadyExsistsInDB(int carBrandId)
{
bool result = false;
var db = new ITAPPCarWorkshopServiceDBEntities();
if (db.Car_Brands.Any(brandName => brandName.Brand_ID == carBrandId))
{
result = true;
}
return(result);
}
public static HttpResponseMessage Login(DataModels.UserModel user)
{
user.UserEmail = UserEmailAdjustment(user.UserEmail);
var db = new ITAPPCarWorkshopServiceDBEntities();
mutex.WaitOne();
if (!CheckIfUserExistsPrivate(user.UserEmail))
{
mutex.ReleaseMutex();
var response = new HttpResponseMessage(HttpStatusCode.Forbidden);
response.Content = new StringContent("Account of given email address does not exists.");
return(response);
}
if (TryToLogIn(user))
{
var response = new HttpResponseMessage(HttpStatusCode.OK);
string TokenString = GenerateTokenForUser(user.UserEmail);
int userID = GetUserIdByUserEmailPrivate(user.UserEmail);
int clientID = -1;
if (db.Client_Profiles.Any(n => n.User_ID == userID))
{
clientID = db.Client_Profiles.First(n => n.User_ID == userID).Client_ID;
}
mutex.ReleaseMutex();
var ResponseContentAsModel = new ITAPP_CarWorkshopService.AdditionalModels.LoginResponse()
{
Token = TokenString,
UserID = userID,
ClientID = clientID
};
var ResponseContentAsJSON = JsonConvert.SerializeObject(ResponseContentAsModel);
response.Content = new StringContent(ResponseContentAsJSON);
return(response);
}
else
{
mutex.ReleaseMutex();
var response = new HttpResponseMessage(HttpStatusCode.Forbidden);
response.Content = new StringContent("Wrong password");
return(response);
}
}
static public List <DataModels.WorkshopBrandConnectionsModels> GetAllConnections()
{
var db = new ITAPPCarWorkshopServiceDBEntities();
mutex.WaitOne();
List <DataModels.WorkshopBrandConnectionsModels> List = new List <DataModels.WorkshopBrandConnectionsModels>();
foreach (ITAPP_CarWorkshopService.Workshop_Brand_Connections data in db.Workshop_Brand_Connections)
{
List.Add(new DataModels.WorkshopBrandConnectionsModels(data));
}
mutex.ReleaseMutex();
return(List);
}
public static List <DataModels.CarProfileModel> GetCarProfileById(int CarProfileId)
{
var db = new ITAPPCarWorkshopServiceDBEntities();
mutex.WaitOne();
var ListOfEntities = db.Car_Profiles.Where(n => n.Car_ID == CarProfileId).ToList();
mutex.ReleaseMutex();
var ListOfModels = DataModels.CarProfileModel.ListOfEntityToListOfModels(ListOfEntities);
return(ListOfModels);
}
public static List <DataModels.CarProfileModel> GetAllCarProfiles()
{
var db = new ITAPPCarWorkshopServiceDBEntities();
mutex.WaitOne();
var ListOfEntities = db.Car_Profiles.ToList();
mutex.ReleaseMutex();
var ListOfModels = DataModels.CarProfileModel.ListOfEntityToListOfModels(ListOfEntities);
return(ListOfModels);
}
public static HttpResponseMessage CheckIfNameValidPublic(string EmailAddress)
{
var db = new ITAPPCarWorkshopServiceDBEntities();
if (db.Users.Any(n => n.User_email.ToLower() == EmailAddress.ToLower()))
{
var response = new HttpResponseMessage(HttpStatusCode.Forbidden);
return(response);
}
else
{
var response = new HttpResponseMessage(HttpStatusCode.OK);
return(response);
}
}
