static void Main(string[] args) { //List<User> mechanics = new ServiserDbContext().Users // .Where(x=>x.CustomerProfile.Id==null ).ToList(); //foreach(User u in mechanics) //{ // System.Console.WriteLine(u.FirstName+" "+u.MechanicProfile.Id); //} //System.Console.WriteLine("Seeding..."); ServiserDbContext db = new ServiserDbContext(); // double d = 5; //List<User> user = db.Users.Where(x=>((DateTime)DateTime.Now-(DateTime)x.RegisterationDateTime).TotalSeconds>d).ToList(); //foreach(User user1 in user) { // System.Console.WriteLine(user1.FirstName); } //System.Console.WriteLine((DateTime.Now-user.RegisterationDateTime).TotalSeconds); // while (db.Database.Exists()) // { // System.Console.WriteLine("Database Already Exists. Manually Delete the database and hit Enter."); // System.Console.ReadLine(); // } new ServiserDbInitialSeed().Run(); //System.Console.WriteLine("Seeding Done."); //System.Console.ReadLine(); }
// GET: Admin/Mechanic public ActionResult Index() { IdentityRole role = RoleService.GetRoleByName(RoleService.MECHANIC); List <User> mechanics = new ServiserDbContext().Users .Where(x => x.Roles.Select(y => y.RoleId).Contains(role.Id)).ToList(); return(View(mechanics)); }
public ActionResult Edit(AccountEditViewModel accountEditViewModel, HttpPostedFileBase profileImage) { ServiserDbContext db = new ServiserDbContext(); User user = User.Identity.GetUser(true); if (user.Id == accountEditViewModel.UserId) { user.FirstName = accountEditViewModel.FirstName; user.LastName = accountEditViewModel.LastName; user.Email = accountEditViewModel.Email; user.PhoneNumber = accountEditViewModel.PhoneNumber; user.UserName = accountEditViewModel.Email; } if (user.MechanicProfile != null && user.MechanicProfile.Id == accountEditViewModel.MechanicProfileId) { user.MechanicProfile.CNIC = accountEditViewModel.CNIC; } if (user.CustomerProfile != null && user.CustomerProfile.Id == accountEditViewModel.CustomerProfileId) { } if (profileImage.ContentLength > 0) { string remoteDirectoryPath = "~/Data_Files/UserProfileImages/"; string remoteFilePath = remoteDirectoryPath + Guid.NewGuid().ToString() + Path.GetFileName(profileImage.FileName); string localPath = Server.MapPath(remoteFilePath); Directory.CreateDirectory(Server.MapPath(remoteDirectoryPath)); profileImage.SaveAs(localPath); if (user.ProfileImageUrl != null && !String.IsNullOrWhiteSpace(user.ProfileImageUrl)) { string localFilePath = Server.MapPath(user.ProfileImageUrl); if (System.IO.File.Exists(localFilePath)) { System.IO.File.Delete(localFilePath); user.ProfileImageUrl = null; } } user.ProfileImageUrl = remoteFilePath; } db.Entry(user).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index", "Home")); }
public ActionResult GenerateBill() { ServiserDbContext db = new ServiserDbContext(); Problems problemsModel = new Problems(); problemsModel.BikeProblems = db.VehicleProblems .Where(x => x.VehicleType.Name == VehicleTypeService.BIKE) .ToList(); problemsModel.CarProblems = db.VehicleProblems .Where(x => x.VehicleType.Name == VehicleTypeService.CAR) .ToList(); return(View(problemsModel)); }
public ActionResult Pricing() { ServiserDbContext db = new ServiserDbContext(); List <VehicleProblem> bikeproblems = db.VehicleProblems.Where(x => x.VehicleType.Name == "Bike").ToList(); List <VehicleProblem> carproblems = db.VehicleProblems.Where(x => x.VehicleType.Name == "Car").ToList(); Problems problemsModel = new Problems(); problemsModel.BikeProblems = bikeproblems; problemsModel.CarProblems = carproblems; return(View(problemsModel)); }
public static User GetUser(this IIdentity user, Boolean eagerLoad = false) { string id = user.GetUserId(); ServiserDbContext db = new ServiserDbContext(); User u = eagerLoad ? db.Users.Where(x => x.Id == id) .Include(x => x.MechanicProfile) .Include(x => x.CustomerProfile) .Include(x => x.Roles) .FirstOrDefault() : db.Users.Where(x => x.Id == id).FirstOrDefault(); return(u); }
static void Main(string[] args) { ServiserDbContext db = new ServiserDbContext(); List<VehicleProblem> lis = db.VehicleProblems.Include(v => v.VehicleType).ToList(); // List<VehicleProblem> lis = vehicleProblems.ToList(); foreach (VehicleProblem d in lis) { System.Console.WriteLine(d.Name + " " + d.EstimatedPrice + " ==> " + d.VehicleTypeId); } //System.Console.WriteLine("Seeding..."); //ServiserDbContext db = new ServiserDbContext(); //while (db.Database.Exists()) //{ // System.Console.WriteLine("Database Already Exists. Manually Delete the database and hit Enter."); // System.Console.ReadLine(); //} //new ServiserDbInitialSeed().Run(); //System.Console.WriteLine("Seeding Done."); //System.Console.ReadLine(); }
public void VerifySelectedProblems(int[] Problems) { ServiserDbContext db = new ServiserDbContext(); List <VehicleProblem> vehicleProblems = db.VehicleProblems.Where(x => Problems.Contains(x.Id)).ToList(); }
public ServiserDbInitialSeed() { DbContext = new ServiserDbContext(); }