public ActionResult Register(Car model) { CarsDTO dto = new CarsDTO(); CarsDAO dao = new CarsDAO(); if (ModelState.IsValid) { dto.Name = model.Name; dto.Price = model.Price; if (model.Price < 1000000) { ViewBag.msg = "Too Low Price!!!"; return(View("Index")); } else { var login = Session["login1"]; UserDTO dto1 = new UserDTO(); dto1.TxtLogin = (string)login; dao.purchaseCar(dto1, dto); return(View("Index")); } } return(View("Signup")); }
public async Task <CarsDTO> GetCarPrice(int id) { var client = _httpClientFactory.CreateClient(Constants.ClientWithToken); var response = await client.GetAsync <CarsDTO>(string.Format(Constants.Routes.GetCarById, id)); var price = response.Object.RetailPrice.GetValueOrDefault(); //get vat var response2 = await client.GetAsync <decimal>(string.Format(Constants.Routes.CalculateVAT, price)); var vat = response2.Object; var total = price + vat; var totalstring = CurrencyConverter.formatAmount(total); var pricestring = CurrencyConverter.formatAmount(price); var VatString = CurrencyConverter.formatAmount(vat); var model = new CarsDTO { TotalToPay = totalstring, Amount = pricestring, VAT = VatString }; return(model); }
public static void Query1() { InitializeMapperQ1(); using (var db = new CarDealerContext()) { var xmlDoc = new XDocument(); var cars = new CarsDTO() { Cars = db.Cars .ProjectTo <CarDTO>() .Where(c => c.travelledDistance > 2 * Math.Pow(10, 6)) .OrderBy(c => c.make).ThenBy(c => c.model) .ToList() }; var serializer = new XmlSerializer(typeof(CarsDTO)); var writer = new StreamWriter("../../Export/cars.xml"); using (writer) { serializer.Serialize(writer, cars); } } }
public async Task <IActionResult> AddCarPost(CarsDTO model) { var client = _httpClientFactory.CreateClient(Constants.ClientWithToken); model.Color = model.Colors.ToString(); model.Status = model.Statuses.ToString(); model.Condition = model.Conditions.ToString(); CarColor col = StringToEnumConverter.ParseEnum <CarColor>("Ash"); var response = await client.PostAsJsonAsync <CarsDTO, bool>(Constants.Routes.AddCar, model); var items = response.Object; if (response.ValidationErrors.Count > 0) { TempData["error"] = "An Error Occurred " + response.Code + ": " + response.ShortDescription; return(View("AddNewCar", model)); //return RedirectToAction("AddNewCar"); } else { //return View("AddNewCar", model); return(RedirectToAction("GetAllCars")); } }
public List <CarsDTO> getRecord(UserDTO udto) { SqlDataReader dr; DBHelper db = new DBHelper(); int uid = getUserID(udto); //int cid = getCarID(cdto); string q = "select * from Cars c,PurchaseRecord p,Users u where u.UID = " + uid + " and p.UID = " + uid + " and c.CID = p.CID "; try { dr = db.ExecuteReader(q); List <CarsDTO> list = new List <CarsDTO>(); while (dr.Read()) { CarsDTO dto = new CarsDTO(); dto.Name = dr["CName"].ToString().Trim(); dto.Price = Convert.ToInt32(dr["CPrice"]); list.Add(dto); } return(list); } catch (Exception ex) { return(null); } }
public void purchaseCar(UserDTO udto, CarsDTO cdto) { DBHelper db = new DBHelper(); int uid = getUserID(udto); int cid = getCarID(cdto); string q = "insert into PurchaseRecord (UID,CID) values(" + uid + "," + cid + ")"; int i = db.ExecuteQuery(q); }
public int getCarID(CarsDTO dto) { DBHelper db = new DBHelper(); string q = "select * from Cars where CName = '" + dto.Name + "'"; SqlDataReader dr = db.ExecuteReader(q); int id = 0; string l = ""; while (dr.Read()) { l = dr["CName"].ToString().Trim(); if (dto.Name == l) { id = Convert.ToInt32(dr["CID"]); return(id); } } return(id); }
public async Task <IActionResult> EditVehiclePost(CarsDTO model) { var httpClient = _httpClientFactory.CreateClient(Constants.ClientWithToken); model.Color = model.Colors.ToString(); model.Status = model.Statuses.ToString(); model.Condition = model.Conditions.ToString(); //post var url = string.Format(Constants.Routes.UpdateCar, model.Id); var response = await httpClient.PutAsync <CarsDTO, bool>(url, model); var items = response.Object; if (response.ValidationErrors.Count > 0 || items == false) { TempData["error"] = "An Error Occurred " + response.ShortDescription; return(RedirectToAction("GetAllCars")); } else { return(RedirectToAction("GetAllCars")); } }