Exemplo n.º 1
0
        private bool CreateCompany(
            string companyName,
            string currentLogonName,
            string firstName,
            string lastName,
            string logonEmailAddress,
            string telephone,
            string password)
        {
            DbCommand sqlCommand = SqlDataManager.CreateCommand();

            sqlCommand.CommandText = "dbo.CompanyProvision";


            DbParameter paramTemp = sqlCommand.CreateParameter();

            paramTemp.ParameterName = "@pCompanyName";
            paramTemp.Value         = companyName;
            paramTemp.DbType        = DbType.String;
            sqlCommand.Parameters.Add(paramTemp);

            paramTemp.ParameterName = "@pCurrentLogonName";
            paramTemp.Value         = companyName;
            paramTemp.DbType        = DbType.String;
            sqlCommand.Parameters.Add(paramTemp);

            paramTemp.ParameterName = "@pFirstName";
            paramTemp.Value         = companyName;
            paramTemp.DbType        = DbType.String;
            sqlCommand.Parameters.Add(paramTemp);

            paramTemp.ParameterName = "@pLastName";
            paramTemp.Value         = companyName;
            paramTemp.DbType        = DbType.String;
            sqlCommand.Parameters.Add(paramTemp);

            paramTemp.ParameterName = "@pLoginEmailAddress";
            paramTemp.Value         = companyName;
            paramTemp.DbType        = DbType.String;
            sqlCommand.Parameters.Add(paramTemp);

            paramTemp.ParameterName = "@pTelephone";
            paramTemp.Value         = companyName;
            paramTemp.DbType        = DbType.String;
            sqlCommand.Parameters.Add(paramTemp);

            paramTemp.ParameterName = "@pPassword";
            paramTemp.Value         = companyName;
            paramTemp.DbType        = DbType.String;
            sqlCommand.Parameters.Add(paramTemp);


            int affectedRows = SqlDataManager.ExecuteNonQuery(sqlCommand);

            return(true);
        }