Exemple #1
0
        public static string CreateChargeRequest(ref SqlDataReader reader, ref bool list, ref List <SyncEntities.SyncCharge> listCh)
        {
            if (reader == null)
            {
                return("");
            }

            string        json = "";
            List <string> cpts = new List <string>();

            while (reader.Read())
            {
                SyncEntities.SyncCharge ch = new SyncEntities.SyncCharge(
                    (long)reader["Id"],
                    reader["DateOfService"].ToString().Trim(),
                    reader["DateOfPosting"].ToString().Trim(),
                    reader["PracticeId"].ToString().Trim(),
                    reader["PatientId"].ToString().Trim(),
                    reader["CPTId"].ToString().Trim(),
                    reader["InsuranceCompanyId"].ToString().Trim(),
                    reader["Billed"].ToString().Trim(),
                    reader["Payment"].ToString().Trim(),
                    reader["Adjustment"].ToString().Trim(),
                    reader["Balance"].ToString().Trim(),
                    reader["UpdateDate"].ToString().Trim(),
                    reader["CreateDate"].ToString().Trim(),
                    reader["DoctorId"].ToString().Trim(),
                    reader["CaseNumber"].ToString().Trim(),
                    reader["StatusId"].ToString().Trim(),
                    reader["DueDate"].ToString().Trim(),
                    "805",
                    reader["LiveID"].ToString().Trim(),
                    reader["updated"].ToString().Trim(),
                    reader["toDelete"].ToString().Trim()
                    );


                cpts.Add(ch.GetNewHttpJson());
                listCh.Add(ch);
            }

            if (cpts.Count <= 0)
            {
                return("");
            }

            return(CreateListParams(cpts));
        }
Exemple #2
0
        public static Dictionary <string, List <SyncEntities.SyncCharge> > CreateChargeRequestList(ref SqlDataReader reader, ref List <string> charges2Update)
        {
            if (reader == null)
            {
                return(null);
            }

            Dictionary <string, List <SyncEntities.SyncCharge> > requests_ch = new Dictionary <string, List <SyncEntities.SyncCharge> >(StringComparer.OrdinalIgnoreCase);
            List <string> cpts = new List <string>();

            List <SyncEntities.SyncCharge> listCh = new List <SyncEntities.SyncCharge>();
            int count = 0;

            while (reader.Read())
            {
                SyncEntities.SyncCharge ch = new SyncEntities.SyncCharge(
                    (long)reader["Id"],
                    reader["DateOfService"].ToString().Trim(),
                    reader["DateOfPosting"].ToString().Trim(),
                    reader["PracticeId"].ToString().Trim(),
                    reader["PatientId"].ToString().Trim(),
                    reader["CPTId"].ToString().Trim(),
                    reader["InsuranceCompanyId"].ToString().Trim(),
                    reader["Billed"].ToString().Trim(),
                    reader["Payment"].ToString().Trim(),
                    reader["Adjustment"].ToString().Trim(),
                    reader["Balance"].ToString().Trim(),
                    reader["UpdateDate"].ToString().Trim(),
                    reader["CreateDate"].ToString().Trim(),
                    reader["DoctorId"].ToString().Trim(),
                    reader["CaseNumber"].ToString().Trim(),
                    reader["StatusId"].ToString().Trim(),
                    reader["DueDate"].ToString().Trim(),
                    "805",
                    reader["LiveID"].ToString().Trim(),
                    reader["updated"].ToString().Trim(),
                    reader["toDelete"].ToString().Trim()
                    );

                /* string ss = ch.GetNewHttpJson();
                 *   if (!ss.Contains("PolicyNumber"))
                 *   {
                 *           int jj = 0;
                 *   }*/
                cpts.Add(ch.GetNewHttpJson());
                charges2Update.Add(ch.GetChargeUpdateHttpJson());

                listCh.Add(ch);
                ++count;

                if (count >= 100)
                {
                    string json = CreateListParams(cpts);
                    List <SyncEntities.SyncCharge> lc = new List <SyncEntities.SyncCharge>();

                    lc.AddRange(listCh);
                    try
                    {
                        requests_ch.Add(json, lc);
                    }
                    catch { }
                    cpts.Clear();
                    listCh.Clear();
                    json  = "";
                    count = 0;
                }
            }

            if (cpts.Count > 0)
            {
                string js = CreateListParams(cpts);
                List <SyncEntities.SyncCharge> ll = new List <SyncEntities.SyncCharge>();
                ll.AddRange(listCh);
                requests_ch.Add(js, ll);
            }

            if (requests_ch.Count <= 0)
            {
                return(null);
            }

            return(requests_ch);
        }