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; }