public T ExecuteScalarFunction <T>(string query, SqlServerParameter parameter, ExecuteTypeEnum type)
{
using (_con = new SqlConnection(ConnectionString))
{
_cmd = new SqlCommand
{
Connection = _con
};
_cmd.Parameters.Clear();
_cmd.CommandType = type == ExecuteTypeEnum.StoredProcedure ? CommandType.StoredProcedure : CommandType.Text;
_cmd.CommandText = query;
_cmd.CommandTimeout = ConnectDbTimeOut;
if (parameter != null)
{
_cmd.Parameters.AddRange(parameter.ToArray());
}
SqlParameter returnValue = _cmd.Parameters.Add("@RETURN_VALUE", SqlDbType.Text);
returnValue.Direction = ParameterDirection.ReturnValue;
_con.Open();
_cmd.ExecuteNonQuery();
if (_con.State == ConnectionState.Open)
{
_con.Close();
}
return((T)returnValue.Value);
}
}
public void ExecuteNonQuery(string query, SqlServerParameter parameter, ExecuteTypeEnum type)
{
using (_con = new SqlConnection(ConnectionString))
{
_con.Open();
_cmd = new SqlCommand
{
Connection = _con,
CommandType = type == ExecuteTypeEnum.StoredProcedure
? CommandType.StoredProcedure
: CommandType.Text,
CommandText = query,
CommandTimeout = ConnectDbTimeOut
};
if (parameter != null)
{
_cmd.Parameters.AddRange(parameter.ToArray());
}
_cmd.ExecuteNonQuery();
_con.Dispose();
if (_con.State == ConnectionState.Open)
{
_con.Close();
}
}
}
public DataTable ExecuteToTable(string query, SqlServerParameter parameter, ExecuteTypeEnum type)
{
using (_con = new SqlConnection(ConnectionString))
{
_con.Open();
_cmd = new SqlCommand
{
Connection = _con
};
_cmd.Parameters.Clear();
_cmd.CommandType = type == ExecuteTypeEnum.StoredProcedure ? CommandType.StoredProcedure : CommandType.Text;
_cmd.CommandText = query;
_cmd.CommandTimeout = ConnectDbTimeOut;
if (parameter != null)
{
_cmd.Parameters.AddRange(parameter.ToArray());
}
_adapter = new SqlDataAdapter(_cmd);
DataTable tbl = new DataTable();
_adapter.Fill(tbl);
_adapter.Dispose();
if (_con.State == ConnectionState.Open)
{
_con.Close();
}
return(tbl);
}
}
public T ExecuteScalar <T>(string query, SqlServerParameter parameter, ExecuteTypeEnum type)
{
using (_con = new SqlConnection(ConnectionString))
{
_con.Open();
_cmd = new SqlCommand
{
Connection = _con,
CommandType = type == ExecuteTypeEnum.StoredProcedure
? CommandType.StoredProcedure
: CommandType.Text,
CommandText = query,
CommandTimeout = ConnectDbTimeOut
};
if (parameter != null)
{
_cmd.Parameters.AddRange(parameter.ToArray());
}
object obj = _cmd.ExecuteScalar();
_con.Close();
return((T)obj);
}
}