public static MPIOrganization GetOrganization(string organizationId)
{
StringBuilder sb = new StringBuilder();
sb.Append("SELECT organization_id, hcis, facility, mrnPrefix, acctPrefix, cernerPrefix ");
sb.Append("FROM MPIOrganization ");
sb.Append("WHERE organization_id = '" + organizationId + "' ");
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);
}
MPIOrganization org = null;
if (dt.Rows.Count > 0)
{
org = LoadMPIOrganization(dt.Rows[0]);
}
return(org);
}
private static MPIOrganization LoadMPIOrganization(DataRow row)
{
MPIOrganization org = new MPIOrganization();
org.Organization_id = row["organization_id"].ToString();
org.Hcis = row["hcis"].ToString();
org.Facility = row["facility"].ToString();
org.MRNPrefix = row["mrnPrefix"].ToString();
org.AcctPrefix = row["acctPrefix"].ToString();
org.CernerPrefix = row["cernerPrefix"].ToString();
return(org);
}
