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);
}
}
public List <ContactEntity> GetAllContact()
{
List <ContactEntity> lstContactEntity = null;
ContactEntityBuilder contactBuilder = new ContactEntityBuilder();
try
{
CommandTxt = SP_Contacts_G_ALL_contact;
OpenConnection();
SqlCommand dbCommand = new SqlCommand(CommandTxt, Connection);
dbCommand.CommandType = CommandType.StoredProcedure;
using (SqlDataReader dataReader = dbCommand.ExecuteReader())
{
lstContactEntity = contactBuilder.BuildEntities(dataReader);
}
Connection.Close();
return(lstContactEntity);
}
catch (Exception ex)
{
return(lstContactEntity);
}
}