public static CustomerViewModel GetAllRequestedMechanics(int currentUserId)
{
using (VehicleAssistanceDbContext db = new VehicleAssistanceDbContext())
{
var customerId = db.CustomerDetails.Where(s => s.UserId == currentUserId).Select(s => s.CustomerDetailId).FirstOrDefault();
var mechanicRequestId = db.CustomerRequests.Where(s => s.CustomerId == customerId).ToList();
List <CustomerModel> UsersData = new List <CustomerModel>();
foreach (var items in mechanicRequestId)
{
CustomerModel userDetail = db.Users.Join(db.MechanicsDetails, x => x.UserId, y => y.UserId, (x, y) => new
{
x,
y
}).Where(s => s.y.MechanicsDetailId == items.MechanicId).Select(f =>
new CustomerModel
{
RequestId = items.RequestId,
FirstName = f.x.FirstName,
LastName = f.x.LastName,
PhoneNumber = f.x.PhoneNumber,
Location = f.y.Location
}).FirstOrDefault();
UsersData.Add(userDetail);
}
var customers = new CustomerViewModel
{
Customer = UsersData
};
return(customers);
}
}
public ActionResult Login(string username, string password)
{
using (VehicleAssistanceDbContext db = new VehicleAssistanceDbContext())
{
var isAuthenticated = db.Users.Where(s => (s.UserName == username && s.Password == password)).Count();
if (isAuthenticated == 1)
{
var currentUserRole = db.Users.Join(db.Roles, x => x.RoleId, y => y.RoleId, (x, y) => new { u = x, r = y }).Where(s => s.u.UserName == username).Select(s => s.r.RoleName).FirstOrDefault();
if (currentUserRole == "Mechanic")
{
var IsBlock = db.MechanicsDetails.Join(db.Users, x => x.UserId, y => y.UserId, (x, y) => new { m = x, u = y }).Where(s => s.u.UserName == username).Select(s => s.m.IsBlock).FirstOrDefault();
if (IsBlock == true)
{
return(Json(new { result = 2, UserRole = currentUserRole }, JsonRequestBehavior.AllowGet));
}
}
var currentUserId = db.Users.Where(s => s.UserName == username).Select(s => s.UserId).FirstOrDefault();
Session["currentUser"] = username;
Session["currentUserId"] = currentUserId;
Session["currentUserRole"] = currentUserRole;
return(Json(new { result = 1, UserRole = currentUserRole }, JsonRequestBehavior.AllowGet));
}
}
return(Json(new { result = 3 }, JsonRequestBehavior.AllowGet));
}
public static MechanicsViewModel GetCustomerRequest(int currentUserId)
{
using (VehicleAssistanceDbContext db = new VehicleAssistanceDbContext())
{
var machanicId = db.MechanicsDetails.Where(s => s.UserId == currentUserId).Select(s => s.MechanicsDetailId).FirstOrDefault();
var customerRequestId = db.CustomerRequests.Where(s => s.MechanicId == machanicId).ToList();
List <UsersModel> UsersData = new List <UsersModel>();
foreach (var items in customerRequestId)
{
UsersModel userDetail = db.Users.Join(db.CustomerDetails, x => x.UserId, y => y.UserId, (x, y) => new
{
x,
y
}).Where(s => s.y.CustomerDetailId == items.CustomerId).Select(f =>
new UsersModel
{
UserId = f.x.UserId,
RequestId = items.RequestId,
UserName = f.x.UserName,
FirstName = f.x.FirstName,
LastName = f.x.LastName,
PhoneNumber = f.x.PhoneNumber,
CarType = f.y.CarType
}).FirstOrDefault();
UsersData.Add(userDetail);
}
var customers = new MechanicsViewModel
{
Users = UsersData
};
return(customers);
}
}
public static bool AddNewUserData(RegisterModel _model)
{
using (VehicleAssistanceDbContext db = new VehicleAssistanceDbContext())
{
User addNewUser = new User();
addNewUser = _model.User;
db.Users.Add(addNewUser);
if (addNewUser.RoleId == 2)
{
CustomerDetail newCust = new CustomerDetail();
newCust = _model.CustomerDetail;
newCust.UserId = addNewUser.UserId;
db.CustomerDetails.Add(newCust);
}
else if (addNewUser.RoleId == 3)
{
MechanicsDetail newMech = new MechanicsDetail();
newMech = _model.MechanicsDetail;
newMech.UserId = addNewUser.UserId;
newMech.IsBlock = false;
db.MechanicsDetails.Add(newMech);
}
db.SaveChanges();
}
return(true);
}
public JsonResult isUserExist(string username)
{
using (VehicleAssistanceDbContext db = new VehicleAssistanceDbContext())
{
var user = db.Users.Where(s => s.UserName == username).Count();
if (user >= 1)
{
return(Json(new { result = true }, JsonRequestBehavior.AllowGet));
}
return(Json(new { result = false }, JsonRequestBehavior.AllowGet));
}
}
public static bool SaveCustomerFeedback(int requestId, int currentUserId, string feebackdata)
{
using (VehicleAssistanceDbContext db = new VehicleAssistanceDbContext())
{
Feedback feedBack = new Feedback();
feedBack.RequestId = requestId;
feedBack.UserId = currentUserId;
feedBack.FeedbackData = feebackdata;
db.Feedbacks.Add(feedBack);
db.SaveChanges();
}
return(true);
}
public static bool SendRequest(int currentUserId, int mechanicId)
{
using (VehicleAssistanceDbContext db = new VehicleAssistanceDbContext())
{
var customerId = db.CustomerDetails.Where(s => s.UserId == currentUserId).Select(s => s.CustomerDetailId).FirstOrDefault();
CustomerRequest custR = new CustomerRequest();
custR.MechanicId = mechanicId;
custR.CustomerId = customerId;
db.CustomerRequests.Add(custR);
db.SaveChanges();
}
return(true);
}
internal static UsersViewModel GetUsersfeedback()
{
using (VehicleAssistanceDbContext db = new VehicleAssistanceDbContext())
{
var feedBack = new UsersViewModel
{
feedback = db.Users.Join(db.Feedbacks, x => x.UserId, y => y.UserId, (x, y) => new { x, y }).Select(f => new UsersFeedbackModel
{
UserRoleId = f.x.RoleId,
FullName = f.x.FirstName + " " + f.x.LastName,
Feedbackdata = f.y.FeedbackData
}).ToList()
};
return(feedBack);
}
}
public static CustomerViewModel GetAllMechanics()
{
using (VehicleAssistanceDbContext db = new VehicleAssistanceDbContext())
{
var Mechanic = new CustomerViewModel
{
Customer = db.Users.Join(db.MechanicsDetails, x => x.UserId, y => y.UserId, (x, y) => new { x, y }).Where(s => (s.y.IsBlock != true)).Select(f => new CustomerModel
{
MechanicId = f.y.MechanicsDetailId,
FirstName = f.x.FirstName,
LastName = f.x.LastName,
PhoneNumber = f.x.PhoneNumber,
Location = f.y.Location,
}).ToList()
};
return(Mechanic);
}
}
public static UsersViewModel GetAllUsers(int RoleId)
{
using (VehicleAssistanceDbContext db = new VehicleAssistanceDbContext())
{
var customers = new UsersViewModel
{
Users = db.Users.Join(db.CustomerDetails, x => x.UserId, y => y.UserId, (x, y) => new { x, y }).Where(s => (s.x.RoleId == RoleId)).Select(f => new UsersModel
{
UserId = f.x.UserId,
UserName = f.x.UserName,
FirstName = f.x.FirstName,
LastName = f.x.LastName,
PhoneNumber = f.x.PhoneNumber,
CarType = f.y.CarType
}).ToList()
};
return(customers);
}
}
public static MechanicsViewModel GetAllMechanics(int RoleId)
{
using (VehicleAssistanceDbContext db = new VehicleAssistanceDbContext())
{
var Mechanic = new MechanicsViewModel
{
Mechanics = db.Users.Join(db.MechanicsDetails, x => x.UserId, y => y.UserId, (x, y) => new { x, y }).Where(s => (s.x.RoleId == RoleId)).Select(f => new MechanicsModel
{
UserId = f.x.UserId,
UserName = f.x.UserName,
FullName = f.x.FirstName + " " + f.x.LastName,
PhoneNumber = f.x.PhoneNumber,
Location = f.y.Location,
IsBlock = f.y.IsBlock
}).ToList()
};
return(Mechanic);
}
}
public ActionResult EnableDisable(int id)
{
bool status = false;
using (VehicleAssistanceDbContext db = new VehicleAssistanceDbContext())
{
var machnicId = db.MechanicsDetails.Join(db.Users, x => x.UserId, y => y.UserId, (x, y) => new { x, y }).Where(s => s.x.UserId == id).Select(s => (s.x.MechanicsDetailId)).FirstOrDefault();
var finddata = db.MechanicsDetails.Find(machnicId);
if (finddata.IsBlock == true)
{
finddata.IsBlock = false;
}
else
{
finddata.IsBlock = true;
status = true;
}
db.SaveChanges();
}
return(new JsonResult {
Data = status, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
