public int UpdateContact(ContactEntity contact) { int result = 0; try { CommandTxt = SP_Contacts_U_contact; OpenConnection(); SqlCommand dbCommand = new SqlCommand(CommandTxt, Connection); dbCommand.CommandType = CommandType.StoredProcedure; dbCommand.Parameters.AddWithValue("@iId", contact.Id); dbCommand.Parameters.AddWithValue("@iEmail", contact.Email); dbCommand.Parameters.AddWithValue("@iFirstName", contact.FirstName); dbCommand.Parameters.AddWithValue("@iLastName", contact.LastName); dbCommand.Parameters.AddWithValue("@iPhoneNumber", contact.PhoneNumber); dbCommand.Parameters.AddWithValue("@iStatus", contact.Status); result = dbCommand.ExecuteNonQuery(); Connection.Close(); return(result); } catch (Exception ex) { Connection.Close(); return(result); } }
public ContactEntity GetContactById(int Id) { ContactEntity contactEntity = new ContactEntity(); ContactEntityBuilder contactBuilder = new ContactEntityBuilder(); try { CommandTxt = SP_Contacts_G_ById_contact; OpenConnection(); SqlCommand dbCommand = new SqlCommand(CommandTxt, Connection); dbCommand.CommandType = CommandType.StoredProcedure; dbCommand.Parameters.AddWithValue("@iId", Id); using (SqlDataReader reader = dbCommand.ExecuteReader()) { if (reader.HasRows) { if (reader.Read()) { contactEntity = contactBuilder.BuildEntity(reader); } } } Connection.Close(); return(contactEntity); } catch (Exception ex) { return(contactEntity); } }