/// <summary>
/// Create New Command type for Text and opens connection
/// </summary>
/// <param name="commandQuery">Query to execute</param>
/// <returns></returns>
public SqlCommand CreateTextCommand(string commandQuery, InsproConnection insproConnection)
{
SqlCommand insproCommand = new SqlCommand(commandQuery);
insproCommand.CommandType = CommandType.Text;
insproCommand.Connection = insproConnection.CreateConnection();
return(insproCommand);
}
/// <summary>
/// Create New Command type for Stored Procedure and opens connection
/// </summary>
/// <param name="commandQuery">Query to execute</param>
/// <returns></returns>
public SqlCommand CreateStoredCommand(string commandQuery, InsproConnection insproConnection, Dictionary <string, string> dicParameter)
{
SqlCommand insproCommand = new SqlCommand(commandQuery);
insproCommand.CommandType = CommandType.StoredProcedure;
foreach (KeyValuePair <string, string> key in dicParameter)
{
insproCommand.Parameters.Add(key.Key, key.Value);
}
insproCommand.Connection = insproConnection.CreateConnection();
return(insproCommand);
}