internal static string GetUnusedCount()
{
string count = string.Empty;
using (SqlConnection con = DbUtilsDal.OpenConnection(DbUtilsDal.MainDB))
{
count = DbUtilsDal.ExecuteDataRow(con, "dbo.GetUnusedCount", new string[] { }, new SqlDbType[] { }, new object[] { })[0].ToString();
}
return(count);
}
internal static EmailRow GetEmail(string email)
{
DataRow row = null;
using (SqlConnection con = DbUtilsDal.OpenConnection(DbUtilsDal.MainDB))
{
row = DbUtilsDal.ExecuteDataRow(con, "dbo.GetEmail",
new string[] { "@Email" },
new SqlDbType[] { SqlDbType.VarChar },
new object[] { email });
}
return(EmailRow.ToEmailRow(row));
}