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