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