public void AddTravelOrder(TravelOrder to)
{
using (SqlConnection con = new SqlConnection(cs))
{
con.Open();
SqlTransaction transaction = con.BeginTransaction();
try
{
using (SqlCommand cmd = con.CreateCommand())
{
cmd.CommandText = $"INSERT INTO TravelOrder VALUES('{to.Distance}', '{to.StartDate}', '{to.EndDate}', '{to.TravelOrderTypeID}', '{to.DriverID}', '{to.StartCityID}', '{to.FinishCityID}', '{to.CarID}')";
cmd.CommandType = CommandType.Text;
transaction.Commit();
cmd.ExecuteNonQuery();
}
}
catch (Exception)
{
transaction.Rollback();
throw;
}
}
}
public void EditTravelOrder(TravelOrder to)
{
using (SqlConnection con = new SqlConnection(cs))
{
con.Open();
SqlTransaction transaction = con.BeginTransaction();
try
{
using (SqlCommand cmd = con.CreateCommand())
{
cmd.CommandText = $"UPDATE TravelOrder SET Distance = '{to.Distance}', StartDate = '{to.StartDate}', EndDate = '{to.EndDate}', TravelOrderTypeID = '{to.TravelOrderTypeID}', DriverID = '{to.DriverID}', StartCityID = '{to.StartCityID}', FinishCityID = '{to.FinishCityID}', CarID = '{to.CarID}' WHERE IDTravelOrder = '{to.IDTravelOrder}'";
cmd.CommandType = CommandType.Text;
transaction.Commit();
cmd.ExecuteNonQuery();
}
}
catch (Exception)
{
transaction.Rollback();
throw;
}
}
}
