public static QuoteVM QuoteToBusinessEntity(l2g_tbl_Quote quote)
{
var quoteVM = new QuoteVM()
{
QuoteId = quote.QuoteId,
UserId = quote.UserId,
CarId = quote.CarId,
Price = quote.Price,
MileageId = quote.MileageId,
MonthId = quote.MonthId
};
using (var db = new Lead2OrderGenerateDbEntities())
{
var user = db.l2g_tbl_UserDetails.Find(quote.UserId);
quoteVM.Firstname = user.Firstname;
quoteVM.Lastname = user.Lastname;
var car = db.l2g_tbl_Car.Find(quote.CarId);
//quoteVM.Carname = car.CarName;
quoteVM.Model = car.Model;
quoteVM.Kilometer = db.l2g_tbl_Mileage.Find(quote.MileageId).Kilometer;
quoteVM.Months = db.l2g_tbl_PaybackTime.Find(quote.MonthId).Months;
}
return(quoteVM);
}
public async Task <IActionResult> SaveQuoteAsync(QuoteVM quote)
{
if (!ModelState.IsValid)
{
return(BadRequest(new ErrorMessageVM()
{
Message = "Quote is not valid!"
}));
}
else
{
var response = await _quoteManager.SaveQuoteAsync(quote);
if (response != null)
{
return(Ok(response));
}
else
{
return(BadRequest(new ErrorMessageVM()
{
Message = "Unable to save!"
}));
}
}
}
public async Task <ActionResult <QuoteVM> > CreateQuote(QuoteVM quoteVM)
{
try
{
if (quoteVM == null)
{
return(BadRequest());
}
// Add custom model validation error
Quote quote = await quoteRepository.GetQuoteByname(quoteVM.Quote);
if (quote != null)
{
ModelState.AddModelError("Name", $"Quote name: {quoteVM.Quote.Text} already in use");
return(BadRequest(ModelState));
}
await quoteRepository.CreateQuote(quoteVM);
return(CreatedAtAction(nameof(GetQuote),
new { id = quoteVM.Quote.Id }, quoteVM));
}
catch (DbUpdateException Ex)
{
return(StatusCode(StatusCodes.Status500InternalServerError,
Ex.InnerException.Message));
}
}
public async Task <QuoteVM> GetQuote(int id)
{
QuoteVM quoteVM = new QuoteVM();
quoteVM.Quote = await appDbContext.Quotes.FirstOrDefaultAsync(e => e.Id == id);
return(quoteVM);
}
public ActionResult Details(int id)
{
QuoteVM quote = QuoteVM.Map(quoteLogic.GetQuoteById(id));
ViewBag.QuoteId = quote.QuoteId;
ViewBag.Phrase = quote.Phrase;
return(View(quote));
}
public async Task <QuoteVM> CreateQuote(QuoteVM quoteVM)
{
var result = await appDbContext.Quotes.AddAsync(quoteVM.Quote);
await appDbContext.SaveChangesAsync();
quoteVM.Quote = result.Entity;
return(quoteVM);
}
public ActionResult Create(QuoteVM quote)
//[Bind(Include = "Id,CustomerID,AutoModelID,DrivingHistoryID,CoverageID,AutoOptionID,PriceQuote")]
{
CustomerDrivingHistory cdhDB = null;
if (Visitor.IsVisitor(quote.CustomerID)) //Save Visitor driving history
{
var list = db.CustomerDrivingHistories.Where(x => x.CustomerID == quote.CustomerID).OrderBy(x => x.DateRecorded).ToList();
if (list.Count > 0)
{
cdhDB = list.Last();
if (quote.NumDUIs != cdhDB.NumDUIs || quote.NumSpeedingTickets != cdhDB.NumSpeedingTickets) //the history changed
{
cdhDB = null; //set to null so that we record the new history
}
}
}
if (cdhDB is null)
{
cdhDB = new CustomerDrivingHistory
{
CustomerID = quote.CustomerID,
DateRecorded = DateTime.Now,
NumDUIs = quote.NumDUIs,
NumSpeedingTickets = quote.NumSpeedingTickets
};
db.CustomerDrivingHistories.Add(cdhDB);
_ = db.SaveChanges();
}
if (Visitor.IsVisitor(quote.CustomerID))
{
//save Visitor's birthday and driving history ID in a separate table for reference
var vs = new VisitorSession
{
DateOfBirth = quote.DateOfBirth,
DrivingHistoryId = cdhDB.Id
};
db.VisitorSessions.Add(vs);
_ = db.SaveChanges();
}
Quote quoteDB = new Quote();
quoteDB.CustomerID = quote.CustomerID;
quoteDB.AutoModelID = quote.AutoModelID;
quoteDB.AutoOptionID = quote.AutoOptionID;
quoteDB.CoverageID = quote.CoverageID;
quoteDB.DrivingHistoryID = cdhDB.Id;
quoteDB.DateIssued = DateTime.Now;
quoteDB.PriceQuote = BusinessLogic.QuoteLogic.GetPriceQuote(quoteDB);
db.Quotes.Add(quoteDB);
_ = db.SaveChanges();
return(RedirectToAction("Details", quoteDB));
}
// GET: Quote
public ActionResult AdminQuoteIndex()
{
List <QuoteVM> quotes = QuoteVM.Map(quoteLogic.GetQuotes());
foreach (QuoteVM quote in quotes)
{
quote.Rating = ratingLogic.GetRating(quote.RatingNumber);
quote.Category = categoryLogic.GetCategory(quote.CategoryNumber);
}
return(View(quotes));
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
string ver = Assembly.GetExecutingAssembly().GetName().Version.ToString();
QuoteVM quoteViewModel = ServiceLocator.Current.GetInstance <QuoteVM>();
_viewModel.AppTitle = string.Format("High Frequency Trading v{0} [{1}] ({2})",
ver, RuntimeContext.CurrentUserID, quoteViewModel.MarketDataServ.Name);
LogManager.Logger.Info("Window loaded, Connecting market...");
this._viewModel.Connect();
}
public ActionResult Delete(QuoteVM quote, int id)
{
try
{
quoteLogic.RemoveQuoteById(id);
return(RedirectToAction("AdminQuoteIndex"));
}
catch (Exception o)
{
return(View());
}
}
public ActionResult Create(QuoteVM quote)
{
try
{
quoteLogic.CreateQuote(QuoteVM.Map(quote));
return(RedirectToAction("AdminQuoteIndex"));
}
catch (Exception e)
{
return(View());
}
}
// GET: Quote
public ActionResult Index()
{
List <QuoteVM> quotes = QuoteVM.Map(quoteLogic.GetQuotes());
int userId = (int)Session["UserId"];
foreach (QuoteVM quote in quotes)
{
quote.HasRated = prevRateLogic.CheckPrevRate(userId, quote.QuoteId);
quote.Rating = ratingLogic.GetRating(quote.RatingNumber);
quote.Category = categoryLogic.GetCategory(quote.CategoryNumber);
}
return(View(quotes));
}
public ActionResult Edit(QuoteVM quote, int id)
{
try
{
quote.QuoteId = id;
quoteLogic.EditQuoteById(QuoteVM.Map(quote));
return(RedirectToAction("AdminQuoteIndex"));
}
catch (Exception p)
{
return(View());
}
}
private async Task <QuoteVM> CheckDeserialize(HttpResponseWrapper <QuoteVM> httpResponseWrapper)
{
QuoteVM quoteVM = new QuoteVM();
if (httpResponseWrapper.Success)
{
quoteVM = await Deserialize <QuoteVM>(httpResponseWrapper.HttpResponseMessage, defaultJsonSerializerOptions);
}
else
{
quoteVM.Exception = await httpResponseWrapper.GetBody();
}
return(quoteVM);
}
//GET: UpdateRating
public ActionResult UpdateRating(int rateId, int id)
{
int userId = (int)Session["UserId"];
QuoteVM quote = QuoteVM.Map(quoteLogic.GetQuoteById(id));
if (!prevRateLogic.CheckPrevRate(userId, quote.QuoteId))
{
quote.NumRatings += 1;
quote.RatingScore += rateId;
List <PrevRateSM> prevs = prevRateLogic.GetPrevRateByQuote(quote.QuoteId);
int seq = prevs.Count + 1;
prevRateLogic.AddPrevRate(userId, quote.QuoteId, seq);
quoteLogic.EditQuoteById(QuoteVM.Map(quote));
}
return(RedirectToAction("Index", "Quote"));
}
public async Task SaveQuoteAsync_When_Vaid_Quote_Returns_Quote(
[Frozen] Mock <IUnitOfWork> uow,
QuoteVM MoqResponse,
QuoteVM request,
[Greedy] QuoteManager sut
)
{
// Arrange
uow.Setup(x => x.QuoteRepository.SaveQuoteAsync(It.IsAny <QuoteVM>())).ReturnsAsync(MoqResponse);
// Act
var result = await sut.SaveQuoteAsync(request);
// Assert
Assert.NotNull(result);
}
// create an method for upsert and can get null Id in case of create
public IActionResult Upsert(int?id)
{
QuoteVM quoteVM = new QuoteVM()
{
Quote = new Quote(),
VendorList = _unitOfWork.Vendor.GetAll().Select(i => new SelectListItem {
Text = i.VendorName,
Value = i.Id.ToString()
}),
VendorContactList = _unitOfWork.VendorContact.GetAll().Select(i => new SelectListItem
{
Text = i.Name,
Value = i.Id.ToString()
}),
ShippingList = _unitOfWork.Shipping.GetAll().Select(i => new SelectListItem
{
Text = i.ShippingName,
Value = i.Id.ToString()
})
};
if (id == null) // create case
{
return(View(quoteVM));
}
// this for edit request
quoteVM.Quote = _unitOfWork.Quote.Get(id.GetValueOrDefault()); // To add stored procedure
//var parameter = new DynamicParameters(); // arrange parameters for sql server
//parameter.Add("@Id", id); // arrange to send the Id
// var objFromDb = _unitOfWork.Quote.Get(id);
//quote = _unitOfWork.SP_Call.OneRecord<Quote>(SD.Proc_Quote_Get, parameter);
if (quoteVM.Quote == null)
{
return(NotFound());
}
return(View(quoteVM));
// return View();
}
public async Task SaveQuote_When_InValid_Quote_Returns_BadRequestResponse(
[Frozen] Mock <IQuoteManager> _quoteManager,
QuoteVM request,
[Greedy] QuoteController sut)
{
// Arrange
_quoteManager.Setup(x => x.SaveQuoteAsync(It.IsAny <QuoteVM>())).ReturnsAsync((QuoteVM)null);
// Act
var result = await sut.SaveQuoteAsync(request);
var response = result as BadRequestObjectResult;
// Assert
Assert.NotNull(result);
Assert.Equal(400, response.StatusCode);
}
public ActionResult Admin()
{
using (InsuranceQuoteEntities db = new InsuranceQuoteEntities())
{
var quoteVMs = new List <QuoteVM>();
foreach (var quote in quoteVMs)
{
var quoteVM = new QuoteVM();
quoteVM.FirstName = quote.FirstName;
quoteVM.LastName = quote.LastName;
quoteVM.EmailAddress = quote.EmailAddress;
quoteVMs.Add(quoteVM);
}
return(View(quoteVMs));
}
}
// GET: Admin
public ActionResult Index()
{
using (AutoQuotesEntities db = new AutoQuotesEntities())
{
var quotes = db.QuoteLists.ToList();
var quotesVms = new List <QuoteVM>();
foreach (var quote in quotes)
{
var quoteVm = new QuoteVM();
quoteVm.firstName = quote.firstName;
quoteVm.lastName = quote.lastName;
quoteVm.emailAddress = quote.emailAddress;
quoteVm.completedQuote = quote.completedQuote;
quotesVms.Add(quoteVm);
}
return(View(quotesVms));
}
}
// GET: Admin
public ActionResult Index()
{
using (InsuranceEntities db = new InsuranceEntities())
{
var quoteVMs = new List <QuoteVM>();
foreach (var quote in db.Quotes)
{
var quoteVM = new QuoteVM();
quoteVM.Id = quote.Id;
quoteVM.FirstName = quote.FirstName;
quoteVM.LastName = quote.LastName;
quoteVM.EmailAddress = quote.EmailAddress;
quoteVM.MonthlyFee = (int)quote.MonthlyFee;
quoteVMs.Add(quoteVM);
}
return(View(quoteVMs));
}
}
public ActionResult Admin()
{
string queryString = @"SELECT Id, FirstName, LastName, EmailAddress, DateOfBirth, CarYear, CarMake, CarModel, DUI, SpeedingTickets, TypeOfCoverage, QuoteAmount from Application";
List <Application> quotes = new List <Application>();
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand(queryString, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
var quote = new Application();
quote.Id = Convert.ToInt32(reader["Id"]);
quote.FirstName = reader["FirstName"].ToString();
quote.LastName = reader["LastName"].ToString();
quote.EmailAddress = reader["EmailAddress"].ToString();
quote.DateOfBirth = Convert.ToDateTime(reader["DateOfBirth"]);
quote.CarYear = Convert.ToInt32(reader["CarYear"]);
quote.CarMake = reader["CarMake"].ToString();
quote.CarModel = reader["CarModel"].ToString();
quote.DUI = Convert.ToBoolean(reader["DUI"]);
quote.SpeedingTickets = Convert.ToInt32(reader["SpeedingTickets"]);
quote.TypeOfCoverage = Convert.ToBoolean(reader["TypeOfCoverage"]);
quote.QuoteAmount = Convert.ToDouble(reader["QuoteAmount"]);
quotes.Add(quote);
}
}
var quoteVMs = new List <QuoteVM>();
foreach (var quote in quotes)
{
var quoteVM = new QuoteVM();
quoteVM.FirstName = quote.FirstName;
quoteVM.LastName = quote.LastName;
quoteVM.EmailAddress = quote.EmailAddress;
quoteVM.QuoteAmount = quote.QuoteAmount;
quoteVMs.Add(quoteVM);
}
return(View(quoteVMs));
}
// GET: Admin
public ActionResult Index()
{
using (CarInsuranceQuoteEntities1 db = new CarInsuranceQuoteEntities1())
{
var quotes = (from x in db.Quotes select x).ToList();
var quoteVms = new List <QuoteVM>();
foreach (var quote in quotes)
{
var quoteVm = new QuoteVM();
quoteVm.Id = quote.Id;
quoteVm.FirstName = quote.FirstName;
quoteVm.LastName = quote.LastName;
quoteVm.EmailAddress = quote.EmailAddress;
quoteVm.QuoteAmount = Convert.ToInt16(quote.QuoteAmount);
quoteVms.Add(quoteVm);
}
return(View(quoteVms));
}
}
// GET: Admin
public ActionResult Index()
{
using (InsuranceEntities db = new InsuranceEntities())
{
List <Insuree> quotes = db.Insurees.Where(x => x.Quote > 0).ToList();
var quoteVms = new List <QuoteVM>();
foreach (var quote in quotes)
{
var quoteVm = new QuoteVM();
quoteVm.FirstName = quote.FirstName;
quoteVm.LastName = quote.LastName;
quoteVm.EmailAddress = quote.EmailAddress;
quoteVm.Quote = Convert.ToString(quote.Quote);
quoteVms.Add(quoteVm);
}
return(View(quoteVms));
}
}
//GET: QuoteByCategory
public ActionResult QuoteByCategory(string category)
{
int userId = (int)Session["Userid"];
Session["Category"] = category;
List <QuoteVM> quotes = QuoteVM.Map(quoteLogic.GetQuotes());
List <QuoteVM> qs = new List <QuoteVM>();
foreach (QuoteVM quote in quotes)
{
quote.HasRated = prevRateLogic.CheckPrevRate(userId, quote.QuoteId);
quote.Rating = ratingLogic.GetRating(quote.RatingNumber);
quote.Category = categoryLogic.GetCategory(quote.CategoryNumber);
if (quote.Category == category)
{
qs.Add(quote);
}
}
return(View(qs));
}
// GET: Admin
public ActionResult Index()
{
using (InsuranceEntities db = new InsuranceEntities())
{
var quoteVMs = new List <QuoteVM>();
var quotes = (from c in db.Quotes where c.Removed == null select c).ToList();
foreach (var quote in quotes)
{
var quoteVM = new QuoteVM();
quoteVM.Id = quote.Id;
quoteVM.FirstName = quote.FirstName;
quoteVM.LastName = quote.LastName;
quoteVM.EmailAddress = quote.EmailAddress;
quoteVM.Total = Convert.ToInt32(quote.Total);
quoteVMs.Add(quoteVM);
}
return(View(quoteVMs));
}
}
public async Task <QuoteVM> UpdateQuote(QuoteVM quoteVM)
{
Quote result = await appDbContext.Quotes
.FirstOrDefaultAsync(e => e.Id == quoteVM.Quote.Id);
if (result != null)
{
appDbContext.Entry(result).State = EntityState.Detached;
result = mapper.Map(quoteVM.Quote, result);
appDbContext.Entry(result).State = EntityState.Modified;
await appDbContext.SaveChangesAsync();
return(new QuoteVM {
Quote = result
});
}
return(null);
}
// GET: Admin
public ActionResult Index()
{
using (QuotesEntities db = new QuotesEntities())
{
var quotes = db.Users.ToList();
var quoteVMs = new List <QuoteVM>();
foreach (var quote in quotes)
{
var quoteVM = new QuoteVM();
quoteVM.Id = quote.Id;
quoteVM.FirstName = quote.First_Name;
quoteVM.LastName = quote.Last_Name;
quoteVM.EmailAddress = quote.Email_Address;
quoteVM.Quote = quote.Quote.GetValueOrDefault();
quoteVMs.Add(quoteVM);
}
return(View(quoteVMs));
}
}
// GET: Admin
public ActionResult Index()
{
using (InsuranceEntities4 db = new InsuranceEntities4())
{
var quotes = (from c in db.QuoteeInfoes
where c.Id > 0
select c).ToList();
var quotesVms = new List <QuoteVM>();
foreach (var quote in quotes)
{
var quoteVm = new QuoteVM();
{
quoteVm.FirstName = quote.FirstName;
quoteVm.LastName = quote.LastName;
quoteVm.EmailAddress = quote.EmailAddress;
quoteVm.Quote = quote.Quote;
}
quotesVms.Add(quoteVm);
}
return(View(quotesVms));
}
}
// GET: Admin
public ActionResult Index()
{
using (Car_Insurance_QuoteEntities db = new Car_Insurance_QuoteEntities())
{
List <Quote> quotes = db.Quotes.ToList(); // Creates a List of all quotes from the DB.
var quoteVMs = new List <QuoteVM>(); // Instantiates a View Model List, DB info is mapped into it.
// Maps pertinent info from the DB to the View Model.
foreach (var quote in quotes)
{
QuoteVM quoteVM = new QuoteVM();
quoteVM.FirstName = quote.FirstName;
quoteVM.LastName = quote.LastName;
quoteVM.Email = quote.Email;
quoteVM.Total = quote.Total;
quoteVMs.Add(quoteVM); // Add the quote into the View Model.
}
return(View(quoteVMs));
}
}
