public List<CallingRecord> GetListOfPatientsToCallFromFileFamily(CallingRecordsParameters parameters) { string reason = string.Empty; StreamReader importFile = null; string line = string.Empty; string[] sdelimStr = null; string delimStr = ","; char[] delimiter = delimStr.ToCharArray(); string[] sdelimStr2 = null; string delimStr2 = " "; char[] delimiter2 = delimStr2.ToCharArray(); string reminderConnectionNET = string.Empty; long nameID = 20000; long telephoneID = 1; string _sql = string.Empty; int count = 1; //int count2 = 1; List<Appointments> appointments = new List<Appointments>(); List<CallingRecord> callingRecords = new List<CallingRecord>(); try { importFile = File.OpenText(parameters.Parameter1); while ((line = importFile.ReadLine()) != null) { if (line.Length > 15) { sdelimStr = line.Split(delimiter, 20); sdelimStr2 = sdelimStr[2].Split(delimiter2, 20); bool bReturn = false; try { // bReturn = CheckToSeeIfCallIsCompleted(Common.ConvertTelephoneNumber2(sdelimStr[4]), sdelimStr[3]); } catch (Exception er) { string dd = er.Message; } if (bReturn) { string ff = string.Empty; } else { try { //reason = sdelimStr[11].Replace("'", "''").Trim().Substring(0, 13); reason = sdelimStr[11]; reason = reason.Replace("\"", ""); } catch { reason = string.Empty; } } } CallingRecord callingRecord = new CallingRecord(); try { callingRecord.FirstName = sdelimStr[1].Replace("\"", "").Trim(); } catch { callingRecord.FirstName = string.Empty; } try { callingRecord.LastName = sdelimStr[0].Replace("\"", "").Trim(); } catch { callingRecord.LastName = string.Empty; } try { callingRecord.Provider = sdelimStr[6].Replace("\"", "").Trim(); //appointment.D } catch { callingRecord.Provider = string.Empty; } //EntityID callingRecord.Company_ID = int.Parse(System.Configuration.ConfigurationManager.AppSettings["companyID"]); callingRecord.NameID = (int)nameID; callingRecord.TelephoneID = (int)telephoneID; callingRecord.MessageTime = 0; try { callingRecord.DateOfAppointment = sdelimStr[3].Replace("\"", "").Trim(); } catch { callingRecord.DateOfAppointment = string.Empty; } try { callingRecord.TimeOfAppointment = sdelimStr[4].Replace("\"", "").Trim(); } catch { callingRecord.TimeOfAppointment = string.Empty; } try { callingRecord.ApTime = callingRecord.TimeOfAppointment.Replace(":", ""); } catch { callingRecord.ApTime = string.Empty; } try { callingRecord.Date1 = Common.GetMonthFromDate(sdelimStr[3].Replace("\"", "")); } catch { callingRecord.Date1 = string.Empty; } try { DateTime appointmentDay = DateTime.Parse(callingRecord.DateOfAppointment); } catch { } try { callingRecord.Date2 = Common.GetDayNumberFromDate(sdelimStr[4].Replace("\"", "")); } catch { callingRecord.Date2 = string.Empty; } try { callingRecord.TimeForDelete = DateTime.Parse(sdelimStr[4].Replace("\"", "")); //callingRecord.TimeForDelete = DateTime.Parse(ConvertTimeOfAppointment3(sdelimStr[6])); } catch (Exception er) { string s1 = er.Message; //callingRecord.TimeForDelete = string.Empty; } try { callingRecord.Day = Common.GetDayFromDate(sdelimStr[3].Replace("\"", "")); } catch { callingRecord.Day = string.Empty; } try { callingRecord.TelephoneNumber1 = Common.ConvertTelephoneNumber(sdelimStr[2].Replace("\"", "").Trim()) .Replace("-", "") .Replace("(", "") .Replace(")", "") .Replace(" ", ""); callingRecord.TelephoneNumber1 = CheckTelephoneNumber(callingRecord.TelephoneNumber1); } catch { callingRecord.TelephoneNumber1 = string.Empty; } callingRecord.TelephoneNumber2 = "0"; try { callingRecord.TelephoneFile = sdelimStr[2].Replace("\"", "").Trim() .Replace("-", "") .Replace("(", "") .Replace(")", "") .Replace(" ", ""); } catch { callingRecord.TelephoneFile = string.Empty; } try { callingRecord.ReasonCode = sdelimStr[7].Replace("\"", "").Trim(); } catch { callingRecord.ReasonCode = string.Empty; } try { callingRecord.ReasonForAppointment = string.Empty; } catch { callingRecord.ReasonForAppointment = string.Empty; } try { callingRecord.Location = sdelimStr[8].Replace("\"", "").Trim(); } catch { callingRecord.Location = string.Empty; } callingRecord.Charge = "FAMILY"; callingRecord.InUse = "N"; callingRecord.Completed = "N"; callingRecord.CallWait = 0; callingRecord.MessageTime = 0; callingRecord.Busy = 0; callingRecord.ResultDescription = "Waiting To Call"; //callingRecord.Acknowledge //callingRecord.CallBack //callingRecord.Cancel //callingRecords.Add(callingRecord); InsertCallingRecord(callingRecord); nameID++; telephoneID++; count++; Console.WriteLine(count.ToString()); } importFile.Close(); return callingRecords; } catch (Exception er) { //Log.WhichProgram = "Labcorp Interface"; Log.LogMessage(er.ToString()); importFile.Close(); return callingRecords; } }
public void InsertCallingRecord(CallingRecord callingRecord) { using (MySqlConnection db = new MySqlConnection(Database.ReminderConnection)) { try { const string query = "insert into pendingtelephone(TelephoneID,Company_ID,MessageTime," + "NameID,FirstName,LastName,Provider,DateOfAppointment," + "TimeOfAppointment,TimeForDelete,Day,Date1,Date2,ApTime,Location," + "TelephoneNumber1,TelephoneNumber2,TelephoneFile,ReasonCode,ReasonForAppointment," + "Completed,InUse,CallWait,ResultDescription,Acknowledge," + "CallBack,Cancel,Busy,Call_Count,Time_Of_Call,Charge)values(" + "@TelephoneID,@Company_ID,@MessageTime," + "@NameID,@FirstName,@LastName,@Provider,@DateOfAppointment," + "@TimeOfAppointment,@TimeForDelete,@Day,@Date1,@Date2,@ApTime,@Location," + "@TelephoneNumber1,@TelephoneNumber2,@TelephoneFile,@ReasonCode,@ReasonForAppointment," + "@Completed,@InUse,@CallWait,@ResultDescription,@Acknowledge," + "@CallBack,@Cancel,@Busy,@Call_Count,@Time_Of_Call,@Charge)"; int rowsAffectd = db.Execute(query, callingRecord); } catch (Exception er) { string s1 = er.Message; //Log.WhichProgram = "Labcorp Interface"; Log.LogMessage(er.ToString()); } } }
public void GetListOfPatientsToCallPenChart(string dates) { int nameId = 200; int telephoneId = 5000; List<Appointments> appointments = new List<Appointments>(); try { using (IDbConnection db = new SqlConnection(Database.PenChart)) { const string query = "select * from appointments A,Patients B " + " Where A.Patid = B.Patid " + " and A.Apptdate = @dates"; //return db.Query<Appointments>(query, new { @dates = dates }).ToList(); appointments = db.Query<Appointments>(query, new { @dates = dates }).ToList(); } } catch (Exception er) { //Log.WhichProgram = "Labcorp Interface"; Log.LogMessage(er.ToString()); //return false; //return appointments; } try { for (int i = 0; i < appointments.Count; i++) { CallingRecord callingRecord = new CallingRecord(); callingRecord.FirstName = appointments[i].firstname; callingRecord.LastName = appointments[i].LastName; callingRecord.Provider = Common.GetProviderNamePenchart(appointments[i].EntityID.ToString()); //EntityID callingRecord.Company_ID = int.Parse(System.Configuration.ConfigurationManager.AppSettings["companyID"]); callingRecord.NameID = nameId; callingRecord.TelephoneID = telephoneId; callingRecord.MessageTime = 0; //ApptDate callingRecord.DateOfAppointment = Common.GetAppointmentDatePenchart(appointments[i].ApptDate); callingRecord.TimeOfAppointment = Common.GetAppointmentTimePenchart(appointments[i].StartTime); callingRecord.ApTime = callingRecord.TimeOfAppointment.Replace(":", ""); callingRecord.Date1 = Common.GetMonthPenchart(DateTime.Parse(callingRecord.DateOfAppointment).Month); DateTime appointmentDay = DateTime.Parse(callingRecord.DateOfAppointment); callingRecord.Date2 = Common.GetDayOfMonthPenchart(appointmentDay.Day); // callingRecord.Date2 = Common.GetDayOfMonth(appointmentDay.Day); callingRecord.TimeForDelete = DateTime.Parse(callingRecord.TimeOfAppointment); callingRecord.Day = Common.GetDayOfWeekPenChart(appointmentDay); //*********************************************** //for testing //telephone number that is out of order 8602644624 //telephone number that is out of order 8602644622 callingRecord.TelephoneNumber1 = "8602325449"; callingRecord.TelephoneNumber2 = "0"; callingRecord.TelephoneFile = "8602325449"; //testing for now answer and busy //callingRecord.TelephoneNumber1 = "8602644622"; //callingRecord.TelephoneNumber2 = "0"; //callingRecord.TelephoneFile = "8602644622"; /* callingRecord.TelephoneNumber1 = appointments[i].homephone .Replace("-", "") .Replace("(", "") .Replace(")", "") .Replace(" ", ""); callingRecord.TelephoneNumber2 = "0"; callingRecord.TelephoneFile = appointments[i].homephone .Replace("-", "") .Replace("(", "") .Replace(")", "") .Replace(" ", ""); */ callingRecord.ReasonCode = appointments[i].VisitTypeID.ToString(); callingRecord.InUse = "N"; callingRecord.Completed = "N"; callingRecord.Location = Common.GetLocationNamePenchart(appointments[i].LocationID.ToString()); callingRecord.CallWait = 0; callingRecord.MessageTime = 0; callingRecord.Busy = 0; callingRecord.Charge = "CENTER"; callingRecord.ResultDescription = "Waiting To Call"; //callingRecord.Acknowledge //callingRecord.CallBack //callingRecord.Cancel InsertCallingRecord(callingRecord); nameId++; telephoneId++; } } catch (Exception er) { Log.LogMessage(er.ToString()); } //return appointments; }