// Update Personal Details
public static async Task <bool> UpdatePersonalDetails(PersonalDetailViewModel model)
{
try
{
Errors.Clear();
using (var db = new WebApiProjectDbContext())
using (var repo = new EntityFrameworkRepository <WebApiProjectDbContext>(db))
{
var entity = await db.PersonalDetails.FindAsync(model.Id);
entity.FirstName = model.FirstName;
entity.LastName = model.LastName;
entity.Age = model.Age;
entity.BirthDate = model.BirthDate;
entity.Email = model.Email;
entity.PhoneNumber = model.PhoneNumber;
repo.Update <PersonalDetail>(entity);
return(await db.SaveChangesAsync() == 0 ? false : true);
}
}
catch (Exception e)
{
Trace.WriteLine(e);
//Add Error message
Errors.Add("There was an error trying to send the information to the database");
return(false);
}
}
public async Task <T> FindById(string id)
{
try
{
_errors.Clear();
_errorDetail.Clear();
using (var db = new WebApiProjectDbContext())
using (var repo = new EntityFrameworkRepository <WebApiProjectDbContext>(db))
{
var temp = await repo.GetByIdAsync <T>(id);
if (temp.IsDeleted == true)
{
return(null);
}
return(temp);
}
}
catch (Exception e)
{
Trace.WriteLine(e);
//Add Error message
_errors.Add("There was an error trying to reading data from database");
_errorDetail.Add(e.Message);
_errorDetail.Add(e.InnerException.Message);
return(null);
}
}
// Create Personal Details
public static async Task <PersonalDetail> CreatePersonalDetails(PersonalDetailViewModel model)
{
try
{
using (var db = new WebApiProjectDbContext())
using (var repo = new EntityFrameworkRepository <WebApiProjectDbContext>(db))
{
var entity = new PersonalDetail()
{
Email = model.Email,
FirstName = model.FirstName,
LastName = model.LastName,
BirthDate = model.BirthDate,
PhoneNumber = model.PhoneNumber,
Age = model.Age,
};
repo.Create <PersonalDetail>(entity);
var result = await db.SaveChangesAsync() == 0 ? null : entity;
return(result);
}
}
catch (Exception e)
{
Trace.WriteLine(e);
return(null);
}
}
// List all Personal Details
public static async Task <List <PersonalDetail> > ListAllPersonalDetails()
{
try
{
using (var db = new WebApiProjectDbContext())
using (var repo = new EntityFrameworkRepository <WebApiProjectDbContext>(db))
{
var personalDetails = await db.PersonalDetails.ToListAsync();
personalDetails = personalDetails.Where(_ => _.IsDeleted == false).ToList();
return(personalDetails);
}
}
catch (Exception e)
{
Trace.WriteLine(e);
return(null);
}
}
// Delete Personal Details
public static async Task <bool> DeletePersonalDetails(Guid Id)
{
try
{
Errors.Clear();
using (var db = new WebApiProjectDbContext())
using (var repo = new EntityFrameworkRepository <WebApiProjectDbContext>(db))
{
var entity = await db.PersonalDetails.FindAsync(Id);
repo.Delete <PersonalDetail>(entity);
return(await db.SaveChangesAsync() == 0 ? false : true);
}
}
catch (Exception e)
{
Trace.WriteLine(e);
return(false);
}
}
public async Task <bool> Add(T entity)
{
try
{
_errors.Clear();
_errorDetail.Clear();
using (var db = new WebApiProjectDbContext())
using (var repo = new EntityFrameworkRepository <WebApiProjectDbContext>(db))
{
repo.Create <T>(entity);
return(await db.SaveChangesAsync() == 0 ? false : true);
}
}
catch (Exception e)
{
Trace.WriteLine(e);
//Add Error message
_errors.Add("There was an error trying to send the information to the database ");
return(false);
}
}
public async Task <IEnumerable <T> > List()
{
try
{
Errors.Clear();
using (var db = new WebApiProjectDbContext())
using (var repo = new EntityFrameworkRepository <WebApiProjectDbContext>(db))
{
return(await repo.GetAllAsync <T>());
}
}
catch (Exception e)
{
Trace.WriteLine(e);
//Add Error message
//Errors.Add("There was an error trying to reading data from database ");
_errors.Add("There was an error trying to reading data from database ");
return(null);
}
}
// Find Personal Details
public static async Task <PersonalDetail> FindPersonalDetailsById(Guid id)
{
try
{
Errors.Clear();
using (var db = new WebApiProjectDbContext())
using (var repo = new EntityFrameworkRepository <WebApiProjectDbContext>(db))
{
var profiles = await db.PersonalDetails.ToListAsync();
var profile = profiles.Where(_ => _.Id == id).FirstOrDefault();
return(profile);
}
}
catch (Exception e)
{
Trace.WriteLine(e);
//Add Error message
Errors.Add("There was an error trying to reading data from database");
return(null);
}
}
public async Task Delete(T entity)
{
try
{
_errors.Clear();
_errorDetail.Clear();
using (var db = new WebApiProjectDbContext())
using (var repo = new EntityFrameworkRepository <WebApiProjectDbContext>(db))
{
repo.Delete <T>(entity);
await db.SaveChangesAsync();
}
}
catch (Exception e)
{
Trace.WriteLine(e);
//Add Error message
_errors.Add("There was an error trying to send the information to the database ");
_errorDetail.Add(e.Message);
_errorDetail.Add(e.InnerException.Message);
}
}
