private IEnumerable <Client> GetClients()
{
using (FreelanceContext context = dataContextFactory.Create())
{
return(context.Clients.ToArray());
}
}
private void SubscribeUser(int userId, string userName)
{
using (FreelanceContext context = dataContextFactory.Create())
{
if (context.Clients.Any(x => x.Id == userId && x.IsActive == true))
{
return;
}
Client newClient = new Client
{
Id = userId,
Name = userName,
IsActive = true
};
bool userExists = context.Clients.Any(x => x.Id == userId);
if (userExists)
{
context.Clients.Update(newClient);
}
else
{
context.Clients.Add(newClient);
}
context.SaveChanges();
}
}
public IEnumerable <Client> GetClientsFromDatabase()
{
using (FreelanceContext context = dataContextFactory.Create())
{
return(context.Clients.ToArray());
}
}
public IActionResult CreateAnnouncemant(Announcemants model, IFormFile file)
{
using (FreelanceContext _context = new FreelanceContext())
{
string dirpath = Path.GetFullPath("/files/");
if (!Directory.Exists(dirpath))
{
Directory.CreateDirectory(dirpath);
}
string path = dirpath + file.FileName;
using (var stream = System.IO.File.Create(path))
{
file.CopyTo(stream);
}
model.UserId = _context.Accounts.Single(a => a.Login == User.Identity.Name).Id;
_context.Announcemants.Add(new Announcemants()
{
FullDescription = model.FullDescription,
MaxWage = model.MaxWage,
MinWage = model.MinWage,
Title = model.Title,
UserId = model.UserId,
WageTypeId = model.WageTypeId,
Deadline = model.Deadline,
PublicDate = DateTime.Now.Date,
FilePath = path,
});
_context.SaveChanges();
return(RedirectToAction("Index"));
}
}
public void EnsureDatabase()
{
using (FreelanceContext context = dataContextFactory.Create())
{
context.Database.EnsureCreated();
}
}
private void UnsubscribeUser(int userId, string userName)
{
using (FreelanceContext context = dataContextFactory.Create())
{
if (context.Clients.Any(x => x.Id == userId && x.IsActive == false))
{
return;
}
if (!context.Clients.Any(x => x.Id == userId))
{
return;
}
Client client = new Client
{
Id = userId,
Name = userName,
IsActive = false
};
context.Clients.Update(client);
context.SaveChanges();
}
}
public IActionResult CreateAnnouncemant()
{
using (FreelanceContext _context = new FreelanceContext())
{
ViewBag.WageTypes = _context.WagesType.ToList();
return(View());
}
}
protected override void SaveTasks(IEnumerable <FreelanceHuntItem> tasks)
{
using (FreelanceContext context = dataContextFactory.Create())
{
context.FreelanceHuntItems.AddRange(tasks);
context.SaveChanges();
}
}
public IActionResult AnnounmentInfo(int id)
{
using (FreelanceContext _context = new FreelanceContext())
{
var model = _context.Announcemants.Include(p => p.Binds).Include(p => p.User).Single(a => a.Id == id);
return(View(model));
}
}
public IActionResult Index()
{
using (FreelanceContext _context = new FreelanceContext())
{
var announcemants = _context.Announcemants.Include(i => i.WageType).Include(i => i.Binds).ToList();
return(View(announcemants));
}
}
public IActionResult Index()
{
using (FreelanceContext _db = new FreelanceContext())
{
string userLogin = User.Identity.Name;
var li = _db.Announcemants.Include(a => a.WageType).Include(a => a.Binds).Where(a => a.User.Login == userLogin).ToList();
return(View(li));
}
}
protected override int GetLatestTaskIdInDatabase()
{
using (FreelanceContext context = dataContextFactory.Create())
{
var latestTaskId = context.FreelanceHuntItems
.OrderByDescending(x => x.Id)
.Select(x => x.Id)
.FirstOrDefault();
return(latestTaskId);
}
}
public JsonResult CheckAuth()
{
using (FreelanceContext _context = new FreelanceContext())
{
bool useraccess = false;
var user = _context.Accounts.Include(u => u.Role).SingleOrDefault(u => u.Login == User.Identity.Name);
if (user != null)
{
useraccess = user.Role.Role == "Программист";
}
return(Json(useraccess));
}
}
public IActionResult AddMyBind(Announcemants model, string text)
{
using (FreelanceContext _context = new FreelanceContext())
{
var userId = _context.Accounts.Single(a => a.Login == User.Identity.Name).Id;
_context.Binds.Add(new Binds()
{
BindText = text,
UserId = userId,
AnnouncemantId = model.Id
});
_context.SaveChanges();
return(RedirectToAction("Index", "Dashboard"));
}
}
public IActionResult AnnounmentInfo(int id)
{
using (FreelanceContext _context = new FreelanceContext())
{
var Tprogramers = _context.Binds.Include(b => b.User).Include(b => b.User.Rang).Where(b => b.AnnouncemantId == id).ToList();
List <UserInfo> programers = new List <UserInfo>();
Tprogramers.ForEach(b =>
{
programers.Add(new UserInfo()
{
BindText = b.BindText,
FirstName = b.User.FirstName,
ImagePath = b.User.PhotoPath,
Rang = b.User.Rang.Rang,
Skills = b.User.SkillPoints.ToString()
});
});
return(View(programers));
}
}
public JsonResult GetUserInfo()
{
using (FreelanceContext _context = new FreelanceContext())
{
var model = _context.Accounts.Include(a => a.Role).Include(a => a.Rang).SingleOrDefault(a => a.Login == User.Identity.Name);
UserInfo ui = new UserInfo();
if (model != null)
{
ui = new UserInfo()
{
FirstName = model.FirstName,
Login = model.Login,
Role = model.Role.Role,
ImagePath = model.PhotoPath,
Rang = model.Rang.Rang,
Skills = model.SkillPoints.ToString()
};
}
return(ui != null?Json(ui) : Json("No"));
}
}
public Seeder(UserManager <User> usermanager, FreelanceContext context, RoleManager <Role> roleManager)
{
_usermanager = usermanager;
_context = context;
_rolemanager = roleManager;
}
public ProfileService(FreelanceContext profilecontext, CurrentUserInfo info)
{
_profilecontext = profilecontext;
_info = info;
}
public AccountController(UserManager <User> userManager, IOptions <TokenSettings> applicationSettings, FreelanceContext context)
{
_context = context;
_userManager = userManager;
_appSettings = applicationSettings.Value;
}
public UserService(FreelanceContext context, UserManager <User> userManager, CurrentUserInfo info)
{
_context = context;
_userManager = userManager;
_info = info;
}
public RequestService(FreelanceContext requestcontext, CurrentUserInfo info)
{
_requestcontext = requestcontext;
_info = info;
}
