public void ExecuteInsertParamters(string script, List <MySqlParameter> parameters)
{
SunConnection Storeconn = new SunConnection();
MySqlConnection connection = Storeconn.Create();
try
{
MySqlCommand command = connection.CreateCommand();
command.CommandTimeout = 20;
command.CommandText = script;
if (parameters != null)
{
foreach (MySqlParameter param in parameters)
{
command.Parameters.Add(param);
}
}
command.ExecuteNonQuery();
}
finally
{
connection.Close();
}
}
public int ExecuteInsertInt(string script, List <MySqlParameter> parameters)
{
SunConnection Storeconn = new SunConnection();
MySqlConnection connection = Storeconn.Create();
MySqlCommand command = connection.CreateCommand();
command.CommandTimeout = 20;
command.CommandText = script;
if (parameters != null)
{
foreach (MySqlParameter param in parameters)
{
command.Parameters.Add(param);
}
}
command.ExecuteNonQuery();
connection.Close();
int id = Convert.ToInt32(command.LastInsertedId);
return(id);
}
public MySqlDataReader ExecuteSelect(string script)
{
SunConnection StoreConn = new SunConnection();
MySqlConnection connection = StoreConn.Create();
MySqlCommand command = connection.CreateCommand();
command.CommandTimeout = 20;
command.CommandText = script;
MySqlDataReader reader = command.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
return(reader);
}
public void ExecuteInsert(string script)
{
SunConnection Storeconn = new SunConnection();
MySqlConnection connection = Storeconn.Create();
try
{
MySqlCommand command = connection.CreateCommand();
command.CommandTimeout = 20;
command.CommandText = script;
command.ExecuteNonQuery();
}
finally
{
connection.Close();
}
}
public MySqlDataReader ExecuteSelectParamters(string script, List <MySqlParameter> parameters)
{
SunConnection StoreConn = new SunConnection();
MySqlConnection connection = StoreConn.Create();
MySqlCommand command = connection.CreateCommand();
command.CommandTimeout = 20;
command.CommandText = script;
if (parameters != null)
{
foreach (MySqlParameter param in parameters)
{
command.Parameters.Add(param);
}
}
MySqlDataReader reader = command.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
return(reader);
}
