public static BarAccount GetBARAccount(string accountId) { StringBuilder sb = new StringBuilder(); sb.Append("SELECT pft_encntr_id, encntr_id, acct_id, pft_encntr_status_cd, "); sb.Append("disch_dt_tm, fin_class_cd, self_pay_edit_flag, "); sb.Append("active_ind, active_status_cd, active_status_dt_tm, "); sb.Append("adjustment_balance, applied_payment_balance, balance, charge_balance, "); sb.Append("last_charge_dt_tm, last_adjustment_dt_tm, last_payment_dt_tm, "); sb.Append("pft_encntr_alias, bill_status_cd, last_claim_dt_tm, last_stmt_dt_tm, "); sb.Append("zero_balance_dt_tm "); sb.Append("From pft_encntr "); sb.Append("WHERE acct_id = '" + accountId + "' "); 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); } BarAccount barAccount = null; if (dt.Rows.Count > 0) { barAccount = LoadBarAccount(dt.Rows[0]); } return(barAccount); }
private static BarAccount LoadBarAccount(DataRow dr) { BarAccount barAccount = new BarAccount(); return(barAccount); }