public FullClient GetFullClientByClientSerial(int clientSerial) { FullClient fullClient = new FullClient(); var model = _ClientRepository.GetFullClientByClientSerial(clientSerial); return(fullClient); }
public FullClient GetFullClientByClientSerial(int clientSerial) { FullClient fullClient = new FullClient(); Client myClient = new Client(); Communication MyCommunication = new Communication(); List <Conversation> conversationList = new List <Conversation>(); using (SqlConnection connection = new SqlConnection(MyStringConnection)) { var sql = sql_client + ";" + MyStrings.SqlConversationWithParamsList + ";" + MyStrings.SqlCommunicationList; connection.Open(); SqlCommand command = new SqlCommand(sql, connection); command.Parameters.Add("@client_serial", System.Data.SqlDbType.Int, 4).Value = clientSerial; using (SqlDataReader dataReader = command.ExecuteReader()) { while (dataReader.Read()) { Client my_client = new Client(); my_client.id = Convert.ToInt32(dataReader["id"]); my_client.FirstName = Convert.ToString(dataReader["FirstName"]); my_client.LastName = Convert.ToString(dataReader["LastName"]); try { my_client.Birthday = Convert.ToDateTime(dataReader["Birthday"]); } catch (Exception) { } fullClient.CurrentClient = myClient; } dataReader.NextResult(); while (dataReader.Read()) { Conversation my_conversation = new Conversation(); my_conversation.Serial = Convert.ToInt32(dataReader["Serial"]); my_conversation.ClientSerial = Convert.ToInt32(dataReader["ClientSerial"]); my_conversation.SummaryOfConversation = Convert.ToString(dataReader["SummaryOfConversation"]); my_conversation.GoalOfTalkName = Convert.ToString(dataReader["GoalOfTalkName"]); my_conversation.TypeFollowupConversationName = Convert.ToString(dataReader["TypeFollowupConversationName"]); my_conversation.UserName = Convert.ToString(dataReader["UserName"]); my_conversation.NoPolice = Convert.ToString(dataReader["NoPolice"]); my_conversation.Datee = Convert.ToDateTime(dataReader["Datee"]); fullClient.ConversationsList.Add(my_conversation); } dataReader.NextResult(); while (dataReader.Read()) { Communication communication = new Communication(); communication.Serial = Convert.ToInt32(dataReader["Serial"]); communication.ClientSerial = Convert.ToInt32(dataReader["ClientSerial"]); communication.CommunicationType = Convert.ToString(dataReader["CommunicationType"]); communication.CommunicationValue = Convert.ToString(dataReader["CommunicationValue"]); communication.CommunicationValue = Convert.ToString(dataReader["Comment"]); fullClient.CommunicationsList.Add(communication); } } connection.Close(); } return(fullClient); }