public List <Category> SelectAll()
{
using (SqlConnection cn = new SqlConnection(DatabaseSettings.GetConnectionString()))
{
return(cn.Query <Category>("CategorySelectAll", commandType: CommandType.StoredProcedure).ToList());
}
}
public List <SubcategoryView> GetByViewCategoryId(int categoryId)
{
using (SqlConnection cn = new SqlConnection(DatabaseSettings.GetConnectionString()))
{
DynamicParameters p = new DynamicParameters();
p.Add("@CategoryID", categoryId);
return(cn.Query <SubcategoryView>("SubcategoryViewByCategory", p, commandType: CommandType.StoredProcedure).ToList());
}
}
public void Delete(int CategoryId)
{
using (SqlConnection cn = new SqlConnection(DatabaseSettings.GetConnectionString()))
{
DynamicParameters p = new DynamicParameters();
p.Add("@CategoryID", CategoryId);
cn.Execute("CategoryDelete", p, commandType: CommandType.StoredProcedure);
}
}
public void Insert(string CategoryName)
{
using (SqlConnection cn = new SqlConnection(DatabaseSettings.GetConnectionString()))
{
DynamicParameters p = new DynamicParameters();
p.Add("@CategoryName", CategoryName);
cn.Execute("CategoryInsert", p, commandType: CommandType.StoredProcedure);
}
}
public Category Select(int categoryId)
{
using (SqlConnection cn = new SqlConnection(DatabaseSettings.GetConnectionString()))
{
DynamicParameters p = new DynamicParameters();
p.Add("@CategoryID", categoryId);
return(cn.Query <Category>("CategorySelect", p, commandType: CommandType.StoredProcedure).FirstOrDefault());
}
}
public static DbContextOptionsBuilder <AppDbContext> UseOsDependentDbProvider(
this DbContextOptionsBuilder <AppDbContext> builder,
DatabaseSettings dbSettings)
{
if (builder == null)
{
throw new ArgumentNullException(nameof(builder));
}
if (dbSettings == null)
{
throw new ArgumentNullException(nameof(dbSettings));
}
var conStr = dbSettings.GetConnectionString();
return(dbSettings.ShouldUseSqlServer() ?
builder.UseSqlServer(conStr, opts => opts.MigrationsAssembly(DB_MIGRATIONS_ASSEMBLY_NAME)) :
builder.UseSqlite(conStr, opts => opts.MigrationsAssembly(DB_MIGRATIONS_ASSEMBLY_NAME)));
}
