private Contact getContact(int id) { using (var db = new ContactsDB()) { return(db.Contacts.Find(id)); } }
/// <summary> /// The UpdateBtn_Click event handler on this Page is used to either /// create or update a contact. It uses the Rainbow.ContactsDB() /// data component to encapsulate all data functionality. /// </summary> /// <param name="e">The <see cref="T:System.EventArgs"/> instance containing the event data.</param> protected override void OnUpdate(EventArgs e) { base.OnUpdate(e); // Only Update if Entered data is Valid if (Page.IsValid == true) { // Create an instance of the ContactsDB component ContactsDB contacts = new ContactsDB(); if (ItemID == 0) { // Add the contact within the contacts table contacts.AddContact(ModuleID, ItemID, PortalSettings.CurrentUser.Identity.Email, NameField.Text, RoleField.Text, EmailField.Text, Contact1Field.Text, Contact2Field.Text, FaxField.Text, AddressField.Text); } else { // Update the contact within the contacts table contacts.UpdateContact(ModuleID, ItemID, PortalSettings.CurrentUser.Identity.Email, NameField.Text, RoleField.Text, EmailField.Text, Contact1Field.Text, Contact2Field.Text, FaxField.Text, AddressField.Text); } // Redirect back to the portal home page RedirectBackToReferringPage(); } }
public void CompareRetrievedDataFromDB() { ContactsDB expected = new ContactsDB() { first_name = "Pranav", last_name = "Jaguste", address = "Mulund", city = "Mumbai", state = "Mh", zipcode = 400081, phone_no = "1234567890", email = "*****@*****.**", Contact_Type = "Family", Book_Name = "Book1" }; var actual = AddressBookRepoDB.RetrieveData(); Assert.AreEqual(expected.first_name, actual.first_name); Assert.AreEqual(expected.last_name, actual.last_name); Assert.AreEqual(expected.city, actual.city); Assert.AreEqual(expected.phone_no, actual.phone_no); Assert.AreEqual(expected.Book_Name, actual.Book_Name); Assert.AreEqual(expected.Contact_Type, actual.Contact_Type); }
private List <Contact> getContacts() { using (var db = new ContactsDB()) { return(db.Contacts.ToList()); } }
public async Task <IActionResult> Put(int id, [FromBody] Contact contact) { using (var db = new ContactsDB()) { var c = db.Contacts.Find(contact.ContactID); if (c == null) { return(NotFound()); } db.Entry(c).CurrentValues.SetValues(contact); db.SaveChanges(); return(Ok()); //new BodyModelBinder().BindModelAsync(); if (await base.TryUpdateModelAsync(c)) { } else { return(BadRequest(ModelState)); } } }
public bool CreateContact(Contact contact) { _contact = contact; ContactsDB contactsDB = new ContactsDB(); Validate(); return(ValidationErrors.Count == 0 ? contactsDB.CreateContact(contact) : false); }
/// <summary> /// Constructor de la clase ContactsViewModel /// </summary> public ContactsViewModel() { ContactsDB.InitializeContactsDB(); ControlMessage = ""; SearchCommand = new CommandBase(param => SearchContacts()); ListCommand = new CommandBase(param => ListContacts()); }
/// <summary> /// The Page_Load event on this Page is used to obtain the ModuleID /// and ItemID of the contact to edit. /// It then uses the Rainbow.ContactsDB() data component /// to populate the page's edit controls with the contact details. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="T:System.EventArgs"/> instance containing the event data.</param> private void Page_Load(object sender, EventArgs e) { // If the page is being requested the first time, determine if an // contact itemID value is specified, and if so populate page // contents with the contact details if (Page.IsPostBack == false) { if (ItemID != 0) { // Obtain a single row of contact information ContactsDB contacts = new ContactsDB(); SqlDataReader dr = contacts.GetSingleContact(ItemID, WorkFlowVersion.Staging); try { // Read first row from database if (dr.Read()) { NameField.Text = (dr["Name"] == DBNull.Value) ? string.Empty : (string)(dr["Name"]); RoleField.Text = (dr["Role"] == DBNull.Value) ? string.Empty : (string)(dr["Role"]); EmailField.Text = (dr["Email"] == DBNull.Value) ? string.Empty : (string)(dr["Email"]); Contact1Field.Text = (dr["Contact1"] == DBNull.Value) ? string.Empty : (string)(dr["Contact1"]); Contact2Field.Text = (dr["Contact2"] == DBNull.Value) ? string.Empty : (string)(dr["Contact2"]); FaxField.Text = (dr["Fax"] == DBNull.Value) ? string.Empty : (string)(dr["Fax"]); AddressField.Text = (dr["Address"] == DBNull.Value) ? string.Empty : (string)(dr["Address"]); CreatedBy.Text = (dr["CreatedByUser"] == DBNull.Value) ? string.Empty : (string)(dr["CreatedByUser"]); CreatedDate.Text = (dr["CreatedDate"] == DBNull.Value) ? DateTime.Now.ToShortDateString() : ((DateTime)dr["CreatedDate"]).ToShortDateString(); // 15/7/2004 added localization by Mario Endara [email protected] if (CreatedBy.Text == "unknown") { CreatedBy.Text = General.GetString("UNKNOWN", "unknown"); } } } finally { // Close datareader dr.Close(); } } else { deleteButton.Visible = false; // Cannot delete an unexsistent item } } }
/// <summary> /// The Page_Load event handler on this User Control is used to /// obtain a DataReader of contact information from the Contacts /// table, and then databind the results to a DataGrid /// server control. It uses the Rainbow.ContactsDB() /// data component to encapsulate all data functionality. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="T:System.EventArgs"/> instance containing the event data.</param> private void Page_Load(object sender, EventArgs e) { //MH: Added 01/10/2003 [[email protected]] //set visibility of the columns myDataGrid.Columns[3].Visible = (Settings["SHOW_COLUMN_EMAIL"] != null) ? bool.Parse(Settings["SHOW_COLUMN_EMAIL"].ToString()) : true; myDataGrid.Columns[4].Visible = (Settings["SHOW_COLUMN_CONTACT1"] != null) ? bool.Parse(Settings["SHOW_COLUMN_CONTACT1"].ToString()) : true; myDataGrid.Columns[5].Visible = (Settings["SHOW_COLUMN_CONTACT2"] != null) ? bool.Parse(Settings["SHOW_COLUMN_CONTACT2"].ToString()) : true; myDataGrid.Columns[6].Visible = (Settings["SHOW_COLUMN_FAX"] != null) ? bool.Parse(Settings["SHOW_COLUMN_FAX"].ToString()) : true; myDataGrid.Columns[7].Visible = (Settings["SHOW_COLUMN_ADDRESS"] != null) ? bool.Parse(Settings["SHOW_COLUMN_ADDRESS"].ToString()) : true; //MH: End if (Page.IsPostBack == false) { sortField = "Name"; sortDirection = "ASC"; if (sortField == "DueDate") { sortDirection = "DESC"; } ViewState["SortField"] = sortField; ViewState["SortDirection"] = sortDirection; } else { sortField = (string)ViewState["SortField"]; sortDirection = (string)ViewState["sortDirection"]; } myDataView = new DataView(); // Obtain contact information from Contacts table // and bind to the DataGrid Control ContactsDB contacts = new ContactsDB(); DataSet contactData = contacts.GetContacts(ModuleID, Version); myDataView = contactData.Tables[0].DefaultView; if (!Page.IsPostBack) { myDataView.Sort = sortField + " " + sortDirection; } BindGrid(); }
public async Task TestContacts() { using (ContactsDB db = new ContactsDB()) { // Ensure Test Record does not exist Assert.IsTrue(PurgeTestRecord(db), "PurgeTestRecord unsuccessful"); // Query current database List <Contact> contactsList = await db.Contacts.ToListAsync(); int initialCount = contactsList.Count; // CREATE: Create new contact Assert.IsTrue(CreateTestContact(db), "CreateTestContact unsuccessful"); // READ: verify contact created contactsList = await db.Contacts.ToListAsync(); int currentCount = contactsList.Count; //Assert.Equals(currentCount, (initialCount + 1)); // FAILS Assert.IsTrue(currentCount == (initialCount + 1)); var resultSet = db.Contacts.Where(c => c.Name == TEST_NAME); currentCount = resultSet.Count(); //Assert.Equals(currentCount, 1); // FAILS Assert.IsTrue(currentCount == 1); Contact contact = resultSet.First(); Assert.AreEqual(contact.EMail, TEST_NAME + "@xyz.com"); Assert.AreEqual(contact.Phone1, "999-888-7777"); // UPDATE: verify record modification contact.Phone1 = "111-222-3333"; db.SaveChanges(); contactsList = await db.Contacts.ToListAsync(); resultSet = db.Contacts .Where(c => c.Name == TEST_NAME); contact = resultSet.First(); currentCount = resultSet.Count(); Assert.IsTrue(currentCount == 1); Assert.AreEqual(contact.Phone1, "111-222-3333"); // DELETE: verify record delection db.Contacts.Remove(contact); db.SaveChanges(); contactsList = await db.Contacts.ToListAsync(); currentCount = contactsList.Count; Assert.IsTrue(currentCount == initialCount); } }
public async Task TestInitializerSeed() { using (ContactsDB db = new ContactsDB()) { List <Contact> contactsList = await db.Contacts.ToListAsync(); Assert.IsTrue(contactsList.Count > 0, "there will be one record in newly initialized database"); Contact contact = contactsList[0]; Assert.IsTrue(contact.Name == "abc", "initial contact Name \"abc\""); Assert.IsTrue(contact.EMail == "*****@*****.**", "initial contact EMail \"[email protected]\""); } }
public async Task <IActionResult> Post([FromBody] Contact contact) { using (var db = new ContactsDB()) { if (contact == null || TryValidateModel(contact)) { return(BadRequest(ModelState)); } db.Contacts.Add(contact); db.SaveChanges(); return(Created("", contact.ContactID)); } }
public void AddContact() { bool expected = true; ContactsDB contactDetails = new ContactsDB(); contactDetails.first_name = "Rakesh"; contactDetails.last_name = "Sharma"; contactDetails.Book_Name = "Book4"; contactDetails.Contact_Type = "Family"; contactDetails.B_ID = "BK4"; AddressBookRepoDB addressBookRepoDB = new AddressBookRepoDB(); bool actual = addressBookRepoDB.AddContactDetailsInDB(contactDetails); Assert.AreEqual(expected, actual); }
/// <summary> /// The DeleteBtn_Click event handler on this Page is used to delete an /// a contact. It uses the Rainbow.ContactsDB() /// data component to encapsulate all data functionality. /// </summary> /// <param name="e">The <see cref="T:System.EventArgs"/> instance containing the event data.</param> protected override void OnDelete(EventArgs e) { base.OnDelete(e); // Only attempt to delete the item if it is an existing item // (new items will have "ItemID" of 0) if (ItemID != 0) { ContactsDB contacts = new ContactsDB(); contacts.DeleteContact(ItemID); } // Redirect back to the portal home page RedirectBackToReferringPage(); }
private bool CreateTestContact(ContactsDB db) { bool result = false; try { Contact contact = new Contact(); contact.Name = TEST_NAME; contact.EMail = TEST_NAME + "@xyz.com"; contact.Phone1 = "999-888-7777"; db.Contacts.Add(contact); db.SaveChanges(); result = true; } catch (Exception ex) { Console.WriteLine(ex.Message); } return(result); }
public void CompareRetrievedDataFromDB() { ContactsDB expected = new ContactsDB() { first_name = "Akash", last_name = "Mane", city = "Mulund", phone = "1234567890", B_Name = "Book1", B_Type = "Family" }; var actual = AddressRepoDB.RetrieveData(); Assert.AreEqual(expected.first_name, actual.first_name); Assert.AreEqual(expected.last_name, actual.last_name); Assert.AreEqual(expected.city, actual.city); Assert.AreEqual(expected.phone, actual.phone); Assert.AreEqual(expected.B_Name, actual.B_Name); Assert.AreEqual(expected.B_Type, actual.B_Type); }
//[TestInitialize] //public void SetupTest() //{ // Database.SetInitializer(new ContactsApp.Models.ContactsDBInitializer()); //} private bool PurgeTestRecord(ContactsDB db) { bool result = false; try { var resultSet = db.Contacts .Where(c => c.Name == TEST_NAME); int i = resultSet.Count(); if (resultSet.Count() > 0) { db.Contacts.RemoveRange(resultSet); db.SaveChanges(); } result = true; } catch (Exception ex) { Console.WriteLine(ex.Message); } return(result); }
public void AddContact() { bool expected = true; ContactsDB contactDetails = new ContactsDB(); contactDetails.first_name = "Rakesh"; contactDetails.last_name = "Sharma"; //contactDetails.address = "Khar"; //contactDetails.city = "Mumbai"; //contactDetails.state = "Maharashtra"; //contactDetails.zip = 400058; //contactDetails.phone = "989879876"; //contactDetails.email = "*****@*****.**"; //contactDetails.Date = DateTime.Parse("2019-06-10"); contactDetails.B_Name = "Book4"; contactDetails.B_Type = "Family"; contactDetails.B_ID = "BK4"; AddressBookRepoDB addressBookRepoDB = new AddressBookRepoDB(); bool actual = addressBookRepoDB.AddContactDetailsInDB(contactDetails); Assert.AreEqual(expected, actual); }
public void TestNotes() { using (ContactsDB db = new ContactsDB()) { // Ensure Test Record does not exist Assert.IsTrue(PurgeTestRecord(db), "PurgeTestRecord unsuccessful"); // Create test record Assert.IsTrue(CreateTestContact(db), "CreateTestContact unsuccessful"); List <Contact> contactsList = db.Contacts.Where(c => c.Name == TEST_NAME).ToList(); Assert.IsTrue(contactsList.Count == 1); // Verify there aren't any notes Contact contact = contactsList[0]; Assert.IsNull(contact.Notes); // CREATE: Create new note // UPDATE: Modify note // DELETE: Delete note } }
public void AddMultipleContactUsingThred() { ContactsDB contactDetails = new ContactsDB(); contactDetails.first_name = "Rakesh"; contactDetails.last_name = "Sharma"; contactDetails.Book_Name = "Book4"; contactDetails.Contact_Type = "Family"; contactDetails.B_ID = "BK4"; ContactsDB contactsDB = new ContactsDB(); contactsDB.first_name = "Rahul"; contactsDB.last_name = "Singh"; contactsDB.Book_Name = "Book5"; contactsDB.Contact_Type = "Friends"; contactsDB.B_ID = "BK5"; List <ContactsDB> contactList = new List <ContactsDB>(); contactList.Add(contactDetails); contactList.Add(contactsDB); AddressBookRepoDB addressBookRepoDB = new AddressBookRepoDB(); addressBookRepoDB.AddContactDetailsInDBusingThread(contactList); }
public List <Contact> GetListOfContacts() { ContactsDB contactsDB = new ContactsDB(); return(contactsDB.GetContacts()); }
public bool DeleteContact(int id) { ContactsDB contactsDB = new ContactsDB(); return(contactsDB.DeleteContact(id)); }
public Contact GetContact(int id) { ContactsDB contactsDB = new ContactsDB(); return(contactsDB.GetContact(id)); }