public static AppraisalViewFormModel GetAppraisalViewModel(string vin)
{
var viewModel = new AppraisalViewFormModel();
var autoService = new ChromeAutoService();
var vehicleInfo = autoService.GetVehicleInformationFromVin(vin);
if (vehicleInfo != null)
{
viewModel = ConvertHelper.GetVehicleInfoFromChromeDecode(vehicleInfo);
viewModel.AppraisalDate = DateTime.Now.ToShortDateString();
}
if (viewModel.IsTruck)
{
viewModel.TruckTypeList = SelectListHelper.InitalTruckTypeList();
viewModel.TruckCategoryList = SelectListHelper.InitalTruckCategoryList(SQLHelper.GetListOfTruckCategoryByTruckType(viewModel.TruckTypeList.First().Value));
viewModel.TruckClassList = SelectListHelper.InitalTruckClassList();
}
return(viewModel);
}
private string GetMSRPFromChrome(string vinNumber)
{
var autoService = new ChromeAutoService();
var vehicleInfo = autoService.GetVehicleInformationFromVin(vinNumber);
return(vehicleInfo.basePrice.msrp.high.ToString());
}
public static JavaScriptModel GetJavaScripModel(string vin, DealershipViewModel dealer)
{
var autoService = new ChromeAutoService();
var model = new JavaScriptModel();
if (SQLHelper.CheckVinExist(vin, dealer))
{
var context = new whitmanenterprisewarehouseEntities();
var row = context.whitmanenterprisedealershipinventories.FirstOrDefault(x => x.VINNumber == vin && x.DealershipId == dealer.DealershipId);
model.ListingId = row.ListingID.ToString(CultureInfo.InvariantCulture);
model.Status = "Inventory";
}
else if (SQLHelper.CheckVinExistInSoldOut(vin, dealer))
{
var context = new whitmanenterprisewarehouseEntities();
var row = context.whitmanenterprisedealershipinventorysoldouts.FirstOrDefault(x => x.VINNumber == vin && x.DealershipId == dealer.DealershipId);
model.ListingId = row.ListingID.ToString(CultureInfo.InvariantCulture);
model.Status = "SoldOut";
}
else if (SQLHelper.CheckVinExistInAppraisal(vin, dealer))
{
var context = new whitmanenterprisewarehouseEntities();
var row = context.whitmanenterpriseappraisals.FirstOrDefault(x => x.VINNumber == vin && x.DealershipId == dealer.DealershipId);
model.AppraisalId = row.idAppraisal.ToString(CultureInfo.InvariantCulture);
model.Status = "Appraisal";
//return RedirectToAction("ViewProfileForAppraisal", "Appraisal", new { AppraisalId = row["AppraisalID"].ToString() });
}
else
{
var vehicleInfo = autoService.GetVehicleInformationFromVin(vin);
if (vehicleInfo != null)
{
model.Vin = vin;
model.Status = "VinProcessing";
}
else
{
model.Vin = vin;
model.Status = "VinInvalid";
}
}
return(model);
}
public static InspectionAppraisalViewModel GetPendingAppraisal(int id)
{
var model = new InspectionAppraisalViewModel();
//try
//{
var receivedAppraisalId = Convert.ToInt32(id);
using (var context = new whitmanenterprisewarehouseEntities())
{
var existingAppraisal = context.whitmanenterpriseappraisals.Where(a => a.idAppraisal == receivedAppraisalId).FirstOrDefault();
if (existingAppraisal != null)
{
model.AppraisalInfo = new AppraisalInfo()
{
AppraisalId = existingAppraisal.idAppraisal,
VinNumber = existingAppraisal.VINNumber ?? "",
StockNumber = existingAppraisal.StockNumber ?? "",
Year = existingAppraisal.ModelYear ?? 2012,
Make = existingAppraisal.Make ?? "",
Model = existingAppraisal.Model ?? "",
Trim = existingAppraisal.Trim ?? "",
ExteriorColor = existingAppraisal.ExteriorColor ?? "",
InteriorColor = existingAppraisal.InteriorColor ?? "",
Transmission = existingAppraisal.Tranmission ?? "",
Odometer = existingAppraisal.Mileage ?? "",
Cylinders = existingAppraisal.Cylinders ?? "",
Liters = existingAppraisal.Liters ?? "",
Doors = existingAppraisal.Doors ?? "",
Fuel = existingAppraisal.FuelType ?? "",
MSRP = existingAppraisal.MSRP ?? "",
DriveType = existingAppraisal.DriveTrain ?? "",
ImageUrl = existingAppraisal.DefaultImageUrl,
Photo = existingAppraisal.Photo,
Options = String.IsNullOrEmpty(existingAppraisal.CarsOptions) ? new List <string>() : existingAppraisal.CarsOptions.Split(',').ToList(),
Packages = String.IsNullOrEmpty(existingAppraisal.CarsPackages) ? new List <string>() : existingAppraisal.CarsPackages.Split(',').ToList(),
StandardOptions = String.IsNullOrEmpty(existingAppraisal.StandardOptions) ? new List <string>() : existingAppraisal.StandardOptions.Split(',').ToList(),
AppraisalDate = existingAppraisal.DateStamp.HasValue ? existingAppraisal.DateStamp.Value.ToShortDateString() : String.Empty,
AppraisalTime = existingAppraisal.DateStamp.HasValue ? existingAppraisal.DateStamp.Value.ToShortTimeString() : String.Empty,
EngineType = existingAppraisal.EngineType,
AppraisalBy = GetAppraisalName(existingAppraisal.UserStamp)
};
var autoService = new ChromeAutoService();
if (!(String.IsNullOrEmpty(model.AppraisalInfo.VinNumber)) && model.AppraisalInfo.VinNumber != "None")
{
var vehicleInfo = autoService.GetVehicleInformationFromVin(model.AppraisalInfo.VinNumber);
model.AppraisalInfo.StandardOptions = InitializeOptions(vehicleInfo.standard).Select(o => o.Text).ToList();
}
else
{
IdentifiedString[] divisionList = autoService.GetDivisions(model.AppraisalInfo.Year);
var make = SelectListHelper.InitialMakeList(divisionList).Where(m => m.Text.Equals(model.AppraisalInfo.Make)).First();
var chromeModel = autoService.GetModelsByDivision(model.AppraisalInfo.Year, Convert.ToInt32(make.Value.Split('|')[0])).Where(m => m.Value.Equals(model.AppraisalInfo.Model)).FirstOrDefault();
if (chromeModel != null)
{
var styles = autoService.GetStyles(chromeModel.id);
int styleId = Convert.ToInt32(styles.First().id);
var styleInfo = autoService.GetStyleInformationFromStyleId(styleId);
model.AppraisalInfo.StandardOptions = InitializeOptions(styleInfo.standard).Select(o => o.Text).ToList();
}
}
model.CustomerInfo = new CustomerInfo()
{
FirstName = existingAppraisal.FirstName,
LastName = existingAppraisal.LastName,
Phone = existingAppraisal.Phone,
Email = existingAppraisal.Email,
City = existingAppraisal.City,
State = existingAppraisal.State,
Zip = existingAppraisal.ZipCode,
Street = existingAppraisal.Street,
Signature = existingAppraisal.Signature
};
var walkarounds = context.vincontrolwalkarounds.Where(i => i.whitmanenterpriseappraisal.idAppraisal == receivedAppraisalId).OrderBy(i => i.order).ToList();
if (walkarounds.Count > 0)
{
model.WalkaroundInfo = walkarounds.Select(w => new WalkaroundInfo()
{
Order = w.order ?? 0,
Note = GetNoteContent(w.note, w.order),
X = w.x ?? 0,
Y = w.y ?? 0
});
}
//var answers =
// context.vincontrolanswers.Where(i => i.whitmanenterpriseappraisal.idAppraisal == receivedAppraisalId).Select(
// a => new AppraisalAnswer()
// {
// Question = a.vincontrolquestions.shortdescription,
// Answer = a.answer,
// Comment = a.comment,
// QuestionType = a.vincontrolquestions.vincontrolquestiontype.code??4
// }).ToList();
var answers =
context.vincontrolanswers.Where(i => i.whitmanenterpriseappraisal.idAppraisal == receivedAppraisalId).Select(
a => new
{
QuestionId = a.vincontrolquestion.questionid,
Question = a.vincontrolquestion.shortdescription,
Answer = a.answer,
Comment = a.comment,
QuestionType = a.vincontrolquestion.vincontrolquestiontype.code ?? 4,
Order = a.vincontrolquestion.order
}).ToList();
//AppraisalAnswer()
var questions = context.vincontrolquestions.Include("vincontrolquestiontype");
var list = new List <AppraisalAnswer>();
foreach (var question in questions)
{
var answer = answers.FirstOrDefault(a => a.QuestionId == question.questionid);
if (answer != null)
{
list.Add(new AppraisalAnswer()
{
Question = answer.Question,
Answer = GetAnswer(answer.Answer, question.vincontrolquestiontype.unit),
Comment = GetShortString(answer.Comment),
QuestionType = answer.QuestionType,
Order = answer.Order ?? 0
});
}
else
{
list.Add(new AppraisalAnswer()
{
Question = question.shortdescription,
Answer = String.Empty,
Comment = String.Empty,
QuestionType = question.vincontrolquestiontype.code ?? 4,
Order = question.order ?? 0
});
}
}
if (answers.Count > 0)
{
model.AppraisalAnswer = list.OrderBy(o => o.Order);
}
else
{
model.AppraisalAnswer = list;
}
}
}
//}
//catch (Exception)
//{
//}
return(model);
}