public void Delete(long personId) { try { using (var db = new DatabaseContainer()) { Person p = db.Persons .Include("User") .Include("Candidate") .Include("Candidate.Evaluation") .Include("Candidate.Decision") .Where(x => x.Id == personId).First(); db.Entry(p.Candidate.Evaluation).State = System.Data.Entity.EntityState.Deleted; db.Entry(p.Candidate.Decision).State = System.Data.Entity.EntityState.Deleted; db.Entry(p.Candidate).State = System.Data.Entity.EntityState.Deleted; db.Entry(p.User).State = System.Data.Entity.EntityState.Deleted; db.Entry(p).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); } } catch (Exception e) { } }
public void Editar(Categoria categoria) { //state estado do registro //entry entrada contexto.Entry(categoria).State = System.Data.Entity.EntityState.Modified; contexto.SaveChanges(); }
// PUT api/Item/5 public HttpResponseMessage PutItem(int id, Item item) { if (!ModelState.IsValid) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } if (id != item.ID) { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } db.Entry(item).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException ex) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, ex)); } return(Request.CreateResponse(HttpStatusCode.OK)); }
public bool Authenticate(string email, byte[] token, out byte attemptsLeft) { if (_salt == null || _authenticated) { attemptsLeft = 255; return(false); } using (var db = new DatabaseContainer()) { var query = from u in db.UsersSet where u.Email == email select u; if (query.Count() == 0) { attemptsLeft = 255; return(false); } var user = query.First(); attemptsLeft = user.AttemptsLeft; if (attemptsLeft == 0) { return(false); } if (user.Online) { attemptsLeft = 255; return(false); } _authenticated = AuthChecker.CheckToken(token, _salt, user.Password); if (!_authenticated) { attemptsLeft--; user.AttemptsLeft--; } else { user.AttemptsLeft = Config.MaxAuthAttempts; user.Online = true; _email = user.Email; _id = user.Id; } var entry = db.Entry(user); entry.Property(e => e.AttemptsLeft).IsModified = true; entry.Property(e => e.Online).IsModified = true; db.SaveChanges(); _salt = null; return(_authenticated); } }
public ActionResult Edit(Ad ad) { if (ModelState.IsValid) { db.Entry(ad).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(ad)); }
public ActionResult Edit(SubCategory subcategory) { if (ModelState.IsValid) { db.Entry(subcategory).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CategoryID = new SelectList(db.Categories, "ID", "NameEN", subcategory.CategoryID); return(View(subcategory)); }
public ActionResult Edit(AdsResource adsresource) { if (ModelState.IsValid) { db.Entry(adsresource).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.AdID = new SelectList(db.Ads, "ID", "TitleEN", adsresource.AdID); return(View(adsresource)); }
public long AddSoftSkill(Candidate candidate, SoftSkillsEvaluation skillEvaluation, string skillName) { try { using (var db = new DatabaseContainer()) { skillEvaluation.SoftSkill = db.SoftSkills.Where(x => x.Name == skillName).First(); skillEvaluation.Mark = skillEvaluation.Mark; skillEvaluation.EvaluationId = candidate.Evaluation.Id; db.Entry(skillEvaluation).State = System.Data.Entity.EntityState.Added; db.Entry(skillEvaluation.SoftSkill).State = System.Data.Entity.EntityState.Unchanged; db.SaveChanges(); } } catch (Exception e) { } return(skillEvaluation.Id); }
public void DeleteDocumenyById(long id) { try { using (var db = new DatabaseContainer()) { db.Entry(db.Documents.Where(x => x.Id == id).First()).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); } } catch (Exception e) { } }
public void DeleteStage(Stage stage) { try { using (var db = new DatabaseContainer()) { db.Entry(db.Stage.Where(x => x.Id == stage.Id).First()).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); } } catch (Exception e) { } }
public void DeleteRecriutmentStage(RecruitmentStage rs) { try { using (var db = new DatabaseContainer()) { db.Entry(db.RecruitmentStages.Where(x => x.Id == rs.Id).First()).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); } } catch (Exception e) { throw; } }
public void Delete(long candidateId) { try { using (var db = new DatabaseContainer()) { db.Entry(db.Candidates.Where(x => x.Id == candidateId).First()).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); } } catch (Exception e) { throw; } }
public int SaveSoftSkill(Database.SoftSkill softSkill) { try { using (var db = new DatabaseContainer()) { db.Entry(softSkill).State = softSkill.Id == 0 ? System.Data.Entity.EntityState.Added : System.Data.Entity.EntityState.Modified; db.SaveChanges(); } } catch (Exception e) { } return(softSkill.Id); }
public long SaveRecriutmentStage(RecruitmentStage rs) { try { using (var db = new DatabaseContainer()) { rs.Stage = db.Stage.Where(x => x.Name == rs.Stage.Name).First(); db.Entry(rs).State = rs.Id == 0 ? System.Data.Entity.EntityState.Added : System.Data.Entity.EntityState.Modified; db.SaveChanges(); } } catch (Exception e) { } return(rs.Id); }
public int SaveDocument(Document document, int candidateId, byte type) { try { using (var db = new DatabaseContainer()) { document.CandidateId = candidateId; document.Type = type; db.Entry(document).State = document.Id == 0 ? System.Data.Entity.EntityState.Added : System.Data.Entity.EntityState.Modified; db.SaveChanges(); } } catch (Exception e) { } return(document.Id); }
public void DeleteSkill(Database.Skill skill) { try { using (var db = new DatabaseContainer()) { if (db.SkillsEvaluations.Where(x => x.SkillId == skill.Id).Count() == 0) { db.Entry(skill).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); } } } catch (Exception e) { } }
public int SaveStage(Stage stage) { try { using (var db = new DatabaseContainer()) { if (stage.Id == 0) { stage.Priority = db.Stage.Count() == 0 ? 1 : db.Stage.Max(x => x.Priority) + 1; } db.Entry(stage).State = stage.Id == 0 ? System.Data.Entity.EntityState.Added : System.Data.Entity.EntityState.Modified; db.SaveChanges(); } } catch (Exception e) { } return(stage.Id); }
public int Save(Candidate candidate) { try { using (var db = new DatabaseContainer()) { db.Candidates.Attach(candidate); db.Entry(candidate).State = System.Data.Entity.EntityState.Modified; db.Entry(candidate.Decision).State = System.Data.Entity.EntityState.Modified; foreach (var rs in candidate.RecruitmentStage) { db.Entry(rs).State = System.Data.Entity.EntityState.Modified; } db.Entry(candidate.Evaluation).State = System.Data.Entity.EntityState.Modified; foreach (var se in candidate.Evaluation.SkillsEvaluation) { db.Entry(se).State = System.Data.Entity.EntityState.Modified; } foreach (var sse in candidate.Evaluation.SoftSkillsEvaluation) { db.Entry(sse).State = System.Data.Entity.EntityState.Modified; } db.SaveChanges(); } } catch (Exception e) { } return(candidate.Id); }
public int SaveC(Person person) { try { person.User.Role = (byte)UserRolesEnum.Candidate; using (var db = new DatabaseContainer()) { System.Data.Entity.EntityState state = person.Id == 0 ? System.Data.Entity.EntityState.Added : System.Data.Entity.EntityState.Modified; Person p = null; if (state == System.Data.Entity.EntityState.Modified) { if (this.GetPersonById(person.Id).User.Login != person.User.Login) { if (db.Users.Where(x => x.Login == person.User.Login).Count() != 0) { throw new Exception(); } } p = db.Persons.Include("User").Where(x => x.Id == person.Id).Single(); p.Mail = person.Mail; p.Name = person.Name; p.Pesel = person.Pesel; p.Phone = person.Phone; p.SurName = person.SurName; p.User.Login = person.Pesel; } if (person.Candidate == null) { db.Entry(new Candidate() { Person = person, Evaluation = new Evaluation(), Decision = new Decision() { Type = (byte)DecisionTypesEnum.DuringEvaluation } }).State = System.Data.Entity.EntityState.Added; } if (person.User.Password == string.Empty || person.User.Password == null) { if (state == System.Data.Entity.EntityState.Modified) { p.User.Password = db.Users.Where(x => x.Id == person.User.Id).First().Password; } person.User.Password = db.Users.Where(x => x.Id == person.User.Id).First().Password; } else { if (state == System.Data.Entity.EntityState.Modified) { p.User.Password = Common.Encryption.Encrypt(person.User.Password); } person.User.Password = Common.Encryption.Encrypt(person.User.Password); } if (state == System.Data.Entity.EntityState.Added) { db.Entry(person).State = System.Data.Entity.EntityState.Added; db.Entry(person.User).State = System.Data.Entity.EntityState.Added; } else { db.Entry(p).State = System.Data.Entity.EntityState.Modified; } db.SaveChanges(); } } catch (Exception e) { return(0); } return(person.Id); }
public int Save(Person person) { try { using (var db = new DatabaseContainer()) { System.Data.Entity.EntityState state = person.Id == 0 ? System.Data.Entity.EntityState.Added : System.Data.Entity.EntityState.Modified; if (state == System.Data.Entity.EntityState.Modified) { if (this.GetPersonById(person.Id).User.Login != person.User.Login) { if (db.Users.Where(x => x.Login == person.User.Login).Count() != 0) { throw new Exception(); } } } else { if (db.Users.Where(x => x.Login == person.User.Login).Count() != 0) { throw new Exception(); } } db.Entry(person).State = state; db.Entry(person.User).State = state; if (state == System.Data.Entity.EntityState.Added) { person.User.Password = Common.Encryption.Encrypt(person.User.Password); } else { if (person.User.Password == string.Empty) { person.User.Password = db.Users.Where(x => x.Id == person.User.Id).First().Password; } else { person.User.Password = Common.Encryption.Encrypt(person.User.Password); } } if ((UserRolesEnum)person.User.Role == UserRolesEnum.Candidate) { if (person.Candidate == null) { db.Entry(new Candidate() { Person = person, Evaluation = new Evaluation(), Decision = new Decision() { Type = (byte)DecisionTypesEnum.DuringEvaluation } }).State = System.Data.Entity.EntityState.Added; } else { db.Entry(person.Candidate).State = state; } } else { if (person.Candidate != null) { Candidate c = db.Candidates .Include("Evaluation") .Include("Decision").Where(x => x.Id == person.Candidate.Id).First(); db.Entry(c.Evaluation).State = System.Data.Entity.EntityState.Deleted; db.Entry(c.Decision).State = System.Data.Entity.EntityState.Deleted; db.Entry(c).State = System.Data.Entity.EntityState.Deleted; } } db.SaveChanges(); } } catch (Exception e) { } return(person.Id); }