public void UpdateContact(ContactModel contact) { using (ContactDBEntities db = new ContactDBEntities()) { using (var dbContextTransaction = db.Database.BeginTransaction()) { try { ContactView CT = db.ContactViews.Find(contact.ContactID); CT.FirstName = contact.FirstName; CT.LastName = contact.LastName; CT.Phone = contact.Phone; CT.Email = contact.Email; CT.Street = contact.Street; CT.City = contact.City; CT.State = contact.State; CT.PostalCode = contact.PostalCode; CT.DisplayName = contact.DisplayName; db.SaveChanges(); dbContextTransaction.Commit(); } catch { dbContextTransaction.Rollback(); } } } }
// POST api/Contacts public HttpResponseMessage PostContact([FromBody] Contact contact) { if (ModelState.IsValid) { try { using (ContactDBEntities entities = new ContactDBEntities()) { entities.Contacts.Add(contact); entities.SaveChanges(); } HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, contact); response.Headers.Location = new Uri(Url.Link("DefaultApi", new { id = contact.Id })); return(response); } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } }
public override string[] GetRolesForUser(string username) { ContactDBEntities db = new ContactDBEntities(); string data = db.tblLogins.Where(x => x.Username == username).FirstOrDefault().Role; string[] result = { data }; return(result); }
public ActionResult Index() { ContactDBEntities db = new ContactDBEntities(); var personList = (from p in db.People join c in db.Contacts on p.PersonID equals c.PersonID select new PersonContactViewModel { Person = p, Contact = c }).ToList(); return(View(personList)); }
public HttpResponseMessage Contact(int id) { Contact contact = new Contact(); using (ContactDBEntities entities = new ContactDBEntities()) { contact = entities.Contacts.FirstOrDefault(e => e.Id == id); } if (contact != null) { return(Request.CreateResponse(HttpStatusCode.OK, contact)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Contact with id= " + id.ToString() + " not found")); } }
public void AddContact(ContactModel contact) { using (ContactDBEntities db = new ContactDBEntities()) { ContactView CT = new ContactView(); CT.FirstName = contact.FirstName; CT.LastName = contact.LastName; CT.Phone = contact.Phone; CT.Email = contact.Email; CT.Street = contact.Street; CT.City = contact.City; CT.State = contact.State; CT.PostalCode = contact.PostalCode; db.ContactViews.Add(CT); db.SaveChanges(); } }
// GET: ContactModels/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ContactModel contactModel = db.Contact.Find(id); ContactDBEntities contactDBEntities = new ContactDBEntities(); TempData["numberOfChanges"] = contactDBEntities.Audit_Retrieve(id).Select(s => s.numberOfChanges).ToList().FirstOrDefault(); TempData["LastUpdateDateTime"] = contactDBEntities.Audit_Retrieve(id).Select(s => s.LastUpdateDateTime).ToList().FirstOrDefault(); if (contactModel == null) { return(HttpNotFound()); } return(View(contactModel)); }
// PUT api/Contacts/5 public HttpResponseMessage PutContact(int id, Contact contact) { if (ModelState.IsValid && id == contact.Id) { try { using (ContactDBEntities entities = new ContactDBEntities()) { var contactEntity = entities.Contacts.FirstOrDefault(e => e.Id == id); if (contactEntity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Contact with id= " + id.ToString() + " not found")); } else { contactEntity.FirstName = contact.FirstName; contactEntity.LastName = contact.LastName; contactEntity.Email = contact.Email; contactEntity.PhoneNumber = contact.PhoneNumber; contactEntity.Status = contact.Status; entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, contactEntity)); } } } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.BadRequest, ex)); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } }
public ActionResult Login(tblLogin model, string returnUrl) { ContactDBEntities db = new ContactDBEntities(); var dataItem = db.tblLogins.Where(x => x.Username == model.Username && x.Password == model.Password).First(); if (dataItem != null) { FormsAuthentication.SetAuthCookie(dataItem.Username, false); if (Url.IsLocalUrl(returnUrl) && returnUrl.Length > 1 && returnUrl.StartsWith("/") && !returnUrl.StartsWith("//") && !returnUrl.StartsWith("/\\")) { return(Redirect(returnUrl)); } else { return(RedirectToAction("Index")); } } else { ModelState.AddModelError("", "Invalid user/pass"); return(View()); } }
public void DeleteUser(int contactID) { using (ContactDBEntities db = new ContactDBEntities()) { using (var dbContextTransaction = db.Database.BeginTransaction()) { try { var CT = db.ContactViews.Where(o => o.ContactID == contactID); if (CT.Any()) { db.ContactViews.Remove(CT.FirstOrDefault()); db.SaveChanges(); } dbContextTransaction.Commit(); } catch { dbContextTransaction.Rollback(); } } } }
/// <summary> /// Initializes a new instance of the <see cref="MainWindowViewModel"/> class. /// </summary> public MainWindowViewModel() { m_DbContext = new ContactDBEntities(); }
public UnitOfWork() { _db = new ContactDBEntities(); }
public ContactRepository(ContactDBEntities context) { db = context; }
// Constructor public ContactAPIController() { // create instance of an object dbContext = new ContactDBEntities(); }
public UnitOfWork() { _context = new ContactDBEntities(); }
/// <summary> /// Public Constructor,initializes privately declared local variables. /// </summary> /// <param name="context"></param> public GenericRepository(ContactDBEntities context) { this.Context = context; this.DbSet = context.Set <TEntity>(); }