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