public bool InsertContact(mContact pContact) { try { tbl_contact vContact = new tbl_contact(); var query = from b in Db.tbl_contact orderby b.user_id descending select b; vContact = query.FirstOrDefault(); tbl_contact n = new tbl_contact(); n.user_email = pContact.user_email; n.user_name = pContact.user_name; n.user_subject = pContact.user_subject; n.user_text = pContact.user_text; n.user_id = vContact.user_id + 1; n.user_date = DateTime.Now.Date.ToString(); n.user_file = pContact.user_file; n.contact_type = pContact.contact_type; Db.tbl_contact.Add(n); return(Convert.ToBoolean(Db.SaveChanges())); } catch (Exception) { return(false); } }
static void Main(string[] args) { var contact = new tbl_contact() { FirstName = "Joe", LastName = "Smith", Address = "123", PhoneNumber = "555", Birthday = new DateTime(1980, 1, 1) }; var op = new ContactOperations(); //op.Create(contact); //op.Update(2, contact); op.Delete(2); var list = op.Read(); foreach (var elem in list) { Console.WriteLine($"{elem.FirstName} {elem.LastName} {elem.Address} {elem.PhoneNumber} {elem.Birthday}"); } // Pause at the end Console.Read(); }
public void Test_To_Create_Post_Redirect_OnSuccess() { var controller = GetContactController(new InMemoryContactRepository()); tbl_contact contact = GetContactID(); var result = (RedirectToRouteResult)controller.Create(contact); Assert.AreEqual("Index", result.RouteValues["action"]); }
public void Test_To_Create_Post_Contact_Repository() { InMemoryContactRepository contactrepository = new InMemoryContactRepository(); ContactController contactcontroller = GetContactController(contactrepository); tbl_contact contact = GetContactID(); contactcontroller.Create(contact); IEnumerable <tbl_contact> contactList = contactrepository.GetAllContact(); //Assert.IsTrue(contactList.Contains(contact)); }
public ActionResult Edit([Bind(Include = "Id,FirstName,LastName,Email,PhoneNumber,Status")] tbl_contact tbl_contact) { if (ModelState.IsValid) { contactRepository.UpdateContact(tbl_contact); contactRepository.Save(); return(RedirectToAction("Index")); } return(View(tbl_contact)); }
/// <summary> /// Update contact information /// </summary> /// <param name="tbl_Contact"></param> public void UpdateContact(tbl_contact tbl_Contact) { foreach (tbl_contact contact in _db) { if (contact.Id == tbl_Contact.Id) { _db.Remove(contact); _db.Add(tbl_Contact); break; } } }
public void Test_To_Get_All_Contact_From_Repository() { // Arrange tbl_contact contact1 = GetContactName(1, "John", "Doe", "*****@*****.**", "987654321", true); tbl_contact contact2 = GetContactName(2, "John1", "Doe1", "*****@*****.**", "987654312", true); InMemoryContactRepository inMemoryContactRepository = new InMemoryContactRepository(); inMemoryContactRepository.InsertContact(contact1); inMemoryContactRepository.InsertContact(contact2); var controller = GetContactController(inMemoryContactRepository); var result = controller.Index(); var datamodel = (List <tbl_contact>)result.ViewData.Model; CollectionAssert.Contains(datamodel.ToArray(), contact1); CollectionAssert.Contains(datamodel.ToArray(), contact2); }
private Contact Convert(tbl_contact c) { if (object.ReferenceEquals(c, null)) { return(new Contact()); } var contact = new Contact() { ContactID = c.ContactID, FirstName = c.FirstName, LastName = c.LastName, Address = c.Address, PhoneNumber = c.PhoneNumber, Birthday = c.Birthday }; return(contact); }
/// <summary> /// Add contact information /// </summary> /// <param name="contactToCreate"></param> public void InsertContact(tbl_contact contactToCreate) { _db.Add(contactToCreate); }