Esempio n. 1
0
 /// <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);
     }
 }
Esempio n. 2
0
 /// <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);
            }
        }
Esempio n. 4
0
 /// <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);
     }
 }
Esempio n. 5
0
 /// <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);
            }
        }
Esempio n. 7
0
 /// <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);
     }
 }
Esempio n. 10
0
 /// <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);
     }
 }
Esempio n. 13
0
 /// <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);
     }
 }
Esempio n. 19
0
 /// <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);
     }
 }
Esempio n. 20
0
 /// <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);
     }
 }
Esempio n. 21
0
 /// <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);
     }
 }