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