public HcOrganizationEntity GetSingleHcOrganizationRecordById(object param)
{
Database db = DatabaseFactory.CreateDatabase();
string sql = "SELECT ID, Organizationname, Address, countryid, logo, isActive FROM HC_Organization WHERE Id=@Id";
DbCommand dbCommand = db.GetSqlStringCommand(sql);
db.AddInParameter(dbCommand, "Id", DbType.String, param);
HcOrganizationEntity hcOrganizationEntity = null;
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
hcOrganizationEntity = new HcOrganizationEntity();
if (dataReader["ID"] != DBNull.Value)
{
hcOrganizationEntity.Id = dataReader["ID"].ToString();
}
if (dataReader["Organizationname"] != DBNull.Value)
{
hcOrganizationEntity.Organizationname = dataReader["Organizationname"].ToString();
}
if (dataReader["Address"] != DBNull.Value)
{
hcOrganizationEntity.Address = dataReader["Address"].ToString();
}
if (dataReader["countryid"] != DBNull.Value)
{
hcOrganizationEntity.Countryid = dataReader["countryid"].ToString();
}
if (dataReader["logo"] != DBNull.Value)
{
hcOrganizationEntity.Logo = dataReader["logo"].ToString();
}
if (dataReader["isActive"] != DBNull.Value)
{
hcOrganizationEntity.Isactive = dataReader["isActive"].ToString();
}
}
}
return(hcOrganizationEntity);
}
