/// Remove
public DataResponseHandler <string> Remove(params object[] pks)
{
try {
if (pks == null)
{
throw new ArgumentNullException(nameof(pks), "The parameter removeEntity can not be null");
}
var result = 0;
using (var context = _dbContextCreator())
{
var role = new DataResponseHandler <string> {
Succes = true
};
var dbSet = context.Set <TEntity>();
var entity = GetById(pks);
dbSet.Attach(entity.Container);
context.Entry(entity).State = EntityState.Deleted;
result = context.SaveChanges();
if (result == 0)
{
return(new DataResponseHandler <string> {
Succes = false
});
}
return(role);
}
}
catch (Exception ex)
{
return(new DataResponseHandler <string> {
Succes = false, Container = ex.Message
});
}
}
//Adds a new entity
public DataResponseHandler <string> AddEntity(TEntity newEntity)
{
using (var context = _dbContextCreator())
{
try
{
var result = 0;
var role = new DataResponseHandler <string> {
Succes = true
};
var dbSet = context.Set <TEntity>();
dbSet.Add(newEntity);
result = context.SaveChanges();
if (result == 0)
{
role = new DataResponseHandler <string> {
Succes = false
};
}
return(role);
}
catch (Exception ex)
{
return(new DataResponseHandler <string> {
Succes = false, Container = ex.Message
});
}
}
}
public DataResponseHandler <string> UpdateEntity(Internship newItem, string guid)
{
using (var context = new Entities())
{
try
{
var role = new DataResponseHandler <string> {
Succes = true
};
var oldItem = context.Internships.Find(guid);
oldItem.Hidden = newItem.Hidden;
oldItem.Image = newItem.Image;
oldItem.InternshipId = newItem.InternshipId;
oldItem.InternshipPostPhoto = newItem.InternshipPostPhoto;
oldItem.Keywords = newItem.Keywords;
oldItem.LastUpdated = newItem.LastUpdated;
oldItem.PositionsAvailable = newItem.PositionsAvailable;
oldItem.Recruiter = newItem.Recruiter;
oldItem.RecruiterResponsibleId = newItem.RecruiterResponsibleId;
oldItem.StartDate = newItem.StartDate;
oldItem.StudentInternships = newItem.StudentInternships;
oldItem.Title = newItem.Title;
oldItem.TypeJob = newItem.TypeJob;
role.Container = oldItem.InternshipId;
return(role);
}
catch (Exception ex)
{
return(new DataResponseHandler <string> {
Succes = false, Container = ex.Message
});
}
}
}
//adds multiple entities
public DataResponseHandler <string> AddEntity(IEnumerable <TEntity> newEntities)
{
try
{
if (newEntities == null)
{
throw new ArgumentNullException(nameof(newEntities), "The parameter newEntities can not be null");
}
var result = 0;
using (var context = _dbContextCreator())
{
var dbSet = context.Set <TEntity>();
var role = new DataResponseHandler <string> {
Succes = true
};
dbSet.AddRange(newEntities);
result = context.SaveChanges();
if (result == 0)
{
return(new DataResponseHandler <string> {
Succes = false
});
}
return(role);
}
}
catch (Exception ex)
{
return(new DataResponseHandler <string> {
Succes = false, Container = ex.Message
});
}
}
//Update an entity
public DataResponseHandler <string> UpdateEntity(TEntity updateEntity)
{
try
{
var role = new DataResponseHandler <string> {
Succes = true
};
if (updateEntity == null)
{
throw new ArgumentNullException(nameof(updateEntity), "The parameter updateEntity can not be null");
}
var result = 0;
using (var context = _dbContextCreator())
{
var dbSet = context.Set <TEntity>();
dbSet.Attach(updateEntity);
context.Entry(updateEntity).State = EntityState.Modified;
result = context.SaveChanges();
if (result == 0)
{
return(new DataResponseHandler <string> {
Succes = false
});
}
return(role);
}
}
catch (Exception ex)
{
return(new DataResponseHandler <string> {
Succes = false, Container = ex.Message
});
}
}
//returns data filtered with the given expression
public DataResponseHandler <IEnumerable <TEntity> > GetData(Expression <Func <TEntity, bool> > filter)
{
try
{
if (filter == null)
{
throw new ArgumentNullException(nameof(filter), "The parameter filter can not be null");
}
var result = Enumerable.Empty <TEntity>();
using (var context = _dbContextCreator())
{
var role = new DataResponseHandler <IEnumerable <TEntity> > {
Succes = true
};
var dbSet = context.Set <TEntity>();
result = dbSet.Where(filter).ToList();
role.Container = result;
return(role);
}
}
catch (Exception ex)
{
return(new DataResponseHandler <IEnumerable <TEntity> > {
Succes = false
});
}
}
public void All_OK()
{
Func <Entities> contextCreator = () => new Entities();
DataResponseHandler <IEnumerable <Firm> > result = instance.GetAll();
Assert.IsNotNull(result);
Assert.IsTrue(result.Container.Count() > 0);
}
protected T UnwrapResponse <T>(IRestResponse <T> result, DataResponseHandler <T> handler)
{
errorHandler?.ValidateResponse(result);
handler.ValidateResponse(result);
return(handler.UnwrapResponse(result));
}
public void GetData_OK()
{
Func <Entities> contextCreator = () => new Entities();
Expression <Func <Firm, bool> > filter = a => a.FirmId == "00000000-0000-0000-0000-000000000000";
DataResponseHandler <IEnumerable <Firm> > result = instance.GetData(filter);
Assert.IsNotNull(result);
Assert.IsTrue(result.Container.Count() == 0);
}
public void Find_OK2()
{
Func <Entities> contextCreator = () => new Entities();
DataResponseHandler <Firm> result = instance.GetById(pks: "5798-403c-a941-dcfaa6bacd2c");
if (result.Succes == false)
{
Assert.AreEqual(result.Succes, false);
return;
}
else
{
Assert.AreEqual(result.Container.FirmId, "05d68886-5798-403c-a941-dcfaa6bacd2c");
}
}
//returns all the elements of the table
public DataResponseHandler <IEnumerable <TEntity> > GetAll()
{
var result = Enumerable.Empty <TEntity>();
using (var context = _dbContextCreator())
{
var dbSet = context.Set <TEntity>();
var role = new DataResponseHandler <IEnumerable <TEntity> > {
Succes = true
};
result = dbSet.ToList();
role.Container = result;
return(role);
}
}
public void Remove_SimpleItem_forEntity_OK()
{
/// changed pk for tests
Func <Entities> contextCreator = () => new Entities();
DataResponseHandler <Firm> removeEntity = instance.GetById("e081e4ef-377c-4ddd-977b-9e31ddf9f345");
if (removeEntity.Succes == true)
{
var result = instance.Remove(removeEntity.Container);
var expected = true;
Assert.AreEqual(expected, result.Succes);
}
else
{
Assert.AreEqual(removeEntity.Succes, false);
}
}
public void Add_SimpleItem_OK()
{
string guid = Guid.NewGuid().ToString();
Firm newEntity = new Firm
{
FirmId = guid,
Description = "AN ADD",
Name = "New FIRM",
NumberOfEmployees = 10,
Deleted = false,
};
DataResponseHandler <string> result = instance.AddEntity(newEntity);
bool expected = true;
Assert.AreEqual(expected, result.Succes);
}
public DataResponseHandler <IEnumerable <Internship> > GetAll()
{
using (var context = new Entities())
{
try
{
var role = new DataResponseHandler <IEnumerable <Internship> > {
Succes = true
};
role.Container = context.Internships.ToList();
return(role);
}
catch (Exception ex)
{
return(new DataResponseHandler <IEnumerable <Internship> > {
Succes = false
});
}
}
}
public DataResponseHandler <Internship> GetById(string guid)
{
using (var context = new Entities())
{
try
{
var role = new DataResponseHandler <Internship> {
Succes = true
};
role.Container = context.Internships.Find(guid);
return(role);
}
catch (Exception ex)
{
return(new DataResponseHandler <Internship> {
Succes = false
});
}
}
}
//removes a list of entries
public DataResponseHandler <string> Remove(IEnumerable <TEntity> removeEntities)
{
try
{
if (removeEntities == null)
{
throw new ArgumentNullException(nameof(removeEntities), "The parameter removeEntities can not be null");
}
var result = 0;
using (var context = _dbContextCreator())
{
var role = new DataResponseHandler <string> {
Succes = true
};
var dbSet = context.Set <TEntity>();
foreach (var removeEntity in removeEntities)
{
dbSet.Attach(removeEntity);
context.Entry(removeEntity).State = EntityState.Deleted;
}
dbSet.RemoveRange(removeEntities);
result = context.SaveChanges();
if (result == 0)
{
return(new DataResponseHandler <string> {
Succes = false
});
}
return(role);
}
}
catch (Exception ex)
{
return(new DataResponseHandler <string> {
Succes = false, Container = ex.Message
});
}
}
public DataResponseHandler <string> AddEntity(Internship newItem)
{
using (var context = new Entities())
{
try
{
var role = new DataResponseHandler <string> {
Succes = true
};
context.Internships.Add(newItem);
role.Container = newItem.InternshipId;
return(role);
}
catch (Exception ex)
{
return(new DataResponseHandler <string> {
Succes = false, Container = ex.Message
});
}
}
}
//FINDS BY PRIMARY KEY
public DataResponseHandler <TEntity> GetById(params object[] pks)
{
try
{
if (pks == null)
{
throw new ArgumentNullException(nameof(pks), "The parameter pks can not be null");
}
TEntity result = null;
using (var context = _dbContextCreator())
{
var dbSet = context.Set <TEntity>();
var role = new DataResponseHandler <TEntity> {
Succes = true
};
result = dbSet.Find(pks);
if (result != null)
{
role.Container = result;
}
else if (result == null)
{
return(new DataResponseHandler <TEntity> {
Succes = false
});
}
return(role);
}
}
catch (Exception ex)
{
return(new DataResponseHandler <TEntity> {
Succes = false
});
}
}
