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); } }