public void Remove(int id)
{
using (var context = new DTO.EF.Test5Entities())
{
try
{
var person = (from x in context.Person5
where x.Id == id
select x).First();
context.Entry(person).State = System.Data.Entity.EntityState.Deleted;
context.SaveChanges();
}
catch (Exception ex)
{
ErrorMessage = ex.Message + "==>" + ex.TargetSite;
throw;
//ErrorMessage = ex.Message + "==>" + ex.TargetSite;
//return ErrorMessage;
}
finally
{
context.Dispose();
}
}
}
public void Insert(string fName, string lName, string telNumber, string mobileNumber, string address, string email)
{
using (var context = new DTO.EF.Test5Entities())
{
try
{
var person = new DTO.EF.Person5();
person.FName = fName;
person.LName = lName;
person.TelNumber = telNumber;
person.MobileNumber = mobileNumber;
person.Addresss = address;
person.Email = email;
context.Person5.Add(person);
context.SaveChanges();
}
catch (Exception ex)
{
ErrorMessage = ex.Message + "==>" + ex.TargetSite;
throw;
//ErrorMessage = ex.Message + "==>" + ex.TargetSite;
//return ErrorMessage;
}
finally
{
context.Dispose();
}
}
}
public void Update(Person5 person)
{
using (var context = new DTO.EF.Test5Entities())
{
try
{
context.Entry(person).State = EntityState.Modified;
context.SaveChanges();
}
catch (Exception ex)
{
throw;
}
finally
{
context.Dispose();
}
}
}
public List <DTO.EF.Person5> SelectAll()
{
using (var context = new DTO.EF.Test5Entities())
{
try
{
var q = context.Person5.ToList();
return(q);
}
catch (Exception ex)
{
ErrorMessage = ex.Message + "==>" + ex.TargetSite;
throw;
//ErrorMessage = ex.Message + "==>" + ex.TargetSite;
//return ErrorMessage;
}
finally
{
context.Dispose();
}
}
}
public void Update(int id)
{
using (var context = new DTO.EF.Test5Entities())
{
try
{
var person = (from x in context.Person5
where x.Id == id
select x).First();
context.Entry(person).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
catch (Exception ex)
{
throw;
}
finally
{
context.Dispose();
}
}
}
