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