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