public Guid AddClientInformation(ClientInformation ClientInformation) { Guid ClientInformationID = new Guid("00000000-0000-0000-0000-000000000000"); SqlConnection con = new SqlConnection(GlobalSettings.connection); con.Open(); SqlCommand Cmd = new SqlCommand("sp_AddClientInformation", con); Cmd.CommandType = System.Data.CommandType.StoredProcedure; Cmd.Parameters.AddWithValue("@Title", ClientInformation.Title); Cmd.Parameters.AddWithValue("@Name", ClientInformation.Name); Cmd.Parameters.AddWithValue("@MiddleName", ClientInformation.MiddleName); Cmd.Parameters.AddWithValue("@Surname", ClientInformation.Surname); Cmd.Parameters.AddWithValue("@Gender", ClientInformation.Gender); Cmd.Parameters.AddWithValue("@DateOfBirth", DataTypesConvertor.ConvertToDateTime(ClientInformation.DateOfBirth)); Cmd.Parameters.AddWithValue("@IDNumber", ClientInformation.IDNumber); Cmd.Parameters.AddWithValue("@Cell", ClientInformation.Cell); Cmd.Parameters.AddWithValue("@TelHome", ClientInformation.TelHome); Cmd.Parameters.AddWithValue("@TelWork", ClientInformation.TelWork); Cmd.Parameters.AddWithValue("@Email", ClientInformation.Email); Cmd.Parameters.AddWithValue("@StreetNameAndNumber", ClientInformation.StreetNameAndNumber); Cmd.Parameters.AddWithValue("@Suburb", ClientInformation.Suburb); Cmd.Parameters.AddWithValue("@City", ClientInformation.City); Cmd.Parameters.AddWithValue("@PostalCode", ClientInformation.PostalCode); SqlDataReader dr = Cmd.ExecuteReader(); while (dr.Read()) { ClientInformationID = DataTypesConvertor.ConvertToGuid(dr["ClientInformationID"].ToString()); } dr.Close(); con.Close(); return(ClientInformationID); }
public List <ClientInformation> GetAllClientInformation() { List <ClientInformation> ClientInformationDataList = new List <ClientInformation>(); SqlConnection con = new SqlConnection(GlobalSettings.connection); con.Open(); SqlCommand Cmd = new SqlCommand("sp_GetAllClientInformation", con); Cmd.CommandType = System.Data.CommandType.StoredProcedure; SqlDataReader dr = Cmd.ExecuteReader(); while (dr.Read()) { ClientInformation ClientInformation = new ClientInformation(); ClientInformation.ClientInformationID = DataTypesConvertor.ConvertToGuid(dr["ClientInformationID"].ToString()); ClientInformation.Title = dr["Title"].ToString(); ClientInformation.Name = dr["Name"].ToString(); ClientInformation.MiddleName = dr["MiddleName"].ToString(); ClientInformation.Surname = dr["Surname"].ToString(); ClientInformation.Gender = dr["Gender"].ToString(); ClientInformation.DateOfBirth = DataTypesConvertor.ConvertToDateTime(dr["DateOfBirth"].ToString()); ClientInformation.IDNumber = dr["IDNumber"].ToString(); ClientInformation.Cell = dr["Cell"].ToString(); ClientInformation.TelHome = dr["TelHome"].ToString(); ClientInformation.TelWork = dr["TelWork"].ToString(); ClientInformation.Email = dr["Email"].ToString(); ClientInformation.StreetNameAndNumber = dr["StreetNameAndNumber"].ToString(); ClientInformation.Suburb = dr["Suburb"].ToString(); ClientInformation.City = dr["City"].ToString(); ClientInformation.PostalCode = dr["PostalCode"].ToString(); ClientInformationDataList.Add(ClientInformation); } dr.Close(); con.Close(); return(ClientInformationDataList); }