// 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());
}
