public T Get(int id) { using (GovernmentDbContext entityContext = new GovernmentDbContext()) { return(GetEntity(entityContext, id)); } }
public PersonalController() { dbContext = new GovernmentDbContext(); personalRepo = new PersonalRepository(dbContext); divisionRepo = new DivisionRepository(dbContext); sectionRepo = new SectionRepository(dbContext); }
public int Remove(T entity) { using (GovernmentDbContext entityContext = new GovernmentDbContext()) { entityContext.Entry <T>(entity).State = EntityState.Deleted; return(entityContext.SaveChanges()); } }
public int Update(T entity) { using (GovernmentDbContext entityContext = new GovernmentDbContext()) { entityContext.Entry <T>(entity).State = EntityState.Modified; return(entityContext.SaveChanges()); } }
public string getAccountRole(string username = null) { Account supobj = null; using (var db = new GovernmentDbContext()) { supobj = db.Accounts.Where(m => m.Username == username).FirstOrDefault(); } return(supobj.Role); }
public int Add(T entity) { int result = 0; using (GovernmentDbContext entityContext = new GovernmentDbContext()) { var obj = AddEntity(entityContext, entity); result = entityContext.SaveChanges(); } return(result); }
protected override JobHistory AddOrUpdateEntity(GovernmentDbContext entityContext, JobHistory entity) { if (entity.PersonalID == default(int)) { return(entityContext.JobHistories.Add(entity)); } else { return(entityContext.JobHistories.FirstOrDefault(e => e.PersonalID == entity.PersonalID)); } }
protected override Personal AddOrUpdateEntity(GovernmentDbContext entityContext, Personal entity) { if (entity.PersonalID == default(int)) { return(entityContext.Personals.Add(entity)); } else { return(entityContext.Personals.FirstOrDefault(e => e.PersonalID == entity.PersonalID)); } }
protected override Section AddOrUpdateEntity(GovernmentDbContext entityContext, Section entity) { if (entity.SectionID == default(int)) { return(entityContext.Sections.Add(entity)); } else { return(entityContext.Sections.FirstOrDefault(e => e.SectionID == entity.SectionID)); } }
public T UpdatewithObj(T entity) { using (GovernmentDbContext entityContext = new GovernmentDbContext()) { entityContext.Entry <T>(entity).State = EntityState.Modified; if (entityContext.SaveChanges() > 0) { return(entity); } return(null); } }
public T AddWithGetObj(T entity) { using (GovernmentDbContext entityContext = new GovernmentDbContext()) { var obj = AddEntity(entityContext, entity); if (entityContext.SaveChanges() > 0) { return(obj); } } return(null); }
protected override Section GetEntity(GovernmentDbContext entityContext, int id) { return(entityContext.Sections.FirstOrDefault(e => e.SectionID == id)); }
protected override Section UpdateEntity(GovernmentDbContext entityContext, Section entity) { return(entityContext.Sections.FirstOrDefault(e => e.SectionID == entity.SectionID)); }
protected override Section AddEntity(GovernmentDbContext entityContext, Section entity) { return(entityContext.Sections.Add(entity)); }
public SectionRepository(GovernmentDbContext context) { this.entityContext = context; }
protected override JobHistory GetEntity(GovernmentDbContext entityContext, int id) { return(entityContext.JobHistories.FirstOrDefault(e => e.PersonalID == id)); }
protected abstract T UpdateEntity(GovernmentDbContext entityContext, T entity);
protected override Personal GetEntity(GovernmentDbContext entityContext, int id) { return(entityContext.Personals.FirstOrDefault(e => e.PersonalID == id)); }
public PersonalDetailRepository(GovernmentDbContext context) { this.entityContext = context; }
protected abstract T AddEntity(GovernmentDbContext entityContext, T entity);
protected abstract T GetEntity(GovernmentDbContext entityContext, int id);
public HomeController() { _dbContext = new GovernmentDbContext(); // _location = new Repository<tbLocation>(_dbContext); }
public JobHistoryRepository(GovernmentDbContext context) { this.entityContext = context; }
public PhotoUploadController() { _dbContext = new GovernmentDbContext(); //_article = new Repository<tbArticle>(_dbContext); //_photo = new Repository<tbPhoto>(_dbContext); }
protected override Personal AddEntity(GovernmentDbContext entityContext, Personal entity) { return(entityContext.Personals.Add(entity)); }
protected override JobHistory AddEntity(GovernmentDbContext entityContext, JobHistory entity) { return(entityContext.JobHistories.Add(entity)); }
protected override Personal UpdateEntity(GovernmentDbContext entityContext, Personal entity) { return(entityContext.Personals.FirstOrDefault(e => e.PersonalID == entity.PersonalID)); }
protected override JobHistory UpdateEntity(GovernmentDbContext entityContext, JobHistory entity) { return(entityContext.JobHistories.FirstOrDefault(e => e.PersonalID == entity.PersonalID)); }
public AccountController() { _dbContext = new GovernmentDbContext(); _account = new Repository <Account>(_dbContext); }
public RenewalApplicationController() { _userMailer = new UserMailer(); _dbContext = new GovernmentDbContext(); // _renewalRepo = new Repository<tbRenewalPractitionerApplication>(_dbContext); }