public Response RejectVehicle(int Id)
{
Response response = new Response();
using (VehiclesSystemEntities db = new VehiclesSystemEntities())
{
var result = db.Vehicles.FirstOrDefault(v => v.Id == Id);
if (result != null)
{
if (result.PlateTextId != null)
{
var plateTextResult = db.PlateTexts.FirstOrDefault(p => p.Id == result.PlateTextId);
db.PlateTexts.Remove(plateTextResult);
}
db.Vehicles.Remove(result);
db.SaveChanges();
response.Msg = "success";
}
else
{
response.Msg = "Fail!, wrong vehicle id";
}
}
return(response);
}
public Response GetNewVehicles()
{
Response response = new Response();
using (VehiclesSystemEntities db = new VehiclesSystemEntities())
{
List <Models.Vehicle> NewVehicles = new List <Models.Vehicle>();
foreach (var item in db.Vehicles)
{
if (item.WaitingForApprove)
{
Models.Vehicle vehicle = new Models.Vehicle
{
VehicleId = item.Id,
PlateNumber = item.PlateNumber,
PlateModel = item.PlateModel,
PlateColor = item.PlateColor,
WaitingForApprove = item.WaitingForApprove
};
if (item.PlateTextId != null)
{
vehicle.PlateText = (from p in db.PlateTexts
where p.Id == item.PlateTextId
select p.Text).FirstOrDefault();
}
NewVehicles.Add(vehicle);
}
}
response.Vehicles = NewVehicles;
response.Msg = "success";
}
return(response);
}
public Response UserLogin(string email, string password)
{
Response response = new Response();
if (string.IsNullOrEmpty(email))
{
response.Msg = "fail, email required";
}
else if (string.IsNullOrEmpty(password))
{
response.Msg = "fail, password required";
}
else
{
using (VehiclesSystemEntities db = new VehiclesSystemEntities())
{
DB.User user = (from u in db.Users
where u.Email == email &&
u.Password == password
select u).FirstOrDefault();
if (user == null)
{
response.Msg = "Account doesn't exist";
}
else
{
response.Msg = "success";
response.UserId = user.Id;
}
}
}
return(response);
}
public Response CreateUser(string firstName, string lastName, string email, string password, byte age, string mobileNumber)
{
int? AGE = age;
Response response = new Response();
if (string.IsNullOrEmpty(firstName))
{
response.Msg = "fail, first name required";
}
else if (string.IsNullOrEmpty(lastName))
{
response.Msg = "fail, last name required";
}
else if (string.IsNullOrEmpty(email))
{
response.Msg = "fail, email required";
}
else if (string.IsNullOrEmpty(password))
{
response.Msg = "fail, password required";
}
else if (!AGE.HasValue)
{
response.Msg = "fail, aged required";
}
else if (string.IsNullOrEmpty(mobileNumber))
{
response.Msg = "fail, mobile number required";
}
else
{
if (!IsEmailExist(email))
{
using (VehiclesSystemEntities db = new VehiclesSystemEntities())
{
DB.User user = new DB.User
{
FirstName = firstName,
LastName = lastName,
Email = email,
Password = password,
Age = age,
MobileNumber = mobileNumber
};
db.Users.Add(user);
db.SaveChanges();
response.UserId = user.Id;
response.Msg = "success";
}
}
else
{
response.Msg = "failed!, Email is exist";
}
}
return(response);
}
private bool IsEmailExist(string email)
{
using (VehiclesSystemEntities db = new VehiclesSystemEntities())
{
var result = (from u in db.Users
where u.Email == email
select u).FirstOrDefault();
if (result != null)
{
return(true);
}
else
{
return(false);
}
}
}
public Response ApproveVehicle(int Id)
{
Response response = new Response();
using (VehiclesSystemEntities db = new VehiclesSystemEntities())
{
var result = db.Vehicles.FirstOrDefault(v => v.Id == Id);
if (result != null)
{
result.WaitingForApprove = false;
db.SaveChanges();
response.Msg = "success";
}
else
{
response.Msg = "Fail!, wrong vehicle id";
}
}
return(response);
}
public Response GetUsers()
{
Response response = new Response();
using (VehiclesSystemEntities db = new VehiclesSystemEntities())
{
foreach (var item in db.Users)
{
Models.User user = new Models.User
{
FirstName = item.FirstName,
LastName = item.LastName,
Age = item.Age,
Email = item.Email,
MobileNumber = item.MobileNumber
};
response.Users.Add(user);
}
response.Msg = "success";
}
return(response);
}
public Response AddNewVehicle(int plateNumber, string plateText, string plateModel, string plateColor, int userId)
{
Response response = new Response();
int?PLATENUMBER = plateNumber;
if (!PLATENUMBER.HasValue)
{
response.Msg = "fail, plateNumber required";
}
if (string.IsNullOrEmpty(plateModel))
{
response.Msg = "fail, plateModel required";
}
if (string.IsNullOrEmpty(plateColor))
{
response.Msg = "fail, plateColor required";
}
int?USERID = userId;
if (!USERID.HasValue)
{
response.Msg = "fail, login first to add vehicles";
}
else
{
int plateTextId = 0;
if (plateText != "" && plateText != null)
{
using (VehiclesSystemEntities db = new VehiclesSystemEntities())
{
DB.PlateText plate = new DB.PlateText
{
Text = plateText
};
db.PlateTexts.Add(plate);
db.SaveChanges();
plateTextId = plate.Id;
}
}
using (VehiclesSystemEntities db = new VehiclesSystemEntities())
{
DB.Vehicle vehicle = new DB.Vehicle
{
PlateNumber = plateNumber,
PlateColor = plateColor,
PlateModel = plateModel,
UserId = userId,
WaitingForApprove = true
};
if (plateTextId != 0)
{
vehicle.PlateTextId = plateTextId;
}
db.Vehicles.Add(vehicle);
db.SaveChanges();
response.Msg = "success";
var UserInfo = (from u in db.Users
where u.Id == userId
select u).FirstOrDefault();
//SendEmail(plateNumber, plateText, plateColor, plateModel, UserInfo.FirstName,UserInfo.LastName,UserInfo.MobileNumber, UserInfo.Email, UserInfo.Age);
}
}
return(response);
}
