Ejemplos de DBSqlServer.AddParameter en C# (CSharp)

Ejemplo n.º 1

        private bool getKDInformation(DBSqlServer sql)
        {
            bool res = false;

            try
            {
                sql.SQLScript = "select id from packages where PackageType = 1 and DATEADD(day, 0, DATEDIFF(day, 0, CreateDate)) = @date";
                sql.AddParameter("@date", EnumDBDataTypes.EDT_DateTime, DateTime.Now.ToShortDateString());
                if (sql.ExecuteScalar() != null)
                {
                    return(true);
                }

                sql.SQLScript = "insert into packages(PackageType, CreateDate) values(1, getdate())";
                sql.ExecuteNonQuery();
                res = true;
            }
            catch (Exception ee)
            {
                res = false;
                Log.Write("getKDInformation " + ee.Message);
            }

            return(res);
        }