public static BOLUserInfo GetLoginUserFrom_db(string UserIdNumber)
{
try
{
using (RentalcarsEntities1 ef = new RentalcarsEntities1())
{
BOLUserInfo UsersInfo = new BOLUserInfo();
UserTable dbUser = ef.UserTables.FirstOrDefault(u => u.UserIdNumber == UserIdNumber);
if (dbUser != null)
{
UsersInfo.FullUserName = dbUser.FullUserName;
UsersInfo.UserIdNumber = dbUser.UserIdNumber;
UsersInfo.UserName = dbUser.UserName;
UsersInfo.Password = dbUser.Password;
UsersInfo.BirthDay = dbUser.BirthDay;
UsersInfo.Sex = dbUser.Sex;
UsersInfo.UserRole = dbUser.UserRole;
UsersInfo.UserPic = dbUser.UserPic;
UsersInfo.Email = dbUser.Email;
return(UsersInfo);
}
}
}
catch { return(null); }
return(null);
}
public static List <BOLCarInventory> GetCarFromForManager_db()
{
try
{
List <BOLCarInventory> carsInventory = new List <BOLCarInventory>();
using (RentalcarsEntities1 ef = new RentalcarsEntities1())
{
foreach (var item in ef.VehicleInventories.ToList())
{
if (item.IsProperForRent)
{
carsInventory.Add(new BOLCarInventory
{
CarsTypeID = item.CarsTypeID,
UpdatedMileage = item.UpdatedMileage,
VehiclePic = item.VehiclePic,
IsProperForRent = item.IsProperForRent,
VehicleNumber = item.VehicleNumber,
BranchesID = item.BranchesID
});
}
}
return(carsInventory);
}
}
catch { }
return(null);
}
public static string deleteFrom_db(int VehicleNumber)
{
try
{
using (RentalcarsEntities1 ef = new RentalcarsEntities1())
{
VehicleInventory dbvehicle = ef.VehicleInventories.FirstOrDefault(u => u.VehicleNumber == VehicleNumber);
List <Order> isItInOrder = ef.Orders.Where(u => u.VehiclesID == dbvehicle.VehiclesID && u.ActualReturnDate != null).ToList();
if (isItInOrder.Count == 0)
{
if (dbvehicle != null)
{
ef.VehicleInventories.Remove(dbvehicle);
ef.SaveChanges();
return("deleted");
}
else
{
throw new InvalidOperationException($"this car type is not exist please change the values and try again");
}
}
else
{
return("this vehicle is in order");
}
}
}
catch
{
return("wrong vehicle number");
}
}
public static string UpDataTo_db(BOLUserInfo olduserInfo, BOLUserInfo newuserInfo)
{
try
{
if (newuserInfo.UserRole != 0)
{
ValidateUserInput.CheckRole(newuserInfo.UserRole);
}
using (RentalcarsEntities1 ef = new RentalcarsEntities1())
{
UserTable dbUser = ef.UserTables.FirstOrDefault(u => u.UserIdNumber == olduserInfo.UserIdNumber);
dbUser.FullUserName = newuserInfo.FullUserName;
dbUser.UserIdNumber = newuserInfo.UserIdNumber;
dbUser.UserName = newuserInfo.UserName;
dbUser.Password = newuserInfo.Password;
dbUser.BirthDay = newuserInfo.BirthDay;
dbUser.Sex = newuserInfo.Sex;
dbUser.UserRole = newuserInfo.UserRole;
dbUser.UserPic = newuserInfo.UserPic;
dbUser.Email = newuserInfo.Email;
ef.SaveChanges();
return("OK");
}
}
catch
{
return("Something is wrong with the data");
}
}
public static void UpDataTo_db(BOLBranch oldBranch, BOLBranch newBranch)
{
try
{
using (RentalcarsEntities1 ef = new RentalcarsEntities1())
{
Branch dbBranch = ef.Branches.FirstOrDefault(u => u.BranchesName == oldBranch.BranchesName);
if (dbBranch != null)
{
dbBranch.Address = newBranch.Address;
dbBranch.Latitude = newBranch.Latitude;
dbBranch.Longitude = newBranch.Longitude;
dbBranch.BranchesName = newBranch.BranchesName;
ef.SaveChanges();
}
else
{
throw new InvalidOperationException($"this branch is not exist please change the values and try again");
}
}
}
catch (Exception EX)
{
throw new Exception(EX.ToString());
}
}
public static List <BOLCarType> GetDistinctName()
{
try
{
using (RentalcarsEntities1 ef = new RentalcarsEntities1())
{
List <BOLCarType> typeModel = new List <BOLCarType>();
List <int> typeid = ef.VehicleInventories.Select(m => m.CarsTypeID).ToList();
foreach (var item in typeid)
{
CarsType cartype = ef.CarsTypes.FirstOrDefault(u => u.CarTypeID == item);
typeModel.Add(new BOLCarType
{
ManufacturerName = cartype.ManufacturerName,
Model = cartype.Model,
DailyCost = cartype.DailyCost,
CostDayOverdue = cartype.CostDayOverdue,
ManufactureYear = cartype.ManufactureYear,
Gear = cartype.Gear
});
}
return(typeModel);
}
}
catch
{
return(null);
}
}
public static BOLCarInventory AddCarTo_db(BOLCarInventory car)
{
try
{
using (RentalcarsEntities1 ef = new RentalcarsEntities1())
{
VehicleInventory isExist = ef.VehicleInventories.FirstOrDefault(u => u.VehicleNumber == car.VehicleNumber);
if (isExist == null)
{
ef.VehicleInventories.Add(new VehicleInventory
{
CarsTypeID = car.CarsTypeID,
UpdatedMileage = car.UpdatedMileage,
VehiclePic = car.VehiclePic,
IsProperForRent = car.IsProperForRent,
VehicleNumber = car.VehicleNumber,
BranchesID = car.BranchesID
});
ef.SaveChanges();
return(car);
}
else
{
throw new InvalidOperationException($"this car number is already exist please change and try again");
}
}
}
catch
{
return(null);
}
}
public static BOLCarInventory UpDataTo_db(BOLCarInventory oldCar, BOLCarInventory newCar)
{
try
{
using (RentalcarsEntities1 ef = new RentalcarsEntities1())
{
VehicleInventory dbUser = ef.VehicleInventories.FirstOrDefault(u => u.VehicleNumber == oldCar.VehicleNumber);
if (dbUser != null)
{
dbUser.CarsTypeID = newCar.CarsTypeID;
dbUser.UpdatedMileage = newCar.UpdatedMileage;
dbUser.VehiclePic = newCar.VehiclePic;
dbUser.IsProperForRent = newCar.IsProperForRent;
dbUser.VehicleNumber = newCar.VehicleNumber;
dbUser.BranchesID = newCar.BranchesID;
ef.SaveChanges();
return(newCar);
}
else
{
throw new InvalidOperationException($"this car type is not exist please change the values and try again");
}
}
}
catch
{
return(null);
}
}
public static string AddCarTypeTo_db(BOLCarType carType)
{
try
{
CarsType isExist = ValidateCarInput.IsExist(carType);
if (isExist == null)
{
using (RentalcarsEntities1 ef = new RentalcarsEntities1())
{
ef.CarsTypes.Add(new CarsType
{
ManufacturerName = carType.ManufacturerName,
Model = carType.Model,
DailyCost = carType.DailyCost,
CostDayOverdue = carType.CostDayOverdue,
ManufactureYear = carType.ManufactureYear,
Gear = carType.Gear
});
ef.SaveChanges();
return("OK");
}
}
else
{
throw new InvalidOperationException($"this car type is already exist please change the values and try again");
}
}
catch
{
return("this car type is already exist please change the values and try again");
}
}
public static List <int> GetListOrderByDate(DateTime start, DateTime end)
{
List <int> orderedCars = new List <int>();
try
{
using (RentalcarsEntities1 ef = new RentalcarsEntities1())
{
List <Order> dbOrder = ef.Orders.Where(u => u.ActualReturnDate == null).ToList();
if (dbOrder.Count != 0)
{
foreach (var item in dbOrder)
{
if (item.ReturnDate >= start && item.StartDate <= end || item.StartDate <= start && item.ReturnDate >= end)
{
VehicleInventory getCarInfo = ef.VehicleInventories.FirstOrDefault(u => u.VehiclesID == item.VehiclesID);
orderedCars.Add(getCarInfo.VehicleNumber);
}
}
}
return(orderedCars);
}
}
catch { return(null); }
}
public static void deleteFrom_db(int userID, int vehiclesID, DateTime startDate)
{
try
{
using (RentalcarsEntities1 ef = new RentalcarsEntities1())
{
Order order = ef.Orders.FirstOrDefault(u =>
u.StartDate == startDate &&
u.UserID == userID && u.VehiclesID == vehiclesID);
if (order != null)
{
ef.Orders.Remove(order);
ef.SaveChanges();
}
else
{
throw new InvalidOperationException($"this order is not exist please change the values and try again");
}
}
}
catch
{
}
}
public static string AddUserTo_db(BOLUserInfo userInfo)
{
try
{
using (RentalcarsEntities1 ef = new RentalcarsEntities1())
{
ValidateUserInput.CheckUnique(userInfo.UserName, userInfo.UserIdNumber);
ef.UserTables.Add(new UserTable
{
FullUserName = userInfo.FullUserName,
UserIdNumber = userInfo.UserIdNumber,
UserName = userInfo.UserName,
Password = userInfo.Password,
BirthDay = userInfo.BirthDay,
Sex = userInfo.Sex,
UserRole = 0,
UserPic = userInfo.UserPic,
Email = userInfo.Email
});
ef.SaveChanges();
return("OK");
}
}
catch
{
return("Something is wrong with the data");
}
}
public static List <BOLUserInfo> GetAllUsers()
{
try
{
using (RentalcarsEntities1 ef = new RentalcarsEntities1())
{
List <BOLUserInfo> ListUsersInfo = new List <BOLUserInfo>();
List <UserTable> dbUser = ef.UserTables.Select(u => u).ToList();
foreach (var item in dbUser)
{
ListUsersInfo.Add(new BOLUserInfo
{
FullUserName = item.FullUserName,
UserIdNumber = item.UserIdNumber,
UserName = item.UserName,
Password = item.Password,
BirthDay = item.BirthDay,
Sex = item.Sex,
UserRole = item.UserRole,
UserPic = item.UserPic,
Email = item.Email,
});
}
return(ListUsersInfo);
}
}
catch
{ return(null); }
}
public static string deleteFrom_db(string id)
{
try
{
ValidateUserInput.IsThisUserexists(id);
using (RentalcarsEntities1 ef = new RentalcarsEntities1())
{
UserTable dbUser = ef.UserTables.FirstOrDefault(u => u.UserIdNumber == id);
List <Order> ishaveOrder = ef.Orders.Where(u => u.UserID == dbUser.UserID && u.ActualReturnDate != null).ToList();
if (ishaveOrder.Count == 0)
{
ef.UserTables.Remove(ef.UserTables.FirstOrDefault(u => u.UserIdNumber == id));
ef.SaveChanges();
return("OK");
}
else
{
return("This user has an order in his name");
}
}
}
catch
{
return("Something is wrong with the data");
}
}
public static string GetUserNume(string userid)
{
try
{
BOLUserInfo a = new BOLUserInfo();
a.UserIdNumber = userid;
userid = a.UserIdNumber;
using (RentalcarsEntities1 ef = new RentalcarsEntities1())
{
UserTable dbUser = ef.UserTables.FirstOrDefault(u => u.UserIdNumber == userid);
if (dbUser != null)
{
return(dbUser.UserName);
}
else
{
throw new InvalidOperationException($"this user is not exist please change the values and try again");
}
}
}
catch (Exception EX)
{
return(EX.ToString());
}
}
public static List <BOLCarType> GetCarsTypeFrom_db(string typeName)
{
try
{
using (RentalcarsEntities1 ef = new RentalcarsEntities1())
{
List <BOLCarType> CarTypeList = new List <BOLCarType>();
List <CarsType> carType = ef.CarsTypes.Where(u => u.ManufacturerName == typeName).ToList();
foreach (var item in carType)
{
CarTypeList.Add(new BOLCarType
{
ManufacturerName = item.ManufacturerName,
Model = item.Model,
DailyCost = item.DailyCost,
CostDayOverdue = item.CostDayOverdue,
ManufactureYear = item.ManufactureYear,
Gear = item.Gear
});
}
return(CarTypeList);
}
}
catch { }
return(null);
}
public static void AddBranchTo_db(BOLBranch branch)
{
try {
using (RentalcarsEntities1 ef = new RentalcarsEntities1())
{
Branch dbUser = ef.Branches.FirstOrDefault(u => u.BranchesName == branch.BranchesName);
if (dbUser == null)
{
ef.Branches.Add(new Branch
{
Address = branch.Address,
Latitude = branch.Latitude,
Longitude = branch.Longitude,
BranchesName = branch.BranchesName
});
ef.SaveChanges();
}
else
{
throw new InvalidOperationException($"this branch is exist please change the values and try again");
}
}
}
catch (Exception EX)
{
throw new Exception(EX.ToString());
}
}
public static List <BOLOrder> GetUsersOrdesrByUserName(string UserName)
{
List <BOLOrder> orderList = new List <BOLOrder>();
try
{
UserTable user;
using (RentalcarsEntities1 ef = new RentalcarsEntities1())
{
user = ef.UserTables.FirstOrDefault(u => u.UserName == UserName);
}
using (RentalcarsEntities1 ef = new RentalcarsEntities1())
{
List <Order> dbOrder = ef.Orders.Where(u => u.ActualReturnDate == null && u.UserID == user.UserID).ToList();
foreach (var item in dbOrder)
{
orderList.Add(new BOLOrder
{
StartDate = item.StartDate,
ReturnDate = item.ReturnDate,
ActualReturnDate = item.ActualReturnDate,
UserID = item.UserID,
VehiclesID = item.VehiclesID,
});
}
return(orderList);
}
}
catch
{
return(null);
}
}
public static decimal getDaylyCost(int CarTypeID)
{
using (RentalcarsEntities1 ef = new RentalcarsEntities1())
{
CarsType getCost = ef.CarsTypes.FirstOrDefault(u => u.CarTypeID == CarTypeID);
return(getCost.DailyCost);
}
}
public static int GetCarsTypeID(int vehiclesID)
{
using (RentalcarsEntities1 ef = new RentalcarsEntities1())
{
VehicleInventory getCarTypeId = ef.VehicleInventories.FirstOrDefault(u => u.VehiclesID == vehiclesID);
return(getCarTypeId.CarsTypeID);
}
}
public static int GetLogin(string userName, string password)
{
using (RentalcarsEntities1 ef = new RentalcarsEntities1())
{
UserTable user = ef.UserTables.FirstOrDefault(u => u.UserName == userName && u.Password == password);
int UserRole = user.UserRole;
return(UserRole);
}
}
internal static void IsThisUserexists(string userIdNumber)
{
using (RentalcarsEntities1 ef = new RentalcarsEntities1())
{
UserTable getuseruserId = ef.UserTables.FirstOrDefault(u => u.UserIdNumber == userIdNumber);
if (getuseruserId == null)//worker
{
throw new InvalidOperationException("This User IS NOT exists");
}
}
}
public static List <DateTime> GetTypeYear()
{
try
{
using (RentalcarsEntities1 ef = new RentalcarsEntities1())
{
List <DateTime> typeNames = ef.CarsTypes.Select(m => m.ManufactureYear).Distinct().ToList();
return(typeNames);
}
}
catch
{
return(null);
}
}
public static List <string> GetTypeModel(string TypeName)
{
try
{
using (RentalcarsEntities1 ef = new RentalcarsEntities1())
{
List <string> typeModel = ef.CarsTypes.Where(u => u.ManufacturerName == TypeName).Select(m => m.Model).Distinct().ToList();
return(typeModel);
}
}
catch
{
return(null);
}
}
public static List <string> GetTypeGear()
{
try
{
using (RentalcarsEntities1 ef = new RentalcarsEntities1())
{
List <string> typeNames = ef.CarsTypes.Select(m => m.Gear).Distinct().ToList();
return(typeNames);
}
}
catch
{
return(null);
}
}
public static void CheckRole(int userRole)
{
using (RentalcarsEntities1 ef = new RentalcarsEntities1())
{
List <UserTable> getuserroll = ef.UserTables.Where(u => u.UserRole == userRole).ToList();
Console.WriteLine(getuserroll);
if (userRole == 1 && getuserroll.Count == 1)//worker
{
throw new InvalidOperationException($"this role is already taken please change {getuserroll[0].FullUserName} role and try again");
}
else if (getuserroll.Count == 5)
{
throw new InvalidOperationException($"this role is already taken please change {getuserroll[0].FullUserName}or {getuserroll[1].FullUserName} or{getuserroll[2].FullUserName} or{getuserroll[3].FullUserName}or {getuserroll[4].FullUserName} role and try again");
}
}
}
public static BOLOrder UpDataTo_db(BOLOrder retrievedOrder)
{
try
{
using (RentalcarsEntities1 ef = new RentalcarsEntities1())
{
Order getOrder = ef.Orders.FirstOrDefault(u => u.UserID == retrievedOrder.UserID && u.StartDate == retrievedOrder.StartDate && u.VehiclesID == retrievedOrder.VehiclesID);
DateTime getCorrentDate = DateTime.Today;
getOrder.ActualReturnDate = getCorrentDate.Date;
ef.SaveChanges();
retrievedOrder.ActualReturnDate = getOrder.ActualReturnDate;
return(retrievedOrder);
}
}
catch { return(null); }
}
public static string GetUserName(int userID)
{
using (RentalcarsEntities1 ef = new RentalcarsEntities1())
{
BOLUserInfo UsersInfo = new BOLUserInfo();
UserTable dbUser = ef.UserTables.FirstOrDefault(u => u.UserID == userID);
if (dbUser != null)
{
return(dbUser.UserName);
}
else
{
return(null);
}
}
}
internal static void CheckUnique(string userName, string userIdNumber)
{
using (RentalcarsEntities1 ef = new RentalcarsEntities1())
{
UserTable getuseruserName = ef.UserTables.FirstOrDefault(u => u.UserName == userName);
if (getuseruserName != null)//worker
{
throw new InvalidOperationException($"this username is already taken");
}
UserTable getuseruserId = ef.UserTables.FirstOrDefault(u => u.UserIdNumber == userIdNumber);
if (getuseruserId != null)//worker
{
throw new InvalidOperationException("you are already registered");
}
}
}
internal static CarsType IsExist(BOLCarType carType)
{
using (RentalcarsEntities1 ef = new RentalcarsEntities1())
{
CarsType carTipe = ef.CarsTypes.FirstOrDefault(u => u.ManufacturerName == carType.ManufacturerName &&
u.Model == carType.Model &&
u.ManufactureYear == carType.ManufactureYear && u.Gear == carType.Gear &&
u.DailyCost == carType.DailyCost);
if (carTipe != null)
{
return(carTipe);
}
else
{
return(carTipe);
}
}
}
