1private string AdToolsConnection = ConfigurationManager.AppSettings["DatabaseMode"];
2
3try
4        {
5            Database db = DatabaseFactory.CreateDatabase(AdToolsConnection);
6            string sqlCommand = "GetEmailStatus";
7            DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
8            db.AddInParameter(dbCommand, "GroupName", DbType.String, group);
9            using (IDataReader dataReader = db.ExecuteReader(dbCommand))
10            {
11                while (dataReader.Read())
12                {
13                    if (dataReader["EmailDate"] != null)
14                    {
15                        emailDate = dataReader["EmailDate"].ToString();
16                    }
17
18                    if (dataReader["ReplyDate"] != null)
19                    {
20                        responseDate = dataReader["ReplyDate"].ToString();
21                    }
22                }
23            }
24        }
25        catch (Exception)
26        {
27            throw;
28        }