/// <summary> /// get a single user from the Db acording to User name and password /// </summary> /// <param name="Usernameparam"></param> /// <param name="passwordparam"></param> /// <returns>A single User model object</returns> public static UserModel GetSpesificUser(string Usernameparam, string passwordparam) { try { using (CarRentalDbV2Entities db = new CarRentalDbV2Entities()) { UsersTable dbUser = db.UsersTables.SingleOrDefault(a => a.UserName == Usernameparam && a.UserPassword == passwordparam); if (dbUser == null) { return(null); } return(new UserModel { UserID = dbUser.ID, FullName = dbUser.FullName, UserIdNumber = dbUser.UserIdNumber, UserAuthorization = dbUser.UserAuthorization, UserBirthDate = dbUser.UserBirthDate, UserEmail = dbUser.UserEmail, UserName = dbUser.UserName, UserPassword = dbUser.UserPassword, UserSex = dbUser.UserSex, UserImg = dbUser.UserImg }); } } catch { return(null); } }
/// <summary> /// get all user form the Db /// </summary> /// <returns>an arry of User model objects</returns> public static UserModel[] GetAllUsers() { try { using (CarRentalDbV2Entities db = new CarRentalDbV2Entities()) { return(db.UsersTables.Select(dbUser => new UserModel { UserID = dbUser.ID, FullName = dbUser.FullName, UserIdNumber = dbUser.UserIdNumber, UserAuthorization = dbUser.UserAuthorization, UserBirthDate = dbUser.UserBirthDate, UserEmail = dbUser.UserEmail, UserName = dbUser.UserName, UserPassword = dbUser.UserPassword, UserSex = dbUser.UserSex, UserImg = dbUser.UserImg }).ToArray()); } } catch (Exception x) { return(null); } }
/// <summary> /// set a new rent to the DB /// </summary> /// <param name="newrentparam">a rent model object</param> /// <returns>true if the actions secseed false if it didnt</returns> public static bool AddNewRent(RentModel newrentparam) { try { using (CarRentalDbV2Entities db = new CarRentalDbV2Entities()) { UsersTable dbUser = db.UsersTables.FirstOrDefault(a => a.UserName == newrentparam.UserInfo.UserName); CarsTable dbCar = db.CarsTables.FirstOrDefault(a => a.CarlicenseNumber == newrentparam.CarInfo.CarlicenseNumber); if (dbUser == null || dbCar == null) { return(false); } RentTable NewRent = new RentTable { StartDate = newrentparam.StartDate, EndDate = newrentparam.EndDate, ReturnDate = newrentparam.ReturnDate, UserID = dbUser.ID, CarID = dbCar.ID }; db.RentTables.Add(NewRent); db.SaveChanges(); return(true); } } catch { return(false); } }
/// <summary> /// Edit a user Info /// </summary> /// <param name="Usernameparam">the User name</param> /// <param name="userparam">the User model object</param> /// <returns>true if the actions secseed false if it didnt</returns> public static bool EditUser(string Usernameparam, UserModel userparam) { try { using (CarRentalDbV2Entities db = new CarRentalDbV2Entities()) { UsersTable dbUser = db.UsersTables.SingleOrDefault(a => a.UserName == Usernameparam); if (dbUser == null) { return(false); } dbUser.UserAuthorization = userparam.UserAuthorization; dbUser.FullName = userparam.FullName; dbUser.UserIdNumber = userparam.UserIdNumber; dbUser.UserBirthDate = userparam.UserBirthDate; dbUser.UserEmail = userparam.UserEmail; dbUser.UserName = userparam.UserName; dbUser.UserPassword = userparam.UserPassword; dbUser.UserSex = userparam.UserSex; dbUser.UserImg = userparam.UserImg; db.SaveChanges(); return(true); } } catch { return(false); } }
/// <summary> /// Add a new car type to the DB /// </summary> /// <param name="NewCartype">an car type object conatains all the car type data</param> /// <returns>true if the actions secseed false if it didnt</returns> public static bool AddNewCartype(CarTypeModel NewCartype) { try { using (CarRentalDbV2Entities db = new CarRentalDbV2Entities()) { CarsTypesTable dbCarType = new CarsTypesTable { Model = NewCartype.Model, IsAutomatic = NewCartype.IsAutomatic, CostPerDay = NewCartype.CostPerDay, Year = NewCartype.Year, Manufacturer = NewCartype.Manufacturer, FinePrice = NewCartype.FinePrice, }; db.CarsTypesTables.Add(dbCarType); db.SaveChanges(); return(true); } } catch { return(false); } }
/// <summary> /// add a new car to the db /// </summary> /// <param name="NewCar">the car modle object</param> /// <returns> true if the action sucseed false if it didnt</returns> public static bool AddNewCar(CarModel NewCar) { try { using (CarRentalDbV2Entities db = new CarRentalDbV2Entities()) { BranchesTable dbBrance = db.BranchesTables.FirstOrDefault(a => a.BranceName == NewCar.CarLocation.BranceName); CarsTypesTable dbCarType = db.CarsTypesTables.FirstOrDefault(a => a.Model == NewCar.CarType.Model); if (dbBrance == null || dbCarType == null) { return(false); } CarsTable NewdbCar = new CarsTable { CarLocation = dbBrance.ID, CarType = dbCarType.ID, CarKilometer = NewCar.CarKilometer, CarImg = NewCar.CarImg, CarStatus = NewCar.CarStatus, CarlicenseNumber = NewCar.CarlicenseNumber, }; db.CarsTables.Add(NewdbCar); db.SaveChanges(); return(true); } } catch { return(false); } }
/// <summary> /// Add a new User to the DB /// </summary> /// <param name="NewUser">A User model object</param> /// <returns>true if the actions secseed false if it didnt</returns> public static bool AddNewUser(UserModel NewUser) { try { using (CarRentalDbV2Entities db = new CarRentalDbV2Entities()) { UsersTable dbUser = new UsersTable { FullName = NewUser.FullName, UserIdNumber = NewUser.UserIdNumber, UserAuthorization = NewUser.UserAuthorization, UserBirthDate = NewUser.UserBirthDate, UserEmail = NewUser.UserEmail, UserName = NewUser.UserName, UserPassword = NewUser.UserPassword, UserSex = NewUser.UserSex, UserImg = NewUser.UserImg }; db.UsersTables.Add(dbUser); db.SaveChanges(); return(true); } } catch { return(false); } }
/// <summary> /// edit a car info in the db /// </summary> /// <param name="Carlicenceparam">the car licence number</param> /// <param name="carparam">a car modle contains all the car data</param> /// <returns>true if the actions sucseed false if it didnt</returns> public static bool EditCar(string Carlicenceparam, CarModel carparam) { try { using (CarRentalDbV2Entities db = new CarRentalDbV2Entities()) { CarsTable dbcar = db.CarsTables.SingleOrDefault(a => a.CarlicenseNumber == Carlicenceparam); CarsTypesTable dbcarType = db.CarsTypesTables.SingleOrDefault(a => a.Model == carparam.CarType.Model); BranchesTable dbBrance = db.BranchesTables.SingleOrDefault(a => a.BranceName == carparam.CarLocation.BranceName); if (dbcar == null || dbcarType == null || dbBrance == null) { return(false); } dbcar.CarImg = carparam.CarImg; dbcar.CarLocation = dbBrance.ID; dbcar.CarKilometer = carparam.CarKilometer; dbcar.CarlicenseNumber = carparam.CarlicenseNumber; dbcar.CarStatus = carparam.CarStatus; dbcar.CarType = dbcarType.ID; db.SaveChanges(); return(true); } } catch { return(false); } }
/// <summary> /// get a spesific rent acording to a Id from the client /// </summary> /// <param name="RentId">the rent id-sent from the client</param> /// <returns>A single Rent model object</returns> public static RentModel GetSpesificRent(int RentId) { try { using (CarRentalDbV2Entities db = new CarRentalDbV2Entities()) { RentTable dbrent = db.RentTables.SingleOrDefault(a => a.ID == RentId); if (dbrent == null) { return(null); } return(new RentModel { RentID = dbrent.ID, ReturnDate = dbrent.ReturnDate, StartDate = dbrent.StartDate, EndDate = dbrent.EndDate, CarInfo = new CarModel { CarImg = dbrent.CarsTable.CarImg, CarLocation = new BrancheModel { Adress = dbrent.CarsTable.BranchesTable.Adress, PositionX = dbrent.CarsTable.BranchesTable.PositionX, PositionY = dbrent.CarsTable.BranchesTable.PositionY, BranceName = dbrent.CarsTable.BranchesTable.BranceName }, CarKilometer = dbrent.CarsTable.CarKilometer, CarlicenseNumber = dbrent.CarsTable.CarlicenseNumber, CarStatus = dbrent.CarsTable.CarStatus, CarType = new CarTypeModel { CostPerDay = dbrent.CarsTable.CarsTypesTable.CostPerDay, FinePrice = dbrent.CarsTable.CarsTypesTable.FinePrice, IsAutomatic = dbrent.CarsTable.CarsTypesTable.IsAutomatic, Manufacturer = dbrent.CarsTable.CarsTypesTable.Manufacturer, Model = dbrent.CarsTable.CarsTypesTable.Model, Year = dbrent.CarsTable.CarsTypesTable.Year } }, UserInfo = new UserModel { UserAuthorization = dbrent.UsersTable.UserAuthorization, FullName = dbrent.UsersTable.FullName, UserBirthDate = dbrent.UsersTable.UserBirthDate, UserEmail = dbrent.UsersTable.UserEmail, UserIdNumber = dbrent.UsersTable.UserIdNumber, UserName = dbrent.UsersTable.UserName, UserPassword = dbrent.UsersTable.UserPassword, UserSex = dbrent.UsersTable.UserSex, UserImg = dbrent.UsersTable.UserImg } }); } } catch (Exception x) { return(null); } }
/// <summary> /// get a spesific car type acording to a model from the client /// </summary> /// <param name="cartypeModle"></param> /// <returns>a singl car type object</returns> public static CarTypeModel GetSpesificCartype(string cartypeModle) { try { using (CarRentalDbV2Entities db = new CarRentalDbV2Entities()) { CarsTypesTable dbcartype = db.CarsTypesTables.SingleOrDefault(a => a.Model == cartypeModle); if (dbcartype == null) { return(null); } return(new CarTypeModel { CostPerDay = dbcartype.CostPerDay, FinePrice = dbcartype.FinePrice, Model = dbcartype.Model, IsAutomatic = dbcartype.IsAutomatic, Manufacturer = dbcartype.Manufacturer, Year = dbcartype.Year }); } } catch { return(null); } }
/// <summary> /// edit a rent acording to a rent id sent by the cient /// </summary> /// <param name="RentId">the rent id sent by the client</param> /// <param name="rentparam">a rent model contains all the rent data</param> /// <returns>true if the actions secseed false if it didnt</returns> public static bool EditRent(int RentId, RentModel rentparam) { try { using (CarRentalDbV2Entities db = new CarRentalDbV2Entities()) { RentTable dbrent = db.RentTables.SingleOrDefault(a => a.ID == RentId); UsersTable dbuser = db.UsersTables.SingleOrDefault(a => a.UserName == rentparam.UserInfo.UserName); CarsTable dbcar = db.CarsTables.SingleOrDefault(a => a.CarlicenseNumber == rentparam.CarInfo.CarlicenseNumber); if (dbrent == null || dbuser == null || dbcar == null) { return(false); } dbrent.CarID = dbcar.ID; dbrent.UserID = dbuser.ID; dbrent.EndDate = rentparam.EndDate; dbrent.ReturnDate = rentparam.ReturnDate; dbrent.StartDate = rentparam.StartDate; db.SaveChanges(); return(true); } } catch { return(false); } }
/// <summary> /// gets a spesific branch acording to a branch name /// </summary> /// <param name="BranchNameparam">a string from the client side</param> /// <returns> a branch model object</returns> public static BrancheModel GetSpesificBranche(string BranchNameparam) { try { using (CarRentalDbV2Entities db = new CarRentalDbV2Entities()) { BranchesTable dbBranch = db.BranchesTables.SingleOrDefault(a => a.BranceName == BranchNameparam); if (dbBranch == null) { return(null); } return(new BrancheModel { BranceName = dbBranch.BranceName, PositionX = dbBranch.PositionX, PositionY = dbBranch.PositionY, Adress = dbBranch.Adress }); } } catch { return(null); } }
/// <summary> /// edit a car type info /// </summary> /// <param name="cartypeModle">the car type model from the user--string</param> /// <param name="cartypeparam">an car type object contain all of the car type info</param> /// <returns>true if the actions secseed false if it didnt</returns> public static bool EditCarType(string cartypeModle, CarTypeModel cartypeparam) { try { using (CarRentalDbV2Entities db = new CarRentalDbV2Entities()) { CarsTypesTable dbcartype = db.CarsTypesTables.SingleOrDefault(a => a.Model == cartypeModle); if (dbcartype == null) { return(false); } dbcartype.Model = cartypeparam.Model; dbcartype.Year = cartypeparam.Year; dbcartype.CostPerDay = cartypeparam.CostPerDay; dbcartype.FinePrice = cartypeparam.FinePrice; dbcartype.Manufacturer = cartypeparam.Manufacturer; dbcartype.IsAutomatic = cartypeparam.IsAutomatic; db.SaveChanges(); return(true); } } catch { return(false); } }
/// <summary> /// gets all the the renal object from the DB /// </summary> /// <returns>an arry of Rent models</returns> public static RentModel[] GetAllRents() { try { using (CarRentalDbV2Entities db = new CarRentalDbV2Entities()) { return(db.RentTables.Select(dbrent => new RentModel { RentID = dbrent.ID, ReturnDate = dbrent.ReturnDate, StartDate = dbrent.StartDate, EndDate = dbrent.EndDate, CarInfo = new CarModel { CarImg = dbrent.CarsTable.CarImg, CarLocation = new BrancheModel { Adress = dbrent.CarsTable.BranchesTable.Adress, PositionX = dbrent.CarsTable.BranchesTable.PositionX, PositionY = dbrent.CarsTable.BranchesTable.PositionY, BranceName = dbrent.CarsTable.BranchesTable.BranceName }, CarKilometer = dbrent.CarsTable.CarKilometer, CarlicenseNumber = dbrent.CarsTable.CarlicenseNumber, CarStatus = dbrent.CarsTable.CarStatus, CarType = new CarTypeModel { CostPerDay = dbrent.CarsTable.CarsTypesTable.CostPerDay, FinePrice = dbrent.CarsTable.CarsTypesTable.FinePrice, IsAutomatic = dbrent.CarsTable.CarsTypesTable.IsAutomatic, Manufacturer = dbrent.CarsTable.CarsTypesTable.Manufacturer, Model = dbrent.CarsTable.CarsTypesTable.Model, Year = dbrent.CarsTable.CarsTypesTable.Year } }, UserInfo = new UserModel { UserAuthorization = dbrent.UsersTable.UserAuthorization, FullName = dbrent.UsersTable.FullName, UserBirthDate = dbrent.UsersTable.UserBirthDate, UserEmail = dbrent.UsersTable.UserEmail, UserIdNumber = dbrent.UsersTable.UserIdNumber, UserName = dbrent.UsersTable.UserName, UserPassword = dbrent.UsersTable.UserPassword, UserSex = dbrent.UsersTable.UserSex, UserImg = dbrent.UsersTable.UserImg } }).ToArray()); } } catch { return(null); } }
/// <summary> /// gets all the branches in the DB /// </summary> /// <returns>an arry of branch models objects</returns> public static BrancheModel [] GetAllBranches() { try { using (CarRentalDbV2Entities db = new CarRentalDbV2Entities()) { return(db.BranchesTables.Select(dbBranch => new BrancheModel { BranceName = dbBranch.BranceName, PositionX = dbBranch.PositionX, PositionY = dbBranch.PositionY, Adress = dbBranch.Adress }).ToArray()); } } catch (Exception x) { return(null); } }
/// <summary> /// get a single car model /// </summary> /// <param name="Carlicenceparam">the car licence number from the client</param> /// <returns>a car model object</returns> public static CarModel GetSpesificCar(string Carlicenceparam) { try { using (DAL.CarRentalDbV2Entities db = new CarRentalDbV2Entities()) { CarsTable dbcar = db.CarsTables.SingleOrDefault(a => a.CarlicenseNumber == Carlicenceparam); if (dbcar == null) { return(null); } return(new CarModel { CarImg = dbcar.CarImg, CarLocation = new BrancheModel { Adress = dbcar.BranchesTable.Adress, PositionX = dbcar.BranchesTable.PositionX, PositionY = dbcar.BranchesTable.PositionY, BranceName = dbcar.BranchesTable.BranceName }, CarKilometer = dbcar.CarKilometer, CarlicenseNumber = dbcar.CarlicenseNumber, CarStatus = dbcar.CarStatus, CarType = new CarTypeModel { CostPerDay = dbcar.CarsTypesTable.CostPerDay, FinePrice = dbcar.CarsTypesTable.FinePrice, IsAutomatic = dbcar.CarsTypesTable.IsAutomatic, Manufacturer = dbcar.CarsTypesTable.Manufacturer, Model = dbcar.CarsTypesTable.Model, Year = dbcar.CarsTypesTable.Year } }); } } catch { return(null); } }
/// <summary> /// delete a rent acording to a rent id sent by the client /// </summary> /// <param name="RentId">the rent id sent by the client</param> /// <returns>true if the actions secseed false if it didnt</returns> public static bool DeleteRent(int RentId) { try { using (CarRentalDbV2Entities db = new CarRentalDbV2Entities()) { RentTable dbrent = db.RentTables.SingleOrDefault(a => a.ID == RentId); if (dbrent == null) { return(false); } db.RentTables.Remove(dbrent); db.SaveChanges(); return(true); } } catch { return(false); } }
/// <summary> /// delete a car from the db /// </summary> /// <param name="Carlicenceparam">the car licence number</param> /// <returns>true if the actions secseed false if it didnt</returns> public static bool DeleteCar(string Carlicenceparam) { try { using (CarRentalDbV2Entities db = new CarRentalDbV2Entities()) { CarsTable dbcar = db.CarsTables.SingleOrDefault(a => a.CarlicenseNumber == Carlicenceparam); if (dbcar == null) { return(false); } db.CarsTables.Remove(dbcar); db.SaveChanges(); return(true); } } catch { return(false); } }
/// <summary> /// delete a cartype from the db /// </summary> /// <param name="cartypeModle">the cartype model </param> /// <returns>true if the actions secseed false if it didnt</returns> public static bool DeleteCartype(string cartypeModle) { try { using (CarRentalDbV2Entities db = new CarRentalDbV2Entities()) { CarsTypesTable dbcartype = db.CarsTypesTables.SingleOrDefault(a => a.Model == cartypeModle); if (dbcartype == null) { return(false); } db.CarsTypesTables.Remove(dbcartype); db.SaveChanges(); return(true); } } catch { return(false); } }
/// <summary> /// delete a user from the DB /// </summary> /// <param name="Usernameparam">A user name sent from the client</param> /// <returns>returns>true if the actions secseed false if it didnt</returns> public static bool DeleteUser(string Usernameparam) { try { using (CarRentalDbV2Entities db = new CarRentalDbV2Entities()) { UsersTable dbUser = db.UsersTables.SingleOrDefault(a => a.UserName == Usernameparam); if (dbUser == null) { return(false); } db.UsersTables.Remove(dbUser); db.SaveChanges(); return(true); } } catch { return(false); } }
/// <summary> /// gets all car types from the DB /// </summary> /// <returns>an arry of CarType model object</returns> public static CarTypeModel[] GetAllCarTypes() { try { using (CarRentalDbV2Entities db = new CarRentalDbV2Entities()) { return(db.CarsTypesTables.Select(dbcartype => new CarTypeModel { CostPerDay = dbcartype.CostPerDay, FinePrice = dbcartype.FinePrice, IsAutomatic = dbcartype.IsAutomatic, Manufacturer = dbcartype.Manufacturer, Model = dbcartype.Model, Year = dbcartype.Year }).ToArray()); } } catch (Exception x) { return(null); } }
/// <summary> /// get all The cars in the DB /// </summary> /// <returns>an arry of car model objects </returns> public static CarModel[] GetAllCars() { try { using (CarRentalDbV2Entities db = new CarRentalDbV2Entities()) { return(db.CarsTables.Select(dbcar => new CarModel { CarImg = dbcar.CarImg, CarLocation = new BrancheModel { Adress = dbcar.BranchesTable.Adress, PositionX = dbcar.BranchesTable.PositionX, PositionY = dbcar.BranchesTable.PositionY, BranceName = dbcar.BranchesTable.BranceName }, CarKilometer = dbcar.CarKilometer, CarlicenseNumber = dbcar.CarlicenseNumber, CarStatus = dbcar.CarStatus, CarType = new CarTypeModel { CostPerDay = dbcar.CarsTypesTable.CostPerDay, FinePrice = dbcar.CarsTypesTable.FinePrice, IsAutomatic = dbcar.CarsTypesTable.IsAutomatic, Manufacturer = dbcar.CarsTypesTable.Manufacturer, Model = dbcar.CarsTypesTable.Model, Year = dbcar.CarsTypesTable.Year } }).ToArray()); } } catch { return(null); } }
/// <summary> /// get a spesific rent acording to User name or a Car licence number /// </summary> /// <param name="StringParam">Or user name Or a Car licence number</param> /// <returns>A single Rent model object</returns> public static RentModel[] GetSpesificRent(string StringParam) { try { using (CarRentalDbV2Entities db = new CarRentalDbV2Entities()) { RentTable[] dbrents = null; //Assum that the the StringParam is a car licence number dbrents = db.RentTables.Where(a => a.CarsTable.CarlicenseNumber == StringParam).ToArray(); //if the arry lenght is 0, Assum that the the StringParam is a User name dbrents = (dbrents.Length > 0)?dbrents:db.RentTables.Where(a => a.UsersTable.UserName == StringParam).ToArray(); //if after both options the arry is still null return null from the function if (dbrents == null) { return(null); } return(dbrents.Select(dbrent => new RentModel { RentID = dbrent.ID, ReturnDate = dbrent.ReturnDate, StartDate = dbrent.StartDate, EndDate = dbrent.EndDate, CarInfo = new CarModel { CarImg = dbrent.CarsTable.CarImg, CarLocation = new BrancheModel { Adress = dbrent.CarsTable.BranchesTable.Adress, PositionX = dbrent.CarsTable.BranchesTable.PositionX, PositionY = dbrent.CarsTable.BranchesTable.PositionY, BranceName = dbrent.CarsTable.BranchesTable.BranceName }, CarKilometer = dbrent.CarsTable.CarKilometer, CarlicenseNumber = dbrent.CarsTable.CarlicenseNumber, CarStatus = dbrent.CarsTable.CarStatus, CarType = new CarTypeModel { CostPerDay = dbrent.CarsTable.CarsTypesTable.CostPerDay, FinePrice = dbrent.CarsTable.CarsTypesTable.FinePrice, IsAutomatic = dbrent.CarsTable.CarsTypesTable.IsAutomatic, Manufacturer = dbrent.CarsTable.CarsTypesTable.Manufacturer, Model = dbrent.CarsTable.CarsTypesTable.Model, Year = dbrent.CarsTable.CarsTypesTable.Year } }, UserInfo = new UserModel { UserAuthorization = dbrent.UsersTable.UserAuthorization, FullName = dbrent.UsersTable.FullName, UserBirthDate = dbrent.UsersTable.UserBirthDate, UserEmail = dbrent.UsersTable.UserEmail, UserIdNumber = dbrent.UsersTable.UserIdNumber, UserName = dbrent.UsersTable.UserName, UserPassword = dbrent.UsersTable.UserPassword, UserSex = dbrent.UsersTable.UserSex, UserImg = dbrent.UsersTable.UserImg } }).ToArray()); }; } catch (Exception x) { return(null); } }