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