public int UpdateTravelOrder(TravelOrder trOrder) { int r; using (TransactionScope trScope = new TransactionScope()) { using (SqlConnection con = new SqlConnection(cs)) { con.Open(); using (SqlCommand cmd1 = con.CreateCommand()) { cmd1.CommandText = "update TravelOrder set OrderStatus = @param1, VehicleID = @param2, UserID = @param3," + " Vehicle_km_start = @param4, Starting_city = @param5, Finish_city = @param6, Total_days = @param7, StartingDate = @param8 where Id = @param9"; cmd1.CommandType = CommandType.Text; cmd1.Parameters.Add("@param1", SqlDbType.VarChar, 50).Value = trOrder.OrderStatus; cmd1.Parameters.Add("@param2", SqlDbType.NVarChar).Value = trOrder.VehicleID; cmd1.Parameters.Add("@param3", SqlDbType.NVarChar).Value = trOrder.DriverID; cmd1.Parameters.Add("@param4", SqlDbType.NVarChar).Value = trOrder.VehicleStartKM; cmd1.Parameters.Add("@param5", SqlDbType.NVarChar).Value = trOrder.StartingCity; cmd1.Parameters.Add("@param6", SqlDbType.NVarChar).Value = trOrder.FinishCity; cmd1.Parameters.Add("@param7", SqlDbType.NVarChar).Value = trOrder.TotalDays; cmd1.Parameters.Add("@param8", SqlDbType.DateTime).Value = trOrder.StartingDate; cmd1.Parameters.Add("@param9", SqlDbType.Int).Value = trOrder.Id; try { r = cmd1.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } } } trScope.Complete(); } if (r == 0) { return(400); } return(200); }
public int InsertTravelOrder(TravelOrder trOrder) { int result; using (TransactionScope trScope = new TransactionScope()) { using (SqlConnection con = new SqlConnection(cs)) { con.Open(); SqlCommand cmd1 = con.CreateCommand(); using (cmd1) { cmd1.CommandText = "insert into TravelOrder(OrderStatus, VehicleID, UserID, Vehicle_km_start, Starting_city, Finish_city, Total_days, StartingDate)" + " VALUES(@param1, @param2, @param3, @param4, @param5, @param6, @param7, @param8)"; cmd1.CommandType = CommandType.Text; cmd1.Parameters.Add("@param1", SqlDbType.VarChar, 50).Value = trOrder.OrderStatus; cmd1.Parameters.Add("@param2", SqlDbType.NVarChar).Value = trOrder.VehicleID; cmd1.Parameters.Add("@param3", SqlDbType.NVarChar).Value = trOrder.DriverID; cmd1.Parameters.Add("@param4", SqlDbType.NVarChar).Value = trOrder.VehicleStartKM; cmd1.Parameters.Add("@param5", SqlDbType.NVarChar).Value = trOrder.StartingCity; cmd1.Parameters.Add("@param6", SqlDbType.NVarChar).Value = trOrder.FinishCity; cmd1.Parameters.Add("@param7", SqlDbType.NVarChar).Value = trOrder.TotalDays; cmd1.Parameters.Add("@param8", SqlDbType.DateTime).Value = trOrder.StartingDate; try { result = cmd1.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } } } trScope.Complete(); } if (result == 0) { return(400); } return(200); }