public bool UpdateContactByName(AddressBookModel addressBookModel, string firstName)
{
SqlConnection connection = new SqlConnection(connectionString);
try
{
using (connection)
{
string query = @"update AddressBookDetails set LastName=@LastName,Address=@Address,City=@City,
State=@State,Zip=@Zip,PhoneNumber=@PhoneNumber,Email=@Email,AddressBookName=@AddressBookName,
AddressBookType=@AddressBookType where FirstName=@FirstName";
SqlCommand cmd = new SqlCommand(query, connection);
cmd.Parameters.AddWithValue("@FirstName", firstName);
cmd.Parameters.AddWithValue("@LastName", addressBookModel.LastName);
cmd.Parameters.AddWithValue("@Address", addressBookModel.Address);
cmd.Parameters.AddWithValue("@City", addressBookModel.City);
cmd.Parameters.AddWithValue("@State", addressBookModel.State);
cmd.Parameters.AddWithValue("@Zip", addressBookModel.Zip);
cmd.Parameters.AddWithValue("@PhoneNumber", addressBookModel.PhoneNumber);
cmd.Parameters.AddWithValue("@Email", addressBookModel.Email);
cmd.Parameters.AddWithValue("@AddressBookName", addressBookModel.AddressBookName);
cmd.Parameters.AddWithValue("@AddressBookType", addressBookModel.AddressBookType);
connection.Open();
var result = cmd.ExecuteNonQuery();
connection.Close();
if (result != 0)
{
return(true);
}
return(false);
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
finally
{
connection.Close();
}
}
/// <summary>
/// Adding records into database.
/// </summary>
/// <param name="addressBookModel"></param>
/// <returns></returns>
public bool AddContactsInAddressBook(AddressBookModel addressBookModel)
{
SqlConnection connection = new SqlConnection(connectionString);
try
{
using (connection)
{
SqlCommand cmd = new SqlCommand("StoredProcedure_AddressBook", connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@FirstName", addressBookModel.FirstName);
cmd.Parameters.AddWithValue("@LastName", addressBookModel.LastName);
cmd.Parameters.AddWithValue("@Address", addressBookModel.Address);
cmd.Parameters.AddWithValue("@City", addressBookModel.City);
cmd.Parameters.AddWithValue("@State", addressBookModel.State);
cmd.Parameters.AddWithValue("@Zip", addressBookModel.Zip);
cmd.Parameters.AddWithValue("@PhoneNumber", addressBookModel.PhoneNumber);
cmd.Parameters.AddWithValue("@Email", addressBookModel.Email);
cmd.Parameters.AddWithValue("@AddressBookName", addressBookModel.AddressBookName);
cmd.Parameters.AddWithValue("@AddressBookType", addressBookModel.AddressBookType);
connection.Open();
var result = cmd.ExecuteNonQuery();
connection.Close();
if (result != 0)
{
return(true);
}
return(false);
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
finally
{
connection.Close();
}
}