public void LogACall(LogCall logCall)
{
using (MySqlConnection db = new MySqlConnection(Database.ReminderConnection))
{
try
{
const string query =
"insert into log_call(Company_ID,NameID,FirstName,Provider,DateOfAppointment,"
+ "TimeOfAppointment,TelephoneNumber,Result,LogTime,Length_Of_Call)"
+ "values(@Company_ID,@NameID,@FirstName,@Provider,@DateOfAppointment,"
+ "@TimeOfAppointment,@TelephoneNumber,@Result,@LogTime,@Length_Of_Call)";
int rowsAffectd = db.Execute(query, logCall);
}
catch (Exception er)
{
Log.LogMessage(er.ToString());
}
}
}
//public void UpdateCallingRecordPatientPushedNine(string telephoneID, double duration, DateTime endOfCall)
//{
// DateTime currentTime = DateTime.Now.AddMinutes(30);
// long newcallingTime = currentTime.Ticks;
// bool isVoicMailCall = false;
// int numberOfCalls = ReturnSingleInt(" select call_count from pendingtelephone"
// + " where TelephoneID = " + telephoneID);
// numberOfCalls++;
// using (MySqlConnection cn = new MySqlConnection(Database.ReminderConnection))
// {
// cn.Open();
// using (MySqlCommand cm = cn.CreateCommand())
// {
// cm.CommandText = "select count(*) from pendingtelephone "
// + " where TelephoneID = @telephoneID"
// + " and resultdescription = 'Call Completed - VoiceMail'";
// cm.CommandType = System.Data.CommandType.Text;
// cm.Parameters.AddWithValue("@telephoneID", telephoneID);
// MySqlDataReader dr = cm.ExecuteReader();
// dr.Read();
// if (dr.GetInt32(0) > 0)
// {
// isVoicMailCall = true;
// }
// else
// {
// isVoicMailCall = false;
// }
// }
// }
// if (isVoicMailCall == false)
// {
// using (MySqlConnection db = new MySqlConnection(Database.ReminderConnection))
// {
// try
// {
// string query =
// "update pendingtelephone"
// + " set completed = 'Y'"
// + " , resultdescription = 'Call Completed - Patient Pushed 9 No Further Calls Made'"
// + " , time_of_call = @time_of_call"
// + " , call_count = @call_count"
// + " , messageTime = @messageTime"
// + " where TelephoneID = @telephoneID";
// int rowsAffectd = db.Execute(query, new
// {
// @telephoneID = telephoneID,
// @call_count = numberOfCalls,
// @time_of_call = endOfCall.ToShortDateString() + " " + endOfCall.ToShortTimeString(),
// @messageTime = duration
// });
// }
// catch (Exception er)
// {
// Log.LogMessage(er.ToString());
// }
// try
// {
// List<CallingRecord> callingRecord = new List<CallingRecord>();
// LogCall logCall = new LogCall();
// callingRecord = GetPatientRecord(telephoneID);
// logCall.Company_ID = callingRecord[0].Company_ID;
// logCall.DateOfAppointment = callingRecord[0].DateOfAppointment;
// logCall.Provider = callingRecord[0].Provider;
// logCall.FirstName = callingRecord[0].FirstName + " " + callingRecord[0].LastName;
// logCall.TelephoneID = callingRecord[0].TelephoneID.ToString();
// logCall.LogTime = DateTime.Now;
// logCall.NameID = callingRecord[0].NameID;
// logCall.Length_Of_Call = (int)duration;
// logCall.TelephoneNumber = callingRecord[0].TelephoneFile;
// logCall.TimeOfAppointment = callingRecord[0].TimeOfAppointment;
// logCall.Result = callingRecord[0].ResultDescription;
// LogACall(logCall);
// }
// catch (Exception er)
// {
// Log.LogMessage(er.ToString());
// }
// }
// }
// else
// {
// using (MySqlConnection db = new MySqlConnection(Database.ReminderConnection))
// {
// try
// {
// string query =
// "update pendingtelephone"
// + " set completed = 'Y'"
// + " , time_of_call = @time_of_call"
// + " , call_count = @call_count"
// + " , messageTime = @messageTime"
// + " where TelephoneID = @telephoneID";
// int rowsAffectd = db.Execute(query, new
// {
// @telephoneID = telephoneID,
// @call_count = numberOfCalls,
// @time_of_call = endOfCall.ToShortDateString() + " " + endOfCall.ToShortTimeString(),
// @messageTime = duration
// });
// }
// catch (Exception er)
// {
// Log.LogMessage(er.ToString());
// }
// try
// {
// List<CallingRecord> callingRecord = new List<CallingRecord>();
// LogCall logCall = new LogCall();
// callingRecord = GetPatientRecord(telephoneID);
// logCall.Company_ID = callingRecord[0].Company_ID;
// logCall.DateOfAppointment = callingRecord[0].DateOfAppointment;
// logCall.Provider = callingRecord[0].Provider;
// logCall.FirstName = callingRecord[0].FirstName + " " + callingRecord[0].LastName;
// logCall.TelephoneID = callingRecord[0].TelephoneID.ToString();
// logCall.LogTime = DateTime.Now;
// logCall.NameID = callingRecord[0].NameID;
// logCall.Length_Of_Call = (int)duration;
// logCall.TelephoneNumber = callingRecord[0].TelephoneFile;
// logCall.TimeOfAppointment = callingRecord[0].TimeOfAppointment;
// logCall.Result = callingRecord[0].ResultDescription;
// LogACall(logCall);
// }
// catch (Exception er)
// {
// Log.LogMessage(er.ToString());
// }
// }
// }
//}
//public void UpdateCallingTimeToShortNotCompleted(string patientID, double duration, DateTime endOfCall, string callOutcome)
public void UpdateCallingRecordNotCompleted(string telephoneID, double duration, DateTime endOfCall, string callOutcome)
{
string resultDescription = string.Empty;
DateTime currentTime = DateTime.Now.AddMinutes(30);
long newcallingTime = currentTime.Ticks;
int numberOfCalls = ReturnSingleInt(" select call_count from pendingtelephone"
+ " where TelephoneID = " + telephoneID);
numberOfCalls++;
switch (callOutcome)
{
case "UNALLOCATED_NUMBER":
resultDescription = " , resultdescription = 'Unallocated Number'";
break;
case "USER_BUSY":
resultDescription = " , resultdescription = 'Phone Busy'";
break;
case "NORMAL_TEMPORARY_FAILURE":
resultDescription = " , resultdescription = 'Normal Temporary Failure'";
break;
case "NO_ANSWER":
resultDescription = " , resultdescription = 'No Answer'";
break;
case "CALL_REJECTED":
resultDescription = " , resultdescription = 'Call Rejected'";
break;
case "NORMAL_CLEARING":
resultDescription = " , resultdescription = 'Patient did not Hear Message'";
break;
default:
resultDescription = " , resultdescription = 'Unknown'";
break;
}
//resultDescription = " , resultdescription = 'Patient Did not Respond Will Try again in 120 Minutes'";
using (MySqlConnection db = new MySqlConnection(Database.ReminderConnection))
{
try
{
string query =
"update pendingtelephone"
+ " set completed = 'N'"
+ resultDescription
+ " , time_of_call = @time_of_call"
+ " , call_count = @call_count"
+ " , callwait = @callwait"
+ " , messageTime = @messageTime"
+ " where TelephoneID = @telephoneID";
int rowsAffectd = db.Execute(query, new
{
@telephoneID = telephoneID,
@call_count = numberOfCalls,
@time_of_call = endOfCall.ToShortDateString() + " " + endOfCall.ToShortTimeString(),
@callwait = newcallingTime.ToString(),
@messageTime = duration
});
}
catch (Exception er)
{
Log.LogMessage(er.ToString());
}
try
{
List<CallingRecord> callingRecord = new List<CallingRecord>();
LogCall logCall = new LogCall();
callingRecord = GetPatientRecord(telephoneID);
logCall.Company_ID = callingRecord[0].Company_ID;
logCall.DateOfAppointment = callingRecord[0].DateOfAppointment;
logCall.Provider = callingRecord[0].Provider;
logCall.FirstName = callingRecord[0].FirstName + " " + callingRecord[0].LastName;
logCall.Length_Of_Call = callingRecord[0].TelephoneID;
logCall.LogTime = DateTime.Now;
logCall.NameID = callingRecord[0].NameID;
logCall.Length_Of_Call = (int)duration;
logCall.TelephoneNumber = callingRecord[0].TelephoneFile;
logCall.TimeOfAppointment = callingRecord[0].TimeOfAppointment;
logCall.Result = callingRecord[0].ResultDescription;
LogACall(logCall);
}
catch (Exception er)
{
Log.LogMessage(er.ToString());
}
}
//DateTime currentTime = DateTime.Now.AddMinutes(30);
//long newcallingTime = currentTime.Ticks;
//bool isVoicMailCall = false;
//int numberOfCalls = ReturnSingleInt(" select call_count from pendingtelephone"
// + " where nameid = " + patientID);
//numberOfCalls++;
//using (MySqlConnection cn = new MySqlConnection(Database.ReminderConnection))
//{
// cn.Open();
// using (MySqlCommand cm = cn.CreateCommand())
// {
// cm.CommandText = "select count(*) from pendingtelephone "
// + " where nameid = @NameID"
// + " and resultdescription = 'Call Completed - VoiceMail'";
// cm.CommandType = System.Data.CommandType.Text;
// cm.Parameters.AddWithValue("@NameID", patientID);
// MySqlDataReader dr = cm.ExecuteReader();
// dr.Read();
// if (dr.GetInt32(0) > 0)
// {
// isVoicMailCall = true;
// }
// else
// {
// isVoicMailCall = false;
// }
// }
//}
//if (isVoicMailCall == false)
//{
// using (MySqlConnection db = new MySqlConnection(Database.ReminderConnection))
// {
// try
// {
// string query =
// "update pendingtelephone"
// + " set completed = 'Y'"
// + " , resultdescription = 'Call Completed - Person Picked Up'"
// + " , time_of_call = @time_of_call"
// + " , call_count = @call_count"
// + " , messageTime = @messageTime"
// + " where nameID = @nameID";
// int rowsAffectd = db.Execute(query, new
// {
// @nameID = patientID,
// @call_count = numberOfCalls,
// @time_of_call = endOfCall.ToShortDateString() + " " + endOfCall.ToShortTimeString(),
// @messageTime = duration
// });
// }
// catch (Exception er)
// {
// Log.LogMessage(er.ToString());
// }
// try
// {
// List<CallingRecord> callingRecord = new List<CallingRecord>();
// LogCall logCall = new LogCall();
// callingRecord = GetPatientRecord(patientID);
// logCall.Company_ID = callingRecord[0].Company_ID;
// logCall.DateOfAppointment = callingRecord[0].DateOfAppointment;
// logCall.Provider = callingRecord[0].Provider;
// logCall.FirstName = callingRecord[0].FirstName + " " + callingRecord[0].LastName;
// logCall.Length_Of_Call = callingRecord[0].TelephoneID;
// logCall.LogTime = DateTime.Now;
// logCall.NameID = callingRecord[0].NameID;
// logCall.Length_Of_Call = (int)duration;
// logCall.TelephoneNumber = callingRecord[0].TelephoneFile;
// logCall.TimeOfAppointment = callingRecord[0].TimeOfAppointment;
// logCall.Result = callingRecord[0].ResultDescription;
// LogACall(logCall);
// }
// catch (Exception er)
// {
// Log.LogMessage(er.ToString());
// }
// }
//}
//else
//{
// using (MySqlConnection db = new MySqlConnection(Database.ReminderConnection))
// {
// try
// {
// string query =
// "update pendingtelephone"
// + " set completed = 'Y'"
// + " , time_of_call = @time_of_call"
// + " , call_count = @call_count"
// + " , messageTime = @messageTime"
// + " where nameID = @nameID";
// int rowsAffectd = db.Execute(query, new
// {
// @nameID = patientID,
// @call_count = numberOfCalls,
// @time_of_call = endOfCall.ToShortDateString() + " " + endOfCall.ToShortTimeString(),
// @messageTime = duration
// });
// }
// catch (Exception er)
// {
// Log.LogMessage(er.ToString());
// }
// try
// {
// List<CallingRecord> callingRecord = new List<CallingRecord>();
// LogCall logCall = new LogCall();
// callingRecord = GetPatientRecord(patientID);
// logCall.Company_ID = callingRecord[0].Company_ID;
// logCall.DateOfAppointment = callingRecord[0].DateOfAppointment;
// logCall.Provider = callingRecord[0].Provider;
// logCall.FirstName = callingRecord[0].FirstName + " " + callingRecord[0].LastName;
// logCall.Length_Of_Call = callingRecord[0].TelephoneID;
// logCall.LogTime = DateTime.Now;
// logCall.NameID = callingRecord[0].NameID;
// logCall.Length_Of_Call = (int)duration;
// logCall.TelephoneNumber = callingRecord[0].TelephoneFile;
// logCall.TimeOfAppointment = callingRecord[0].TimeOfAppointment;
// logCall.Result = callingRecord[0].ResultDescription;
// LogACall(logCall);
// }
// catch (Exception er)
// {
// Log.LogMessage(er.ToString());
// }
// }
//}
}
public void UpdateCallingNoAnswer(string telephoneID, double duration, DateTime endOfCall)
{
DateTime currentTime = DateTime.Now.AddMinutes(30);
long newcallingTime = currentTime.Ticks;
int numberOfCalls = ReturnSingleInt(" select call_count from pendingtelephone"
+ " where TelephoneID = " + telephoneID);
numberOfCalls++;
using (MySqlConnection db = new MySqlConnection(Database.ReminderConnection))
{
try
{
string query =
"update pendingtelephone"
+ " set completed = 'N'"
+ " , resultdescription = 'No Answer'"
+ " , time_of_call = @time_of_call"
+ " , call_count = @call_count"
+ " , callwait = @callwait"
+ " where TelephoneID = @telephoneID";
int rowsAffectd = db.Execute(query, new
{
@telephoneID = telephoneID,
@call_count = numberOfCalls,
@time_of_call = endOfCall.ToShortDateString() + " " + endOfCall.ToShortTimeString(),
@callwait = newcallingTime.ToString()
});
}
catch (Exception er)
{
Log.LogMessage(er.ToString());
}
try
{
List<CallingRecord> callingRecord = new List<CallingRecord>();
LogCall logCall = new LogCall();
callingRecord = GetPatientRecord(telephoneID);
logCall.Company_ID = callingRecord[0].Company_ID;
logCall.DateOfAppointment = callingRecord[0].DateOfAppointment;
logCall.Provider = callingRecord[0].Provider;
logCall.FirstName = callingRecord[0].FirstName + " " + callingRecord[0].LastName;
logCall.TelephoneID = callingRecord[0].TelephoneID.ToString();
logCall.LogTime = DateTime.Now;
logCall.NameID = callingRecord[0].NameID;
logCall.Length_Of_Call = (int)duration;
logCall.TelephoneNumber = callingRecord[0].TelephoneFile;
logCall.TimeOfAppointment = callingRecord[0].TimeOfAppointment;
logCall.Result = callingRecord[0].ResultDescription;
LogACall(logCall);
}
catch (Exception er)
{
Log.LogMessage(er.ToString());
}
}
}
public void UpdateCallingRecordCompleted(string telephoneID, double duration, DateTime endOfCall)
{
DateTime currentTime = DateTime.Now.AddMinutes(30);
long newcallingTime = currentTime.Ticks;
bool isVoicMailCall = false;
int numberOfCalls = ReturnSingleInt(" select call_count from pendingtelephone"
+ " where TelephoneID = " + telephoneID);
numberOfCalls++;
using (MySqlConnection cn = new MySqlConnection(Database.ReminderConnection))
{
cn.Open();
using (MySqlCommand cm = cn.CreateCommand())
{
cm.CommandText = "select count(*) from pendingtelephone "
+ " where TelephoneID = @telephoneID"
+ " and resultdescription = 'Call Completed - VoiceMail'";
cm.CommandType = System.Data.CommandType.Text;
cm.Parameters.AddWithValue("@telephoneID", telephoneID);
MySqlDataReader dr = cm.ExecuteReader();
dr.Read();
if (dr.GetInt32(0) > 0)
{
isVoicMailCall = true;
}
else
{
isVoicMailCall = false;
}
}
}
if (isVoicMailCall == false)
{
using (MySqlConnection db = new MySqlConnection(Database.ReminderConnection))
{
try
{
string query =
"update pendingtelephone"
+ " set completed = 'Y'"
+ " , resultdescription = 'Call Completed - Person Picked Up'"
+ " , time_of_call = @time_of_call"
+ " , call_count = @call_count"
+ " , messageTime = @messageTime"
+ " where TelephoneID = @telephoneID";
int rowsAffectd = db.Execute(query, new
{
@telephoneID = telephoneID,
@call_count = numberOfCalls,
@time_of_call = endOfCall.ToShortDateString() + " " + endOfCall.ToShortTimeString(),
@messageTime = duration
});
}
catch (Exception er)
{
Log.LogMessage(er.ToString());
}
try
{
List<CallingRecord> callingRecord = new List<CallingRecord>();
LogCall logCall = new LogCall();
callingRecord = GetPatientRecord(telephoneID);
logCall.Company_ID = callingRecord[0].Company_ID;
logCall.DateOfAppointment = callingRecord[0].DateOfAppointment;
logCall.Provider = callingRecord[0].Provider;
logCall.FirstName = callingRecord[0].FirstName + " " + callingRecord[0].LastName;
logCall.TelephoneID = callingRecord[0].TelephoneID.ToString();
logCall.LogTime = DateTime.Now;
logCall.NameID = callingRecord[0].NameID;
logCall.Length_Of_Call = (int)duration;
logCall.TelephoneNumber = callingRecord[0].TelephoneFile;
logCall.TimeOfAppointment = callingRecord[0].TimeOfAppointment;
logCall.Result = callingRecord[0].ResultDescription;
LogACall(logCall);
}
catch (Exception er)
{
Log.LogMessage(er.ToString());
}
}
}
else
{
using (MySqlConnection db = new MySqlConnection(Database.ReminderConnection))
{
try
{
string query =
"update pendingtelephone"
+ " set completed = 'Y'"
+ " , time_of_call = @time_of_call"
+ " , call_count = @call_count"
+ " , messageTime = @messageTime"
+ " where TelephoneID = @telephoneID";
int rowsAffectd = db.Execute(query, new
{
@telephoneID = telephoneID,
@call_count = numberOfCalls,
@time_of_call = endOfCall.ToShortDateString() + " " + endOfCall.ToShortTimeString(),
@messageTime = duration
});
}
catch (Exception er)
{
Log.LogMessage(er.ToString());
}
try
{
List<CallingRecord> callingRecord = new List<CallingRecord>();
LogCall logCall = new LogCall();
callingRecord = GetPatientRecord(telephoneID);
logCall.Company_ID = callingRecord[0].Company_ID;
logCall.DateOfAppointment = callingRecord[0].DateOfAppointment;
logCall.Provider = callingRecord[0].Provider;
logCall.FirstName = callingRecord[0].FirstName + " " + callingRecord[0].LastName;
logCall.TelephoneID = callingRecord[0].TelephoneID.ToString();
logCall.LogTime = DateTime.Now;
logCall.NameID = callingRecord[0].NameID;
logCall.Length_Of_Call = (int)duration;
logCall.TelephoneNumber = callingRecord[0].TelephoneFile;
logCall.TimeOfAppointment = callingRecord[0].TimeOfAppointment;
logCall.Result = callingRecord[0].ResultDescription;
LogACall(logCall);
}
catch (Exception er)
{
Log.LogMessage(er.ToString());
}
}
}
}