| Author: Sujit Kumar 04 Jul 2008 | Member Level: Diamond | Rating:  Points: 6 |
objConnection = new SqlConnection(strIntConnectionString);
objCommand = new SqlCommand();
objCommand.Connection = objConnection;
objCommand.CommandType = CommandType.StoredProcedure;
objCommand.CommandText = "DialerPatientRecoredsNew";
objCommand.Parameters.Add("@phoneNumber", SqlDbType.VarChar).Value = phoneNo;
objCommand.Parameters.Add("@timeOfCall", SqlDbType.DateTime).Value = timeOfCall;
if (agentID > 0 && patientPrefAgentUserId != "")
objCommand.Parameters.Add("@leadFixAgent", SqlDbType.Int).Value = agentID;
else
objCommand.Parameters.Add("@leadFixAgent", SqlDbType.Int).Value = null;
if (language1 >= 0 && patientPrefLanguage1 != "")
objCommand.Parameters.Add("@language1", SqlDbType.VarChar).Value = patientPrefLanguage1;
else
objCommand.Parameters.Add("@language1", SqlDbType.VarChar).Value = null;
if (language2 >= 0 && patientPrefLanguage2 != "")
objCommand.Parameters.Add("@language2", SqlDbType.VarChar).Value = patientPrefLanguage2;
else
objCommand.Parameters.Add("@language2", SqlDbType.VarChar).Value = null;
objCommand.Parameters.Add("@sodLink", SqlDbType.VarChar).Value = sodPopLink;
objCommand.Parameters.Add("@apmntSystemID", SqlDbType.VarChar).Value = apptmntExternalSystemId;
objCommand.Parameters.Add("@apmntID", SqlDbType.VarChar).Value = apptmntId;
objCommand.Parameters.Add("@attemptNumber", SqlDbType.Int).Value = attemptNumber;
objCommand.Parameters.Add("@callNumber", SqlDbType.Int).Value = callNumber;
objCommand.Parameters.Add("@patientSystemID", SqlDbType.VarChar).Value = patientExternalSystemId;
objCommand.Parameters.Add("@fixagenttimeout", SqlDbType.Int).Value = agentTimeOut;
objCommand.Parameters.Add("@moduletimeout", SqlDbType.Int).Value = moduleTimeOut;
objConnection.Open();
Int32 ID = Convert.ToInt32(objCommand.ExecuteScalar());
objConnection.Close();
if (ID > 0)
{
return "SUCESS";
}
else
return "FAIL";
}
catch (Exception ex)
{
return ex.Message.ToString();
}
}
public Int32 CheckAgent(String agentLoginID)
{
try
{
objConnection = new SqlConnection(strIntConnectionString);
objCommand = new SqlCommand();
objCommand.Connection = objConnection;
objCommand.CommandType = CommandType.Text;
objCommand.CommandText = "Select agent_agent_id from cti_agents where agent_login_id='" + agentLoginID + "'";
objConnection.Open();
Int32 agentID = Convert.ToInt32(objCommand.ExecuteScalar());
objConnection.Close();
|