public void pStartinPayment(string name, string surname, string email) { SqlConnection connect = new SqlConnection(SqlConnectionString.ConnectionString()); connect.Open(); SqlCommand selectcommand2 = connect.CreateCommand(); selectcommand2.CommandText = "[dbo].[pStartingFee]"; selectcommand2.CommandType = CommandType.StoredProcedure; selectcommand2.CommandTimeout = 3000; SqlParameter param = new SqlParameter("name", name); SqlParameter param2 = new SqlParameter("surname", surname); SqlParameter param3 = new SqlParameter("email", email); param.Direction = ParameterDirection.Input; param2.Direction = ParameterDirection.Input; param3.Direction = ParameterDirection.Input; selectcommand2.Parameters.Add(param); selectcommand2.Parameters.Add(param2); selectcommand2.Parameters.Add(param3); SqlDataReader read2 = selectcommand2.ExecuteReader(); read2.Close(); connect.Close(); }
public DataTable getDataFromBase() { DataTable dt = new DataTable(); string query = "select * from marathonOffice.vListParticipantsInOfficeRegisterCondition "; SqlConnection connect = new SqlConnection(SqlConnectionString.ConnectionString()); try { connect.Open(); SqlCommand selectcommand2 = connect.CreateCommand(); selectcommand2.CommandText = query; selectcommand2.CommandType = CommandType.Text; SqlDataAdapter adapter = new SqlDataAdapter(selectcommand2); adapter.Fill(dt); connect.Close(); return(dt); } catch (Exception ex) { string err = ex.Message; return(null); } }
public void pInitializationAllParticipnat() { SqlConnection connect = new SqlConnection(SqlConnectionString.ConnectionString()); connect.Open(); SqlCommand selectcommand2 = connect.CreateCommand(); selectcommand2.CommandText = "[dbo].[pInitilizationParticipant]"; selectcommand2.CommandType = CommandType.StoredProcedure; selectcommand2.CommandTimeout = 3000; SqlDataReader read2 = selectcommand2.ExecuteReader(); read2.Close(); connect.Close(); }
public void pCreateEmptyStartList() { SqlConnection connect = new SqlConnection(SqlConnectionString.ConnectionString()); connect.Open(); SqlCommand selectcommand2 = connect.CreateCommand(); selectcommand2.CommandText = "[dbo].[pCreateEmptyStartList]"; selectcommand2.CommandType = CommandType.StoredProcedure; selectcommand2.CommandTimeout = 3000; SqlDataReader read2 = selectcommand2.ExecuteReader(); read2.Close(); connect.Close(); }
public void pStartParticipantFromList(int list_id) { SqlConnection connect = new SqlConnection(SqlConnectionString.ConnectionString()); connect.Open(); SqlCommand selectcommand2 = connect.CreateCommand(); selectcommand2.CommandText = "[participant].[pStartParticipantFromList]"; selectcommand2.CommandType = CommandType.StoredProcedure; selectcommand2.CommandTimeout = 3000; SqlParameter param = new SqlParameter("list_id", list_id); param.Direction = ParameterDirection.Input; selectcommand2.Parameters.Add(param); SqlDataReader read2 = selectcommand2.ExecuteReader(); read2.Close(); connect.Close(); }