public void QueryCloseOrder(SqlConnection conn, SessionQh session, FineQh fine)
{
string sql;
if (fine != null)
{
sql = "update Session set End_datetime = @dateclosed where Session_ID = @sessionid;" +
"insert into Car_Return(Session_ID, Fine_ID) Values (@sessionid, @fineid);" +
"insert into Payments(Session_ID, Date_time) Values (@sessionid, @dateclosed);";
}
else
{
sql = "update Session set End_datetime = @dateclosed where Session_ID = @sessionid;" +
"insert into Car_Return(Session_ID) Values (@sessionid);" +
"insert into Payments(Session_ID, Date_time) Values (@sessionid, @dateclosed);";
}
var cmd = new SqlCommand()
{
Connection = conn,
CommandText = sql
};
if (fine != null)
{
cmd.Parameters.Add("@fineid", SqlDbType.Int).Value = fine.Fine_ID;
}
cmd.Parameters.Add("@dateclosed", SqlDbType.DateTime).Value = DateTime.Now;
cmd.Parameters.Add("@sessionid", SqlDbType.Int).Value = session.Session_ID;
cmd.ExecuteNonQuery();
}
public List <FineQh> QueryFines(SqlConnection conn)
{
var fines = new List <FineQh>();
var sql = "select * from Fine";
var cmd = new SqlCommand
{
Connection = conn,
CommandText = sql
};
using (DbDataReader reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
var fId = reader.GetInt32(0);
var fDesc = reader.GetString(1);
var fCost = reader.GetInt32(2);
var tempFine = new FineQh()
{
Fine_ID = fId,
Fine_description = fDesc,
Fine_cost = fCost
};
fines.Add(tempFine);
}
}
}
return(fines);
}