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