/// <summary>
/// Adds the new contact in to data base.
/// </summary>
/// <param name="addressBookModel">The address book model.</param>
/// <returns></returns>
/// <exception cref="Exception"></exception>
public bool AddNewContactInToDataBase(AddressBookModel addressBookModel)
{
using (this.connection)
{
//AddressBookModel addressBookModel = new AddressBookModel();
try
{
using (this.connection)
{
SqlCommand command = new SqlCommand("spAddNewContactInToDataBase", this.connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@FullName", addressBookModel.FullName);
command.Parameters.AddWithValue("@Address", addressBookModel.Address);
command.Parameters.AddWithValue("@City", addressBookModel.City);
command.Parameters.AddWithValue("@State", addressBookModel.State);
command.Parameters.AddWithValue("@PhoneNumber", addressBookModel.Zip);
command.Parameters.AddWithValue("@Zip", addressBookModel.PhoneNumber);
command.Parameters.AddWithValue("@Email", addressBookModel.Email);
command.Parameters.AddWithValue("@AddressBookName", addressBookModel.AddressBookName);
command.Parameters.AddWithValue("@AddressBookType", addressBookModel.AddressBookType);
command.Parameters.AddWithValue("@Start_Date", DateTime.Now);
this.connection.Open();
/// It used to executing queries that does not return any data.
var result = command.ExecuteNonQuery();
this.connection.Close();
if (result != 0)
{
return(true);
}
return(false);
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
finally
{
/// Connections closes
this.connection.Close();
}
}
}