private float CalcPrice(string regNum) { float cost = 0; using (SqlConnection connection = new SqlConnection(CONNECTION_STRING)) { connection.Open(); Console.WriteLine("Search result: "); SqlCommand dateCommand = new SqlCommand("SELECT v.InTime, v.VehicleTypeId FROM Vehicles V INNER JOIN VehicleTypes vh ON vh.Id = V.VehicleTypeId WHERE V.RegNum = @regNum; ", connection); SqlParameter priceAndTypeParam = new SqlParameter(); priceAndTypeParam.ParameterName = "@regNum"; priceAndTypeParam.Value = regNum; dateCommand.Parameters.Add(priceAndTypeParam); SqlDataReader searchResult = dateCommand.ExecuteReader(); DateTime date = new DateTime(); bool isCar = false; while (searchResult.Read()) { //searchReport = TextFormater.VehicleSearchResult((int)searchResult[0], // (string)searchResult[1], // (int)searchResult[2], // regNum); date = (DateTime)searchResult[0]; isCar = (int)searchResult[1] == 1 ? true : false; //Console.WriteLine("{0}", // searchResult[0]); // searchResult[1]); } cost = CalculatePrice.GetCost(date, isCar); } return(cost); }
public void TestData() { DbHandler handler = new DbHandler(); List <string> regnums = new List <string>(); DateTime now = DateTime.Now; for (int i = 0; i < 50; i++) { string regNum = "QUE" + "-00" + i.ToString(); int carType = (i % 2) + 1; handler.CheckInVehicle(regNum, carType); regnums.Add(regNum); DateTime inDate = now.AddHours(-i * 10); Thread.Sleep(10); ChangeInDate(regNum, inDate); Thread.Sleep(10); handler.CheckOutVehicle(regNum); Thread.Sleep(10); ChangeInDateHistory(regNum, inDate, inDate.AddHours(1), (decimal)CalculatePrice.GetCost(inDate, inDate.AddHours(1), carType == 1 ? true : false)); Thread.Sleep(10); } //handler.CheckOutVehicle(regNum); }