public void CreateLoggerInstance()
{
if (logger == null)
{
logger = new BkoLog();
}
}
public IList ExecuteDatabaseFunction2(SqlParameter[] parameters, string functionName, SqlParameter outParam, out int totalRow)
{
try
{
var command = String.Empty;
command += "exec " + functionName;
IList <SqlParameter> sqlParams = new List <SqlParameter>();
for (int i = 0; i <= parameters.Length - 2; i++)
{
command += " @" + parameters[i].ParameterName;
sqlParams.Add(new SqlParameter()
{
ParameterName = parameters[i].ParameterName,
Value = parameters[i].Value,
SqlDbType = parameters[i].SqlDbType
});
if (parameters[i].ParameterName != parameters[parameters.Length - 2].ParameterName)
{
command += ", ";
}
}
if (outParam != null)
{
command += ", @" + outParam.ParameterName + " OUT";
sqlParams.Add(new SqlParameter()
{
ParameterName = outParam.ParameterName,
Value = outParam.Value,
SqlDbType = outParam.SqlDbType,
Direction = outParam.Direction,
});
}
var data =
this.Database.SqlQuery <Result>(
command, sqlParams.ToArray());
var result = data.ToList();
totalRow = 0;
return(result);
}
catch (Exception ex)
{
BkoLog logger = new BkoLog();
logger.Logger.Fatal(ex);
totalRow = 0; return(null);
}
}
