/// <summary>
/// Get Count of Total Rows of Campaign
/// </summary>
/// <returns></returns>
public async Task <int> TotalRecords()
{
using (CRMDbContext context = new CRMDbContext())
{
return(await context.Campaigns.CountAsync());
}
}
/// <summary>
/// Get Campaign Detail
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public async Task <Campaign> Get(int ID)
{
using (CRMDbContext context = new CRMDbContext())
{
return(await context.Campaigns.FirstAsync(compaign => compaign.ID == ID));
}
}
/// <summary>
/// Get all compaign data
/// </summary>
/// <returns></returns>
public async Task <List <Campaign> > Get(int take = 10, int skip = 0)
{
using (CRMDbContext context = new CRMDbContext())
{
return(await context.Campaigns.OrderByDescending(x => x.ID).Skip(skip).Take(take).ToListAsync());
}
}
public AccountController(UserManager <User> _userManager, SignInManager <User> _signInManager, CRMDbContext context, IWebHostEnvironment appEnvironment)
{
db = context;
userManager = _userManager;
signInManager = _signInManager;
_appEnvironment = appEnvironment;
}
public HomeController(ILogger <HomeController> logger, CRMDbContext context, RoleManager <IdentityRole> role, UserManager <User> user)
{
_logger = logger;
db = context;
roleManager = role;
userManager = user;
}
/// <summary>
/// New Campaign
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public async Task <bool> Add(Campaign model)
{
using (CRMDbContext context = new CRMDbContext())
{
context.Campaigns.Add(model);
return(await context.SaveChangesAsync() > 0 ? true : false);
}
}
/// <summary>
/// Update Compaign
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public async Task <bool> Update(Campaign model)
{
using (CRMDbContext context = new CRMDbContext())
{
context.Entry(model).State = EntityState.Modified;
return(await context.SaveChangesAsync() > 0 ? true : false);
}
}
public AdminControllerTests()
{
optionsBuilder = new DbContextOptionsBuilder <CRMDbContext>();
optionsBuilder.UseInMemoryDatabase("Tests DB");
contextMemory = new CRMDbContext(optionsBuilder.Options);
_appEnvironment = new Mock <IWebHostEnvironment>();
_appEnvironment.Setup(host => host.ContentRootPath).Returns(@"C:\");
_appEnvironment.Setup(host => host.WebRootPath).Returns(@"C:\");
}
public static void SeedHostDb(CRMDbContext context)
{
context.SuppressAutoSetTenantId = true;
// Host seed
new InitialHostDbBuilder(context).Create();
// Default tenant seed (in host database).
new DefaultTenantBuilder(context).Create();
new TenantRoleAndUserBuilder(context, 1).Create();
}
public static CRMDbContext GetContext()
{
DbContextOptionsBuilder <CRMDbContext> optionsBuilder =
new DbContextOptionsBuilder <CRMDbContext>().UseSqlServer(
ConfigurationManager.ConnectionStrings["CRMSystem"].ConnectionString);
CRMDbContext db = new CRMDbContext(optionsBuilder.Options);
return(db);
}
public static async Task CloseEventAsync(CRMDbContext db)
{
var events = db.Events.Where(e => e.Status != "Закрыто");
foreach (var item in events)
{
if (item.DeadLine.Date > DateTime.Now.Date)
{
item.Status = "Закрыто";
}
}
await db.SaveChangesAsync();
}
public static async Task FindNewRequestAsync(CRMDbContext db)
{
var events = db.Events.Include(e => e.Client);
foreach (var item in events)
{
if (item.CreatedDate.Date == DateTime.Now.Date.AddDays(14) && db.Missions.Where(m => m.MissionText == $"Предложить клиенту проведение мероприятия. Заявка создана автоматически на основе уже проводившегося {item.DeadLine.ToShortDateString()} мероприятия <a href=/events/view?id={item.Id}>{item.Name}</a>").FirstOrDefault() == null)
{
var req = new Mission()
{
Employeer = db.GetMustFreedomManager(), MissionType = "Автоматическая заявка", Status = "Создано", MissionText = $"Предложить клиенту проведение мероприятия. Заявка создана автоматически на основе уже проводившегося {item.DeadLine.ToShortDateString()} мероприятия <a href=/events/view?id={item.Id}>{item.Name}</a>", CreatedDate = DateTime.Now, Event = await db.Events.FirstOrDefaultAsync(), DeadLine = DateTime.Now.AddDays(3)
};
await db.Missions.AddAsync(req);
}
}
await db.SaveChangesAsync();
}
public static async Task FindDeadlineAsync(CRMDbContext db)
{
var tasks = db.Missions.Include(m => m.Employeer);
foreach (var item in tasks)
{
if (item.LeftTime.TotalSeconds < 0 && item.Status != "Закрыто" && item.IsFailed == false)
{
item.IsFailed = true;
var notice = new Notice
{
EmployeerId = item.EmployeerId,
EmployeerName = item.Employeer.Name,
Text = $"Провален дедлайн по <bold><a href=/Sight/Mission?id={item.Id}> задаче</a></bold> ",
MissionId = item.Id,
IsViewed = false,
Deadline = item.DeadLine
};
await db.Notices.AddAsync(notice);
}
}
}
public TestSubscriptionPaymentBuilder(CRMDbContext context, int tenantId)
{
_context = context;
_tenantId = tenantId;
}
private void ChangeRoleToUser(User user, EnterprisePosition position)
{
var roleName = "";
switch (position)
{
case EnterprisePosition.Financial:
user.EnterprisePosition = EnterprisePosition.Financial;
roleName = "Financial";
break;
case EnterprisePosition.Dealer:
user.EnterprisePosition = EnterprisePosition.Dealer;
roleName = "Dealer";
break;
default:
user.EnterprisePosition = EnterprisePosition.Admin;
roleName = "Admin";
break;
}
// TODO: Remove db context and find way for manipulating data in other way
var db = new CRMDbContext();
var role = db.Roles.FirstOrDefault(r => r.Name == roleName);
user.Roles.Add(new IdentityUserRole()
{
RoleId = role.Id,
UserId = user.Id
});
}
public TestOrganizationUnitsBuilder(CRMDbContext context, int tenantId)
{
_context = context;
_tenantId = tenantId;
}
public DefaultLanguagesCreator(CRMDbContext context)
{
_context = context;
}
//Внедрение зависимостей
public CallbackController(IVkApi vkApi, IConfiguration configuration, CRMDbContext context)
{
_vkApi = vkApi;
_configuration = configuration;
db = context;
}
public AJAXController(CRMDbContext context)
{
db = context;
}
public ArtistController(CRMDbContext context, IWebHostEnvironment appEnvironment)
{
db = context;
_appEnvironment = appEnvironment;
}
public WorksController(CRMDbContext context)
{
db = context;
}
public DefaultEditionCreator(CRMDbContext context)
{
_context = context;
}
public ContractController(CRMDbContext context, IWebHostEnvironment _appEnvironment)
{
db = context;
appEnvironment = _appEnvironment;
}
public TenantRoleAndUserBuilder(CRMDbContext context, int tenantId)
{
_context = context;
_tenantId = tenantId;
}
public OrderRepository(CRMDbContext dbContext)
{
_dbContext = dbContext ?? throw new ArgumentNullException(nameof(dbContext));
}
public InitialHostDbBuilder(CRMDbContext context)
{
_context = context;
}
public TestDataBuilder(CRMDbContext context, int tenantId)
{
_context = context;
_tenantId = tenantId;
}
public EventsController(CRMDbContext context)
{
db = context;
}
public Repository(CRMDbContext context)
{
_context = context;
}
public HostRoleAndUserCreator(CRMDbContext context)
{
_context = context;
}
public ClaimRepository(CRMDbContext context)
: base(context)
{
_context = context;
}
