Esempio n. 1
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. 2
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);
        }