/// <summary>
/// Get All the active contacts
/// </summary>
/// <returns></returns>
public List <Contact> GetContactList()
{
try
{
List <Contact> contactDetails = new List <Contact>();
DataSet dsContactDetails = new DataSet();
dsContactDetails = SqlFunctions.ExecuteDataSet("GetContactDetails", null);
if (dsContactDetails != null && dsContactDetails.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in dsContactDetails.Tables[0].Rows)
{
Contact contactInformation = new Contact();
contactInformation.FirstName = Convert.ToString(row["FirstName"]);
contactInformation.LastName = Convert.ToString(row["LastName"]);
contactInformation.Phone = Convert.ToString(row["PhoneNumber"]);
contactInformation.Email = Convert.ToString(row["Email"]);
contactInformation.Status = Convert.ToBoolean(row["Status"]);
contactInformation.Id = Convert.ToString(row["Id"]);
contactDetails.Add(contactInformation);
}
}
return(contactDetails);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// Geta particular contact
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Contact GetContactInformation(int id)
{
try
{
Contact contactInformation = new Contact();
DataSet dsContactDetails = new DataSet();
List <SqlParameter> sqlParamters = new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@Id", SqlDbType = SqlDbType.NVarChar, Value = id
},
};
dsContactDetails = SqlFunctions.ExecuteDataSet("GetContactInformation", sqlParamters);
if (dsContactDetails != null && dsContactDetails.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in dsContactDetails.Tables[0].Rows)
{
contactInformation.FirstName = Convert.ToString(row["FirstName"]);
contactInformation.LastName = Convert.ToString(row["LastName"]);
contactInformation.Phone = Convert.ToString(row["PhoneNumber"]);
contactInformation.Email = Convert.ToString(row["Email"]);
contactInformation.Status = Convert.ToBoolean(row["Status"]);
contactInformation.Id = Convert.ToString(row["Id"]);
}
}
return(contactInformation);
}
catch (Exception)
{
throw;
}
}
