public void r100Implementation(GameFlightScheduleModel instance, DateTime @Parameters_GameDate, DateTime @Parameters_FlightStart, DateTime @Parameters_FlightEnd, int @Parameters_IntervalInMinute, int @Parameters_MaxPlayer) { // This is the placeholder for method implementation. ///Exec dbo.USP_GameCreateFlight @Parameters_GameDate,@Parameters_FlightStart,@Parameters_FlightEnd,@Parameters_IntervalInMinute string conr = System.Configuration.ConfigurationManager.ConnectionStrings["MyCompany"].ConnectionString; SqlConnection connection = new SqlConnection(conr); if (connection.State == 0) { connection.Open(); } SqlCommand cmd = new SqlCommand("USP_GameCreateFlight", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@GameDate", SqlDbType.DateTime).Value = @Parameters_GameDate; cmd.Parameters.Add("@FlightStart", SqlDbType.DateTime).Value = @Parameters_FlightStart; cmd.Parameters.Add("@FlightEnd", SqlDbType.DateTime).Value = @Parameters_FlightEnd; cmd.Parameters.Add("@IntervalInMinute", SqlDbType.Int).Value = @Parameters_IntervalInMinute; cmd.Parameters.Add("@MaxPlayer", SqlDbType.Int).Value = @Parameters_MaxPlayer; try { int rowsAffected1 = cmd.ExecuteNonQuery(); } catch (Exception ex) { } }
public void r101Implementation(GameFlightScheduleModel instance) { // This is the placeholder for method implementation. }
public void r100Implementation(GameFlightScheduleModel instance, DateTime @Parameters_FlightStart, DateTime @Parameters_FlightEnd, int @Parameters_IntervalInMinute) { // This is the placeholder for method implementation. }