Пример #1
0
 internal static void UpdateCVMails()
 {
     using (SqlConnection con = DbUtilsDal.OpenConnection(DbUtilsDal.MainDB))
     {
         DbUtilsDal.ExecuteDataTable(con, "dbo.UpdateCVMails");
     }
 }
Пример #2
0
 internal static void CreateEmail(string email)
 {
     using (SqlConnection con = DbUtilsDal.OpenConnection(DbUtilsDal.MainDB))
     {
         DbUtilsDal.ExecuteNonQuery(con, "dbo.CreateEmail",
                                    new string[] { "@Email" },
                                    new SqlDbType[] { SqlDbType.VarChar },
                                    new object[] { email });
     }
 }
Пример #3
0
        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);
        }
Пример #4
0
        internal static List <EmailRow> GetCVMails()
        {
            DataTable rows = null;

            using (SqlConnection con = DbUtilsDal.OpenConnection(DbUtilsDal.MainDB))
            {
                rows = DbUtilsDal.ExecuteDataTable(con, "dbo.GetCVMails");
            }
            return(EmailRow.ToListEmailRows(rows));
        }
Пример #5
0
        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));
        }