Esempio n. 1
0
 internal static void UpdateUsedMails(long Mail_ID)
 {
     using (SqlConnection con = DbUtilsDal.OpenConnection(DbUtilsDal.MainDB))
     {
         DbUtilsDal.ExecuteDataRow(con, "dbo.UpdateUsedMails",
                                   new string[] { "@Mail_ID" },
                                   new SqlDbType[] { SqlDbType.BigInt },
                                   new object[] { Mail_ID });
     }
 }
Esempio n. 2
0
 internal static void InsertMail(string Mail_Value)
 {
     using (SqlConnection con = DbUtilsDal.OpenConnection(DbUtilsDal.MainDB))
     {
         DbUtilsDal.ExecuteDataRow(con, "dbo.InsertMail",
                                   new string[] { "@Mail_Value" },
                                   new SqlDbType[] { SqlDbType.VarChar },
                                   new object[] { Mail_Value });
     }
 }
Esempio n. 3
0
 internal static void UpdateBannerStats(long banner_id, string type)
 {
     using (SqlConnection con = DbUtilsDal.OpenConnection(DbUtilsDal.MainDB))
     {
         DbUtilsDal.ExecuteNonQuery(con, "dbo.UpdateBannerStats",
                                    new string[] { "@banner_id", "@type" },
                                    new SqlDbType[] { SqlDbType.BigInt, SqlDbType.VarChar },
                                    new object[] { banner_id, type });
     }
 }
Esempio n. 4
0
        internal static DataTable GetCVMails(long Mail_ID)
        {
            DataTable T = null;

            using (SqlConnection con = DbUtilsDal.OpenConnection(DbUtilsDal.MainDB))
            {
                T = DbUtilsDal.ExecuteDataTable(con, "dbo.GetCVMails",
                                                new string[] { "@Mail_ID" },
                                                new SqlDbType[] { SqlDbType.BigInt },
                                                new object[] { Mail_ID });
            }
            return(T);
        }
Esempio n. 5
0
        internal static DataRow GetMail(string Mail_Value)
        {
            DataRow R = null;

            using (SqlConnection con = DbUtilsDal.OpenConnection(DbUtilsDal.MainDB))
            {
                R = DbUtilsDal.ExecuteDataRow(con, "dbo.GetMail",
                                              new string[] { "@Mail_Value" },
                                              new SqlDbType[] { SqlDbType.VarChar },
                                              new object[] { Mail_Value });
            }
            return(R);
        }
Esempio n. 6
0
        internal static DataTable GetBannersByLocationId1(long location_Id, string cul)
        {
            DataTable T = null;

            using (SqlConnection con = DbUtilsDal.OpenConnection(DbUtilsDal.MainDB))
            {
                T = DbUtilsDal.ExecuteDataTable(con, "dbo.GetBannersByLocationId1",
                                                new string[] { "@location_Id", "@cul" },
                                                new SqlDbType[] { SqlDbType.BigInt, SqlDbType.Char },
                                                new object[] { location_Id, cul });
            }
            return(T);
        }