public static List <Bill_Record_Data> GetBillRecs(string pft_enc_id) { int cnt = 0; string today = DateTime.Today.ToString("yyyyMMdd"); DateTime todayDt = DateTime.Today; StringBuilder sb = new StringBuilder(); sb.Append("SELECT PFT_ENCNTR_ID,PFT_PRORATION_ID,ENCNTR_PLAN_RELTN_ID,HEALTH_PLAN_ID,BO_HP_RELTN_ID,TOTAL_BILLED_AMOUNT,TOTAL_BILLED_DR_CR_FLAG,TOTAL_PAID_AMOUNT,TOTAL_PAID_DR_CR_FLAG,TOTAL_ADJ_AMOUNT,TOTAL_ADJ_DR_CR_FLAG,BOHP_ACTIND,AMOUNT_OWED,AMOUNT_OWED_DR_CR_FLAG,BOHP_ENDEFFDATE,PRIORITY_SEQ,ORIG_AMT_DUE,ORIG_AMOUNT_DR_CR_FLAG,HIGH_AMT,HIGH_AMOUNT_DR_CR_FLAG,CURR_AMT_DUE,CURR_AMOUNT_DR_CR_FLAG,NON_COVERED_AMT,NON_COVERED_AMT_DR_CR_FLAG,TOTAL_ADJ,Proration_TotAdjDRCRFlag,Proration_EndEffDt,Proration_ActInd,BILL_RELTN_ID,CORSP_ACTIVITY_ID,BillReltnActInd,BillReltnEndEffDt,PARENT_ENTITY_ID,PARENT_ENTITY_NAME,BILL_VRSN_NBR,BILL_NBR_DISP,BILL_STATUS_CD,BILL_STATUS_REASON_CD,BillRec_ActInd,BillRec_EndEffDt,BALANCE,BILL_NBR_DISP_KEY,BILL_CLASS_CD,GEN_DT_TM,PAGE_CNT,BILL_TYPE_CD,BALANCE_DR_CR_FLAG,BALANCE_FWD,BALANCE_FWD_DR_CR_FLAG,BALANCE_DUE,BALANCE_DUE_DR_CR_FLAG,NEW_AMOUNT,NEW_AMOUNT_DR_CR_FLAG,CLAIM_STATUS_CD,SUBMIT_DT_TM,LAST_PAYMENT_DT_TM,LAST_ADJUSTMENT_DT_TM,CLAIM_SERIAL_NBR,TRANSMISSION_DT_TM,FROM_SERVICE_DT_TM,TO_SERVICE_DT_TM,STATEMENT_TO_DT_TM,STATEMENT_FROM_DT_TM "); sb.Append("FROM [vBAR_BillRecords] "); sb.Append("WHERE PFT_ENCNTR_ID = " + long.Parse(pft_enc_id) + " "); DataTable dt = new DataTable(); using (var conn = new SqlConnection(GlobalSettings.SqlConnectionString())) using (var cmd = new SqlCommand(sb.ToString(), conn)) using (var da = new SqlDataAdapter(cmd)) { cmd.CommandType = CommandType.Text; da.Fill(dt); } List <Bill_Record_Data> bills = new List <Bill_Record_Data>(); foreach (DataRow row in dt.Rows) { if (row["BOHP_ACTIND"].ToString().Trim() == "1" && row["Proration_ActInd"].ToString().Trim() == "1" && row["BillReltnActInd"].ToString().Trim() == "1" && row["BillRec_ActInd"].ToString().Trim() == "1") { if (GetEffDt(row["Proration_EndEffDt"].ToString().Trim()) > int.Parse(today) && GetEffDt(row["BOHP_ENDEFFDATE"].ToString().Trim()) > int.Parse(today) && GetEffDt(row["BillReltnEndEffDt"].ToString().Trim()) > int.Parse(today) && GetEffDt(row["BillRec_EndEffDt"].ToString().Trim()) > int.Parse(today)) { Bill_Record_Data bill = LoadBillsData(row); bills.Add(bill); } } } dt.Dispose(); return(bills); }
private static Bill_Record_Data LoadBillsData(DataRow row) { Bill_Record_Data bill = new Bill_Record_Data(); bill.PFT_ENCNTR_ID = row["PFT_ENCNTR_ID"].ToString(); bill.PFT_PRORATION_ID = row["PFT_PRORATION_ID"].ToString(); bill.ENCNTR_PLAN_RELTN_ID = row["ENCNTR_PLAN_RELTN_ID"].ToString(); bill.HEALTH_PLAN_ID = row["HEALTH_PLAN_ID"].ToString(); bill.BO_HP_RELTN_ID = row["BO_HP_RELTN_ID"].ToString(); bill.TOTAL_BILLED_AMOUNT = row["TOTAL_BILLED_AMOUNT"].ToString(); bill.TOTAL_BILLED_DR_CR_FLAG = row["TOTAL_BILLED_DR_CR_FLAG"].ToString(); bill.TOTAL_PAID_AMOUNT = row["TOTAL_PAID_AMOUNT"].ToString(); bill.TOTAL_PAID_DR_CR_FLAG = row["TOTAL_PAID_DR_CR_FLAG"].ToString(); bill.TOTAL_ADJ_AMOUNT = row["TOTAL_ADJ_AMOUNT"].ToString(); bill.TOTAL_ADJ_DR_CR_FLAG = row["TOTAL_ADJ_DR_CR_FLAG"].ToString(); bill.BOHP_ACTIND = row["BOHP_ACTIND"].ToString(); bill.AMOUNT_OWED = row["AMOUNT_OWED"].ToString(); bill.AMOUNT_OWED_DR_CR_FLAG = row["AMOUNT_OWED_DR_CR_FLAG"].ToString(); bill.BOHP_ENDEFFDATE = row["BOHP_ENDEFFDATE"].ToString(); bill.PRIORITY_SEQ = row["PRIORITY_SEQ"].ToString(); bill.ORIG_AMT_DUE = row["ORIG_AMT_DUE"].ToString(); bill.ORIG_AMOUNT_DR_CR_FLAG = row["ORIG_AMOUNT_DR_CR_FLAG"].ToString(); bill.HIGH_AMT = row["HIGH_AMT"].ToString(); bill.HIGH_AMOUNT_DR_CR_FLAG = row["HIGH_AMOUNT_DR_CR_FLAG"].ToString(); bill.CURR_AMT_DUE = CheckAmt(row["CURR_AMT_DUE"].ToString()); bill.CURR_AMOUNT_DR_CR_FLAG = row["CURR_AMOUNT_DR_CR_FLAG"].ToString(); bill.NON_COVERED_AMT = row["NON_COVERED_AMT"].ToString(); bill.NON_COVERED_AMT_DR_CR_FLAG = row["NON_COVERED_AMT_DR_CR_FLAG"].ToString(); bill.TOTAL_ADJ = row["TOTAL_ADJ"].ToString(); bill.Proration_TotAdjDRCRFlag = row["Proration_TotAdjDRCRFlag"].ToString(); bill.Proration_EndEffDt = row["Proration_EndEffDt"].ToString(); bill.Proration_ActInd = row["Proration_ActInd"].ToString(); bill.BILL_RELTN_ID = row["BILL_RELTN_ID"].ToString(); bill.CORSP_ACTIVITY_ID = row["CORSP_ACTIVITY_ID"].ToString(); bill.BillReltnActInd = row["BillReltnActInd"].ToString(); bill.BillReltnEndEffDt = row["BillReltnEndEffDt"].ToString(); bill.PARENT_ENTITY_ID = row["PARENT_ENTITY_ID"].ToString(); bill.PARENT_ENTITY_NAME = row["PARENT_ENTITY_NAME"].ToString(); bill.BILL_VRSN_NBR = row["BILL_VRSN_NBR"].ToString(); bill.BILL_NBR_DISP = row["BILL_NBR_DISP"].ToString(); bill.BILL_STATUS_CD = row["BILL_STATUS_CD"].ToString(); bill.BILL_STATUS_REASON_CD = row["BILL_STATUS_REASON_CD"].ToString(); bill.BillRec_ActInd = row["BillRec_ActInd"].ToString(); bill.BillRec_EndEffDt = row["BillRec_EndEffDt"].ToString(); bill.BALANCE = row["BALANCE"].ToString(); bill.BILL_NBR_DISP_KEY = row["BILL_NBR_DISP_KEY"].ToString(); bill.BILL_CLASS_CD = row["BILL_CLASS_CD"].ToString(); bill.GEN_DT_TM = row["GEN_DT_TM"].ToString(); bill.PAGE_CNT = row["PAGE_CNT"].ToString(); bill.BILL_TYPE_CD = row["BILL_TYPE_CD"].ToString(); bill.BALANCE_DR_CR_FLAG = row["BALANCE_DR_CR_FLAG"].ToString(); bill.BALANCE_FWD = row["BALANCE_FWD"].ToString(); bill.BALANCE_FWD_DR_CR_FLAG = row["BALANCE_FWD_DR_CR_FLAG"].ToString(); bill.BALANCE_DUE = row["BALANCE_DUE"].ToString(); bill.BALANCE_DUE_DR_CR_FLAG = row["BALANCE_DUE_DR_CR_FLAG"].ToString(); bill.NEW_AMOUNT = row["NEW_AMOUNT"].ToString(); bill.NEW_AMOUNT_DR_CR_FLAG = row["NEW_AMOUNT_DR_CR_FLAG"].ToString(); bill.CLAIM_STATUS_CD = row["CLAIM_STATUS_CD"].ToString(); bill.SUBMIT_DT_TM = row["SUBMIT_DT_TM"].ToString(); bill.LAST_PAYMENT_DT_TM = row["LAST_PAYMENT_DT_TM"].ToString(); bill.LAST_ADJUSTMENT_DT_TM = row["LAST_ADJUSTMENT_DT_TM"].ToString(); bill.CLAIM_SERIAL_NBR = row["CLAIM_SERIAL_NBR"].ToString(); bill.TRANSMISSION_DT_TM = row["TRANSMISSION_DT_TM"].ToString(); bill.FROM_SERVICE_DT_TM = row["FROM_SERVICE_DT_TM"].ToString(); bill.TO_SERVICE_DT_TM = row["TO_SERVICE_DT_TM"].ToString(); bill.STATEMENT_TO_DT_TM = row["STATEMENT_TO_DT_TM"].ToString(); bill.STATEMENT_FROM_DT_TM = row["STATEMENT_FROM_DT_TM"].ToString(); return(bill); }