// GET: CrewLeader public ActionResult Index() { LeaderServiceDayViewModel model = new LeaderServiceDayViewModel(); var userid = User.Identity.GetUserId(); DateTime serviceDate = DateTime.Now.Date; var serviceDay = DateTime.Now.Date.DayOfWeek.ToString(); PrepareLeaderSerivceDayInformation(model, serviceDay, serviceDate, userid); return(View(model)); }
void PrepareLeaderSerivceDayInformation(LeaderServiceDayViewModel model, string serviceDay, DateTime serviceDate, string userid) { int TeamId = 0; model.ServiceDay = serviceDay; var result = db.Garage_CarDaySetting.Where(q => q.CarServiceDate == serviceDate && q.ServiceDay == serviceDay && q.EntityTypeKey == (int)EntityTypeKey.Leader && q.EntityTypeValue == userid).FirstOrDefault(); if (result != null) { model.ServiceDayRecordExists = true; TeamId = result.GarageTeamId; // Get all information like - leader, Member, Cars for the current day/ var TeamResultForDay = db.Garage_CarDaySetting.Where(q => q.CarServiceDate == serviceDate && q.ServiceDay == serviceDay && q.GarageTeamId == TeamId).ToList(); // Get Team Information. var team = db.GarageTeams.Where(t => t.Id == TeamId).SingleOrDefault(); model.TeamId = team.Id; model.TeamName = team.Title; // Get Garage Information. var garage = db.Garages.Where(g => g.GarageId == team.GarageId).SingleOrDefault(); model.GarageId = garage.GarageId; model.GarageName = garage.Garage_Name; // Get Leader Information. var leader = db.AspNetUsers.Where(u => u.Id == userid).SingleOrDefault(); model.LeaderId = leader.Id; model.LeaderName = leader.FirstName + " " + leader.LastName; // Get Leader Member Information. var memberList = db.Garage_CarDaySetting.Where(q => q.CarServiceDate == serviceDate && q.ServiceDay == serviceDay && q.EntityTypeKey == (int)EntityTypeKey.Member && q.GarageTeamId == model.TeamId).ToList(); if (memberList.Count > 0) { model.Members = new List <TeamMember>(); foreach (var member in memberList) { var aspMember = db.AspNetUsers.Where(u => u.Id == member.EntityTypeValue).SingleOrDefault(); if (aspMember != null) { model.Members.Add(new TeamMember() { MemberId = aspMember.Id, MemberName = aspMember.FirstName + " " + aspMember.LastName }); } } } // Get Car Information var CarList = db.Garage_CarDaySetting.Where(q => q.CarServiceDate == serviceDate && q.ServiceDay == serviceDay && q.EntityTypeKey == (int)EntityTypeKey.Car && q.IsPaid == true && q.GarageTeamId == model.TeamId).ToList(); if (CarList.Count > 0) { model.CarServicesList = new List <CarServices>(); foreach (var car in CarList) { int carId = Convert.ToInt32(car.EntityTypeValue); var aspCar = db.CarUsers.Where(c => c.CarId == carId).SingleOrDefault(); if (aspCar != null) { CarServices carService = new CarServices() { ServiceDayId = car.Id, CarId = aspCar.CarId, CarDisplayName = aspCar.DisplayName, Color = aspCar.Color, Make = aspCar.Make, PurchaseYear = aspCar.PurchaseYear, LicenseNumber = aspCar.LicenseNumber, serviceStatus = (ServiceStatus)car.ServiceStatusId }; //// Get Car Services Information //carService.SelectServices = new List<CarServices.SelectService>(); //var pCarId = new SqlParameter(); //pCarId.ParameterName = "CarId"; //pCarId.Value = aspCar.CarId; //pCarId.DbType = DbType.Int32; //var servicesList = db.Database.SqlQuery<GreenPro.Data.Service>( // "EXEC dbo.GetServicesByCarId @CarId", // pCarId // ).ToList(); //if (servicesList.Count > 0) //{ // foreach (var service in servicesList) // { // CarServices.SelectService seviceModel = new CarServices.SelectService(); // seviceModel.ServiceName = service.Service_Name; // carService.SelectServices.Add(seviceModel); // } //} model.CarServicesList.Add(carService); } } } } else { model.ServiceDayRecordExists = false; } }
public ActionResult Index(FormCollection fc) { LeaderServiceDayViewModel model = new LeaderServiceDayViewModel(); return(View()); }