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