public static List <PftProration> GetPFTProration(string pftEncID)
{
DateTime todayDt = DateTime.Today;
StringBuilder sb = new StringBuilder();
sb.Append("Select health_plan_id,pft_encntr_id,priority_seq,curr_amt_due,curr_amount_dr_cr_flag from BAR_PFT_PRORATION ");
sb.Append("where pft_encntr_id = " + long.Parse(pftEncID) + " and active_ind = '1' ");
sb.Append("AND END_EFFECTIVE_DT_TM > '" + todayDt + "'");
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))
{
da.Fill(dt);
}
List <PftProration> prorations = new List <PftProration>();
foreach (DataRow row in dt.Rows)
{
PftProration proration = LoadProration(row);
if (proration != null)
{
prorations.Add(proration);
}
}
dt.Dispose();
return(prorations);
}
private static PftProration LoadProration(DataRow row)
{
PftProration proration = new PftProration();
proration.CurrAmtDue = CernerCommon.ConvertDecimalString(row["curr_amt_due"].ToString());
proration.CurrAmtDueFlg = row["curr_amount_dr_cr_flag"].ToString();
proration.HealthPlanID = row["health_plan_id"].ToString();
proration.PftEncntrID = row["pft_encntr_id"].ToString();
proration.PrioritySeq = row["priority_seq"].ToString();
return(proration);
}