/// <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; } }