public static string GetChildrenChart(int parentId, bool isMainSubset)
{
using (var db = new SmartStoreContext())
{
var parent = db.Users.Find(parentId);
var userProfitManager = new UserProfitManager(db);
var userPoints = userProfitManager.GetUserPointsAmount(parent);
var content = $"<li><div class='user'><img src= '/Images/User/{parent.UserImage ?? "user-avatar.png"}' class='img-responsive' />" +
$"<div class='name'>{parent.UserFirstName} {parent.UserLastName}</div><div class='role'>{parent.Role.RoleTitle}</div><div class='role'>Points: {userPoints}</div>";
if (isMainSubset)
{
content += $"<button class='btn btn-sm btn-danger' onclick='btnRemoveSubset({parent.Id})'>Remove Subset</button>";
}
content += "</div>";
var children = db.Users.Where(u => u.UserIdentifierCode == parent.UserCode).ToList();
if (children.Any())
{
content += "<ul>";
children.ToList().ForEach(child =>
{
if (child.IsActive == true)
{
content += GetChildrenChart(child.Id, false);
}
});
content += "</ul>";
}
content += "</li>";
return(content);
}
}
public AuthRepository()
{
_ctx = new ApplicationDbContext();
_sctx = new SmartStoreContext();
_nctx = new NopCommerceContext();
_userManager = new ApplicationUserManager(new CustomUserStore(_ctx));
_roleManager = new ApplicationRoleManager(new CustomRoleStore(_ctx));
}
private static List <int> GetOperationTasks(int operationId)
{
var _db = new SmartStoreContext();
return((from tr in _db.AuthorizationItemsRelations
join t in _db.AuthorizationItems on tr.FirstItemId equals t.Id
where t.ItemType == (int)AuthorizationItemTypes.Task && tr.SecondItemId == operationId
select t.Id).ToList());
}
private static List <int> GetTasksRoles(List <int> taskIds)
{
var _db = new SmartStoreContext();
return((from rr in _db.AuthorizationItemsRelations
join r in _db.AuthorizationItems on rr.FirstItemId equals r.Id
where r.ItemType == (int)AuthorizationItemTypes.Role && taskIds.Contains(rr.SecondItemId)
select r.Id).ToList());
}
public SmartProductDtoValidator(SmartStoreContext context, SmartProductDto productDto)
{
RuleFor(x => x.Name)
.NotNull()
.NotEmpty()
.MinimumLength(1)
.MaximumLength(150);
RuleFor(x => x.Description)
.NotNull()
.NotEmpty()
.MaximumLength(4000);
RuleFor(x => x.Width)
.NotNull()
.GreaterThanOrEqualTo(0);
RuleFor(x => x.Height)
.NotNull()
.GreaterThanOrEqualTo(0);
RuleFor(x => x.Length)
.NotNull()
.GreaterThanOrEqualTo(0);
RuleFor(x => x.Weight)
.NotNull()
.GreaterThanOrEqualTo(0);
RuleFor(x => x.StockQuantity)
.NotNull()
.GreaterThanOrEqualTo(0);
RuleFor(x => x.IsAvailable)
.NotNull();
RuleFor(x => x.Price)
.NotNull()
.GreaterThanOrEqualTo(0);
RuleFor(x => x.ManufacturerId)
.NotEmpty()
.Must(id => context.Manufacturers.Any(product => product.Id == productDto.ManufacturerId))
.WithErrorCode($"Specified ManufacturerId: {productDto.ManufacturerId} does not exists for table Manufacturers.")
.WithMessage("Please specify existing manufacturer.");
RuleFor(x => x.CategoryId)
.NotNull()
.NotEmpty()
.Must(id => context.Categories.Any(product => product.Id.Equals(productDto.CategoryId)))
.WithErrorCode($"Specified CategoryId: {productDto.CategoryId} does not exists for table Category.")
.WithMessage("Please specify existing category.");
}
public int GetGroupProductCount(int id)
{
var count = 0;
using (var context = new SmartStoreContext())
{
count += context.Products.Where(p => p.ProductGroupId == id && (p.IsDeleted != true && p.ProductNotShow == false)).Count();
var childrenGroupIds = context.ProductGroups.Where(p => (p.IsDeleted != true && p.GroupNotShow == false) && p.ParentId == id).Select(p => p.Id).ToList();
foreach (var item in childrenGroupIds.ToList())
{
count += GetGroupProductCount(item);
}
}
return(count);
}
public void Seed(SmartStoreContext context, DbOptions dbOptions, ILogger <SmartStoreContextSeeder> logger)
{
if (!dbOptions.Seed)
{
logger.LogInformation("Seed has not been activated.");
return;
}
var policy = CreatePolicy(logger, nameof(SmartStoreContextSeeder));
policy.ExecuteAsync(async() =>
{
await using (context)
{
await context.Database.MigrateAsync();
var manufacturers = GetPredefinedManufacturers();
if (!context.Manufacturers.Any())
{
await context.AddRangeAsync(manufacturers);
}
await context.SaveChangesAsync();
var categories = GetPredefinedCategories();
if (!context.Categories.Any())
{
await context.AddRangeAsync(categories);
}
await context.SaveChangesAsync();
var products = GetPredefinedProduct();
if (!context.Products.Any())
{
await context.AddRangeAsync(products);
await context.SaveChangesAsync();
LinkProductsWithManufacturersAndCategories(ref products, categories, manufacturers);
await context.SaveChangesAsync();
}
}
}).Wait();
}
public void Send(string To, string Body)
{
SmartStoreContext db = new SmartStoreContext();
SmsIrRestful.Token tokenInstance = new SmsIrRestful.Token();
string mobilenumber = To;
string code = Body;
var token = tokenInstance.GetToken("a151711852a2c88060d564d5", "09378971585");
//SmsIrRestful.UltraFast ultraFast = new SmsIrRestful.UltraFast();
//var uf = ultraFast.Send(token, new SmsIrRestful.UltraFastSend()
//{
// Mobile = Convert.ToInt64(mobilenumber),
// TemplateId = 5731,
// ParameterArray = new List<SmsIrRestful.UltraFastParameters>()
// {
// new SmsIrRestful.UltraFastParameters()
// {
// Parameter = "ثبت نام شما با موفقیت انجام شد کد فعال سازی شما" ,
// ParameterValue = code
// }
// }.ToArray()
//});
SmsIrRestful.VerificationCode verificationCode = new SmsIrRestful.VerificationCode();
var vc = verificationCode.Send(token, new SmsIrRestful.RestVerificationCode()
{
MobileNumber = mobilenumber,
Code = code
});
}
private static List <int> GetOperationRelations(int operationId)
{
var result = new List <int>();
var tasks = GetOperationTasks(operationId);
result.AddRange(tasks);
var roles = GetTasksRoles(tasks); //indirect
result.AddRange(roles);
var _db = new SmartStoreContext();
var opRoles = (from rr in _db.AuthorizationItemsRelations
join r in _db.AuthorizationItems on rr.FirstItemId equals r.Id
where r.ItemType == (int)AuthorizationItemTypes.Role && rr.SecondItemId == operationId
select r.Id).ToList();
result.AddRange(opRoles);
return(result);
}
public static bool HasAccess(string operationTitle)
{
//return true;
var _db = new SmartStoreContext();
var userName = HttpContext.Current.Session["UserName"].ToString();
var allOperation = new List <string>();
var operation = _db.AuthorizationItems.Where(w => w.Title.ToLower() == operationTitle.ToLower() &&
w.ItemType == (int)AuthorizationItemTypes.Operation).FirstOrDefault();
if (operation == null)
{
throw new Exception("Operation not found");
}
var operationRelations = GetOperationRelations(operation.Id);
var userHasAccess = _db.UserAuthorizations
.Where(w => (operationRelations.Contains(w.AuthorizationId) || w.AuthorizationId == operation.Id) &&
w.UserName == userName)
.Any();
return(userHasAccess);
}
public StoreProductsCommandHandler(SmartStoreContext context, IMapper mapper, ILogger <StoreProductsCommandHandler> logger)
{
_context = context;
_mapper = mapper;
_logger = logger;
}
public StoreManufacturerCommandHandler(SmartStoreContext context, IMapper mapper)
{
_context = context;
_mapper = mapper;
}
public SystemParameterRepository()
{
db = SmartStoreContext.GetInstance();
}
public UserProfitManager(SmartStoreContext db)
{
this.db = db;
}
public UserProfitManager()
{
this.db = new SmartStoreContext();
}
public GetProductQueryHandler(SmartStoreContext context, IMapper mapper)
{
_context = context;
_mapper = mapper;
}
public GetCategoriesQueryHandler(SmartStoreContext context, IMapper mapper)
{
_context = context;
_mapper = mapper;
}
public StoreCategoryCommandHandler(SmartStoreContext context)
{
_context = context;
}