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