// This method gets called by the runtime. Use this method to add services to the container.
public void ConfigureServices(IServiceCollection services)
{
services.AddControllersWithViews().AddRazorRuntimeCompilation();
services.AddSession();
services
.AddSingleton(Configuration)
.AddSingleton <IHttpContextAccessor, HttpContextAccessor>();
//*=== SETTING CONNECTION STRING ===*//
string dbConn = "";
if (HostEnvironment.IsDevelopment())
{
dbConn = Configuration.GetConnectionString("EKanbanWebDBConnection");
}
if (HostEnvironment.IsProduction())
{
DbConf db = new DbConf(Configuration, HostEnvironment);
dbConn = db.GetConnectionString();
}
services.AddDbContext <EKanbanWebDBContext>(options =>
options.UseSqlServer(dbConn,
sqlServerOptionsAction: sqlOptions =>
{
sqlOptions.EnableRetryOnFailure();
}));
//=========================================
services.Configure <IISServerOptions>(options =>
{
options.AutomaticAuthentication = false;
});
}
public DataTable ExecQuery(string sp, List <SqlParameter> parameters)
{
DataSet ds = new DataSet();
DataTable dt = new DataTable();
try
{
using SqlConnection con = new SqlConnection(_db.GetConnectionString());
con.Open();
using (SqlCommand comm = new SqlCommand("SET ARITHABORT ON", con))
{
comm.ExecuteNonQuery();
}
SqlCommand cmd = new SqlCommand(sp, con);
foreach (SqlParameter param in parameters)
{
cmd.Parameters.Add(param);
}
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 120;
SqlDataAdapter da = new SqlDataAdapter
{
SelectCommand = cmd
};
da.Fill(ds);
dt = ds.Tables[0];
con.Close();
}
catch (Exception e)
{
}
return(dt);
}
